Finding a field in the database

Question

Home

Does anyone know what table a field ‘notes’ on page2 of items is inside of the database.

bigjoshmoney Agile User Asked on May 7, 2021 in Agile PLM (v9).

Add Comment

2 Answer(s)

Hello

It would be in agile_flex table

Sample query

select * from agile.agile_flex where attid = 1080 and class = 9000 (for doc and 10000 for part) and id = item_id

– Raj

rchinnia Agile Angel Answered on May 7, 2021.

Add Comment

Raj, You have made my day!

bigjoshmoney Agile User Answered on May 7, 2021.

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...