cancel
Showing results for 
Search instead for 
Did you mean: 

Table, field where user status for task located

Former Member
0 Kudos

Hi, collegues,

Could you help me to find Table and field, where user status data for cProject task located.

BR, Alexey.

Accepted Solutions (1)

Accepted Solutions (1)

former_member201206
Active Contributor
0 Kudos

Hi,

the table is CRM_JEST.  User status has internal number E0001 or E0002 .... In order to retrieve it, you need the guid of the task.

With report dpr_get_tree, you get involved records with 1 go.

Kind regards,

Zhenbo


Answers (1)

Answers (1)

Former Member
0 Kudos

Thank you, I implement the report (dpr_get_tree) mandatory as soon as i can, but now it is not installed. Could you help me with one more specifying question: which table contain user scheme, which specified for the task.

former_member201206
Active Contributor
0 Kudos

Hi  Alexey,

I think, you refer the status profil. It is stored in CRM_JSTO, field 'StatProf' , Once you have the task guid, then you can retrieve it.

Kind regards,

Zhenbo