AnsweredAssumed Answered

How to get change to request relationship data from Change table?

Question asked by manvi10 Employee on Oct 24, 2017
Latest reply on Oct 25, 2017 by Jon_Israel

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.

  1. 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

 

  1. Request Table

Request Number

Related Change Number

102

21

106

 

109

23

204

26

211

 

231

14

 

  1. 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

 

Outcomes