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)?
Hi Vaibhav
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
Thanks
Raj
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.
Here are the BOM table flag bit positions. I think this is as of 9310 :
Bit Meaning
0 Parent assembly is mark-deleted assembly soft-deleted
1 Component is mark-deleted item record no longer exists or soft-deleted
2 Component is redline-deleted item redlined from BOM
3 Change_in is either 0 or points to a released ECO BOM is released
4 Component is included in the default (latest) rev BOM is latest
Thanks for the info. Where is this file CMType.java located? Also, I am not able to view your attachment. I get a Forbidden error
They do seem to be having issues with attached files. First I couldn’t attach anything, and now folks cannot see them. When I clicked on the link, I got a directory list of files that do not include what I attached. I will contact the admins……….
CMType.java is not available to the general public, I first got it from Engineering when I worked for Oracle back in 2011. But you can find the .class file embedded in various .jar files in the <AGILE_HOME>\agileDomain\lib directory. I found it in wlsauth.jar and then followed the class path down to the file (wlsauth.jar\com\agile\resources\constants\CMType.class). You need to know your way around .jar files and such, and also to have a Java de-compiler so you can view the actual text of the .class file.