AnsweredAssumed Answered

Need a report for change order in MS SQL DB.

Question asked by dasja02 Employee on Jun 8, 2018
Latest reply on Jun 17, 2018 by dasja02

Dear Team,

I need a report for Change order from MS SQL DATABASE showing :

  • CO ref number
  • Summary
  • Category
  • Status
  • Phase
  • Assigned to
  • Change type
  • Open date
  • Close date
  • Projected violation 
  • Group 
  • Risk
  • Schedule Start date
  • Schedule end date

My query:

SELECT chg.chg_ref_num as ChangeOrder_ref_num,

chg.Summary,

chg.Category,

chg.Status,

chg.Open_date,

chg.Close_date,

chg.Assignee,

chg.Risk,

chg.Sched_start_date,

chg.Sched_end_date

 

FROM chg;

 

Please help me for getting the Configuration items attached with Change order ticket in report along with phase, change type,Violation,Group.

 

Regards,

Jagatjyoti Dash

Outcomes