Skip to main content
Solved

Non project code description


Forum|alt.badge.img

Is there a place or even a method to provide the Non-Project Code a Description in Project Preferences?

If so, where can I go to do that?
 

 

Best answer by darylbowman

I don’t know of any in the UI. However, the Non-Project code is a row in the Contract table (where ContractID = 0). You could use a SQL script to set Contract.Description.

Note that unless it is changed from the default ‘X’ value, the only ‘non-project’ row will be in CompanyID 1. When the value is changed from ‘X’ to something else, a row is added for the current tenant.

UPDATE Contract
SET Description = 'some gnarly text'
WHERE CompanyID = 2 AND ContractID = 0

I’m obviously not responsible for you nuking your database.

View original
Did this topic help you find an answer to your question?

2 replies

darylbowman
Captain II
Forum|alt.badge.img+13
  • 1712 replies
  • Answer
  • June 4, 2024

I don’t know of any in the UI. However, the Non-Project code is a row in the Contract table (where ContractID = 0). You could use a SQL script to set Contract.Description.

Note that unless it is changed from the default ‘X’ value, the only ‘non-project’ row will be in CompanyID 1. When the value is changed from ‘X’ to something else, a row is added for the current tenant.

UPDATE Contract
SET Description = 'some gnarly text'
WHERE CompanyID = 2 AND ContractID = 0

I’m obviously not responsible for you nuking your database.


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3407 replies
  • June 4, 2024

@NetAdmin42  No, in my opinion, we cannot provide the description for the X project/Non-Project-Code.

As soon as you configure in the Project Preferences, it takes the description as Non-Project Code by default.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings