Workflow table

Question

Home

can anybody tell me what is the name of table where workflow state id s and their description stored in agile plm database?

YP Agile Expert Asked on March 3, 2015 in Agile PLM (v9), Product Collaboration.

Add Comment

1 Answer(s)

Its usually stored in Change table with column name as WORKFLOW_ID and STATUSTYPE

YP Agile Expert Answered on March 3, 2015.

I am looking for status type description so i wanted to know where it is stored in Database, in changes table only code is stored

on March 3, 2015.

You’ll find the descriptions in the NODETABLE.

on November 8, 2017.

Add Comment

Answer 1

As noted by stevend17, AGILEOBJECTIDSEQUENCE was used to generate the ID for all tables in the database. For everything up...

Answer 2

Hoo boy, you aren't asking for much, are you?? I would venture that it cannot be done as "one query result"....

Answer 3

Based on a script I created years ago to correct sequence values after cloning from a production environment to a...

Answer 4

We may not share the same version of Agile, because I cannot find "Complaints" as a class. If indeed Complaints...

Answer 5

Svevis, I'm not certain I can help or not, but to even start I have some questions. What is the...

Answer 6

As noted by stevend17, AGILEOBJECTIDSEQUENCE was used to generate the ID for all tables in the database. For everything up...

Answer 7

Hoo boy, you aren't asking for much, are you?? I would venture that it cannot be done as "one query result"....

Answer 8

Based on a script I created years ago to correct sequence values after cloning from a production environment to a...

Answer 9

We may not share the same version of Agile, because I cannot find "Complaints" as a class. If indeed Complaints...

Answer 10

Svevis, I'm not certain I can help or not, but to even start I have some questions. What is the...