Agile DataBase
Point 1.
In Agile User profile, we have one escalation tab where two columns are there one is “Criteria” and Second is “Notify Users”. I want to make a report on that for all the active users.
Point 2.
User needs a report which will display Red lined Components in various ECOs which are ready to release. This report is used for internal monitoring purpoose by their superwiser.
1. Criteria is a bit tricky. Here is how I believe the tables are put together:
a. Criteria appears to be grouped by query_id in the criteria table with each line in the criteria having its own row. You can select out the specific criteria by query_id and order by row_id
b. attr_id can be found in nodetable where id=<attr_id>
c. relational_op can be found in listentry where parentid=4453 and entryid=<the criteria’s op>
d. logical_op can be found in listentry where parentid=4454 and entryid=<the criteria’s op>
This looks like it will be a pain to work with from the database – good luck
2. From what I can tell the BOM redlines are created in the application layer using the change in, out and prior BOM columns in the BOM table.