What is Flags field in BOM, REV tables?
I used it to get the latest records (i.e. substr(flags,5,1) got reference from one of the answers), but still did not find any documentation to know all its values and meaning. And why this field in binary (or not)?
Agile uses FLAGS field in several tables. it helps Agile show the indicators in the UI. For example, using the flags in REV, it can display indicators like Item has attachment, AML, BOM, pending changes, deviations, etc for the selected Rev
No documentation exist. Several of us have found out some of the flag bits the hard way
One reasoning as to why it uses these these flag bits is it allows them to add further indicators without creating new columns. Purely a design choice
Hope this helps
As Raj noted, there is no published documentation on the structure of the FLAGS attribute, for any table. But they are used as 0/1 (or No/Yes) indicators as to specific things about the item/change/revision/bom record that has the FLAGS value. As to why it is in 0/1 notation, it because it is easy to use in SQL queries (as you have done) to get specific things.
There is a file named “CMType.java” that details all sorts of flag position definitions (and MANY other things). I have attached the bit position definitions for the REV table. Note that position “0” is the first bit in the 32-character string. If I can get this to work, I will also get the ITEM/CHANGE/BOM flag bit positions put up here.