search

DBMS-Consulting / CQT2

0 stars 0 forks source link

Filter out LLT in not working correctly for SMQs. #545

Closed zmeenakshi closed 3 years ago

zmeenakshi commented 3 years ago

I think the code should exclude SMQs from PT expansion fix, because the PTs under SMQs are never expanded. Note: There are records where both PT and SMQ are present in the same record, this happens when PT is added from an SMQ. IA Export: 1) The IA Export shows LLTs for hierarchical SMQ if Filter out is checked on. 2) LLT is displayed in IA Export when a level 5 SMQ is added from the SMQ hierarchy. 3) PT is displayed in IA Export when a level 4 SMQ is added from the SMQ hierarchy. Impact_Assessment_Report_TME_SMQ4_SMQ5_ISSUE_TEST1.xlsx No issue in MQ Detailed Report. (Create, Update, Copy, B&S) 1) On checking on Filter out LLT checkbox, the expand icon is displayed for PTs under SMQ and PTs can be expanded. Expected: When Filter out LLT is checked, the expand icon should not displayed for PTs under SMQ and LLT should not be displayed. image 2) When Filter out LLT checkbox is not checked, PTs can be expanded to view LLTs under it and then LLT are displayed again after PTs. Expected: When Filter out LLT is not checked, the expand icon should NOT be displayed for PTs under SMQ and LLTs should be displayed as a list instead of hierarchy. image

Impact Assessment and Hierarchy Search (in All modules): 3)
a) When Filter out LLT is not checked: Expand icon is displayed in front of PTs, PTs cannot be expanded and LLTs are displayed after PTs. b) On Checking Filter out LLT: Expand icon is displayed in front of PTs. Expected: When Filter out LLT is not checked-on, the expand icon should NOT be displayed for PTs under SMQ and (LLTs should be displayed after PTs, not as a hierarchy. This part is working). image image 4) Impact Assessment: Unable to expand the (TME_CATEGORY_INACTIVE_TEST2) on checking Filter LLT checkbox. a) This is happening only in right panel as level 5 SMQ was added in IA, when a level 5 SMQ is added from IA. b) The SMQ5 is not displayed in IA left panel when Filter out LLT is checked-on, when a level 5 SMQ is added before moving list to IA. Note: It looks like the application is treating level 5 SMQ as LLT. No such issue in other modules. image

zmeenakshi commented 3 years ago

Issues pending: 1) Impact Assessment (Right panel): When a Filter Out LLT check-box is checked: PT can be expanded when a PT added from the PT search. No issue with PT added from SMQ. Once save the expansion is not displayed. The issues comes only when a new PT relation is added. image

2) IA Export: 1) The IA Export shows LLTs for hierarchical SMQ if Filter out is checked on. 2) LLT is displayed in IA Export when a level 5 SMQ is added from the SMQ hierarchy. 3) PT is displayed in IA Export when a level 4 SMQ is added from the SMQ hierarchy. Impact_Assessment_Report_TME_SMQ4_SMQ5_ISSUE_TEST1.xlsx

zmeenakshi commented 3 years ago

Add Selected button is disabled in IA right panel Hierarchy Search.

(No issue is MQ Detailed Report) In IA export: 1) The level is displayed as SMQ4 for PTs under SMQ. 2) The level is displayed as SMQ5 for LLTs under SMQ.

image image

In SMQ_RELATIONS_TARGET table: 1) If SMQ_LEVEL = 0 and PT_TERM_SCOPE is '0' (zero), the value of PT_TERM is an SMQ name. 2) If SMQ_LEVEL = 4, the value of PT_TERM is a PT name. 3) If SMQ_LEVEL = 5, the value of PT_TERM is an LLT name.

The SMQ_LEVEL is stored in SMQ_BASE_CURRENT.

zmeenakshi commented 3 years ago

Issue #554