Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

GVARSQL - shows the SQL used on Custom

Status

Status
titleASSESSING

Owner

Scheduling Coordinator

Contributors

Jordan Lamb John Zamora (Unlicensed)

Goals

Assess the difference between Baseline and Custom XB reports. Assess deficiencies w/ Custom Report and recommend implementation of Baseline Business Practices.

Jira tickets

Jira Legacy
serverSystem JIRA
columnskey,summary,type,created,updated,assignee,priority,status,resolution
maximumIssues20
jqlQuerylabels = "XB"
serverId8b861ae3-ff87-316b-a17e-97c61a7e2fb4

On this page

Table of Contents
maxLevel2
minLevel2

Global

Custom WHERE filter

...

Code Block
AND A.SCBCRSE_SUBJ_CODE NOT IN
   ('CLEP','TRNS','AP','AML1','CAR1','BB','CED1','CER1','HFW1','MED1')    -- COS change        ADDED
 AND (SCBCRSE_SUBJ_CODE || SCBCRSE_CRSE_NUMB <> 'LIBR490AB')
 --COS  Above 2 lines added 
  •  Jordan Lamb Ask Daniel Alvarado if any SCBCRSE_SUBJ_CODE = ('CLEP', ‘TRNS’, ‘AP’, ‘AML1’, ‘CAR1’, ‘BB’. ‘CED1’, ‘CER1’, ‘HFW1’,'MED1’) are still active on the catalog level. If not, then we can remove this line of code.

...