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 Angel Asked on January 3, 2019 in IT and Networking.
Add Comment
5 Answer(s)

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



Agile Professional Answered on January 4, 2019.

Thanks Raj

on January 9, 2019.
Add Comment

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.

Agile Angel Answered on January 4, 2019.

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

on January 4, 2019.

Thanks Kevin. This really helps!!

on January 9, 2019.
Add Comment

And here are the ITEM table flag bit positions, as of 9340.

Agile Angel Answered on January 4, 2019.
Add Comment

And here are the CHANGE table flag bit positions, as of 9340.

Agile Angel Answered on January 4, 2019.
Add Comment

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

Agile Professional Answered on January 4, 2019.

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.

on January 8, 2019.

Thanks Kevin for the info. Appreciate it

i will look around in my instance

on January 9, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.