BomMultiText30 DB Location

Question

Home

Hi,

Does anybody know where in the Agile database the ‘Parts/Documents/BOM/BomMultiText30’ attribute lives? Which table holds this data?

Thanks in advance!

Brad

blevitan Agile User Asked on April 9, 2019 in Agile PLM (v9), Product Collaboration.

Add Comment

1 Answer(s)

Hi Brad

Check agile_flex table with attid = 1341 (baseid of that attribute). The row_id of the table points to the ID in BOM table

– Raj

rchinnia Agile Angel Answered on April 9, 2019.

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