Modify MQ Detailed Report (MS-Excel Report)

[zmeenakshi]

Module: Create, Update, Copy and Browse

=> MQ Detailed Report: 1) Header information – Remove ‘description’, ‘source’ and ‘note’ from the report.

2) Sorting – The terms should be sorted using the following default: 2a) By the column ‘Level’ using a custom list of SMQ1, SMQ2, SMQ3, SMQ4, SMQ5, SOC, HLGT, HLT, PT, LLT. 2b) By the column ‘Term’ alphabetically (obviously for this report the upper-level term is sorted (Note: the order of the terms that belong to upper-level term are retained beneath).

3) Formatting (Hightlight top level term added to List) – It useful to highlight the upper-level terms (SMQs, HLGTs, HLTs) for ease of reading the report. (Note: highlight the upper-level terms specifically added to the list – so if a HLGT is added to the list, ONLY highlight HLGT not the HLTs beneath it.)

[zmeenakshi]

EXPECTED_Relations_MQ_Detailed_Report_PT_GOUT_UNIQUE.xlsx CURRENT_Relations_MQ_Detailed_Report_PT_GOUT_UNIQUE.xlsx

[zmeenakshi]

Report output is as expected: 1) Removed Description, Notes and Source 2) Output sorted by column Level 3) Sorted by column Term 4) Hightlighted top-level terms (the terms added to the List)

Relations_MQ_Detailed_Report_REPORT_CHANGE_TEST13.zip

[zmeenakshi]

Fixed sorting issue for Hierarchical lists Relations_MQ_Detailed_Report_TME_TEST1_11OCT2022 (3).zip Relations_MQ_Detailed_Report_PRO_TEST2_11OCT2022 (3).zip Relations_MQ_Detailed_Report_COPY_IMPACTED_CPT_LIST (2).zip