To find count of changes for each category along with count of changes initiated from Requests, how to get change to request relationship data from Change table?
As ‘chg’ object (change table) has only BREL relation with ‘cr’ object (Call_req table) as below,
cr_list BREL <- cr.change {change = ?}
DYNAMIC { DOMSET cr_list; WHERE change = ? ; PARAM_NAMES id; }
caused_cr_list BREL <- cr.caused_by_chg {caused_by_chg = ?}
DYNAMIC { DOMSET cr_list; WHERE caused_by_chg = ? ; PARAM_NAMES id; }
And in other hand from request to change relationship data is available. As ‘cr’ object (Call_req table) has SREL relation with ‘chg’ object (change table) as below,
change SREL -> chg.id DISPLAY_NAME "Change" UI_INFO "+AUDITLOG()"
change_f LOCAL INTEGER UI_INFO "+AUDIT_FLAG()" ON_DB_INIT {0}
caused_by_chg SREL -> chg.id DISPLAY_NAME "Caused by Change Order" UI_INFO "+AUDITLOG()"
caused_by_chg_f LOCAL INTEGER UI_INFO "+AUDIT_FLAG()" ON_DB_INIT {0}
E.g.
- Change table
Change Number | Category | Group |
11 | Minor | FO-SD |
21 | Major | FO-SD |
22 | Major | FO-SD |
23 | Emergency | FO-Infosys SD |
26 | Minor | FO-Infosys SD |
10 | Minor | FO-Infosys SD |
14 | Major | FO-Infosys SD |
- Request Table
Request Number | Related Change Number |
102 | 21 |
106 | |
109 | 23 |
204 | 26 |
211 | |
231 | 14 |
- Required Change Data Table
Group | Category | Count of changes | Count of changes initiated from requests |
FO-SD | Minor | 1 | 0 |
| Major | 2 | 1 |
FO-Infosys SD | Emergency | 1 | 0 |
| Minor | 2 | 1 |
| Major | 1 | 0 |