User: Jdruker/GCXI PG CloudRestricted/TEST PREMISE DISPLAY
Existing query looking for pageName AND (GCXI_Attribute.folder LIKE "iWD > Agent" OR GCXI_Attribute__displaysInFolder._value LIKE "iWD > Agent") AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) -- 9 results
Existing query for GCXIMCPRG:
attr | folder | displaysInFolder | displaysInFolder_Cloud | cloud |
---|---|---|---|---|
Agent Name | iWD > Service Objects | iWD > Agent | ||
Custom Dimension | iWD | iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | "none" | |
Department | iWD | iWD > Age • iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | none | |
Employee ID | iWD > Agent | |||
Interaction Subtype | iWD > Agent | |||
Interaction Type | iWD > Agent | |||
Process | iWD | iWD > Age • iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | "none" | yes |
Result Code | iWD > Agent |
Looking for pagename AND (GCXI_Attribute.folder LIKE "iWD > Agent" OR GCXI_Attribute.displaysInFolder HOLDS LIKE "iWD > Agent") AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) -- 9 results
Trying to include folder=iWD and displaysInFolder=iWD > Agent:
attr | folder | displaysInFolder | displaysInFolder_Cloud | cloud |
---|---|---|---|---|
Agent Name | iWD > Service Objects | iWD > Agent | ||
Custom Dimension | iWD | iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | "none" | |
Department | iWD | iWD > Age • iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | none | |
Employee ID | iWD > Agent | |||
Interaction Subtype | iWD > Agent | |||
Interaction Type | iWD > Agent | |||
Process | iWD | iWD > Age • iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | "none" | yes |
Result Code | iWD > Agent |
Looking for pagename AND (GCXI_Attribute.folder LIKE "iWD > Agent" OR GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "iWD > Agent" OR GCXI_Attribute.displaysInFolder HOLDS LIKE "iWD > Agent") AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) -- 9 results
attr | folder | displaysInFolder | displaysInFolder_Cloud | cloud |
---|---|---|---|---|
Agent Name | iWD > Service Objects | iWD > Agent | ||
Custom Dimension | iWD | iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | "none" | |
Department | iWD | iWD > Age • iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | none | |
Employee ID | iWD > Agent | |||
Interaction Subtype | iWD > Agent | |||
Interaction Type | iWD > Agent | |||
Process | iWD | iWD > Age • iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | "none" | yes |
Result Code | iWD > Agent |
Looking for pagename and (GCXI_Attribute.folder LIKE "iWD > Agent" OR (GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "iWD > Agent" OR GCXI_Attribute.displaysInFolder_Cloud HOLDS NOT "none" AND GCXI_Attribute.displaysInFolder HOLDS LIKE "iWD > Agent")) AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) -- should be 7 results
attr | folder | displaysInFolder | displaysInFolder_Cloud | cloud |
---|---|---|---|---|
Custom Dimension | iWD | iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | "none" | |
Employee ID | iWD > Agent | |||
Interaction Subtype | iWD > Agent | |||
Interaction Type | iWD > Agent | |||
Process | iWD | iWD > Age • iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | "none" | yes |
Result Code | iWD > Agent |
Looking for pagename AND (GCXI_Attribute.folder LIKE "iWD > Agent" OR (GCXI_Attribute.displaysInFolder HOLDS LIKE "iWD > Agent" AND (GCXI_Attribute.displaysInFolder_Cloud HOLDS NOT "" OR GCXI_Attribute.displaysInFolder_Cloud HOLDS NOT "none" OR GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "iWD > Agent"))) AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) -- should be 7 results
attr | folder | displaysInFolder | displaysInFolder_Cloud | cloud |
---|---|---|---|---|
Custom Dimension | iWD | iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | "none" | |
Department | iWD | iWD > Age • iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | none | |
Employee ID | iWD > Agent | |||
Interaction Subtype | iWD > Agent | |||
Interaction Type | iWD > Agent | |||
Process | iWD | iWD > Age • iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | "none" | yes |
Result Code | iWD > Agent |
IS THIS IT?
Looking for pagename AND IF(GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "%%",(GCXI_Attribute.folder LIKE "iWD > Agent" OR GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "iWD > Agent"),(GCXI_Attribute.folder LIKE "iWD > Agent" OR GCXI_Attribute.displaysInFolder HOLDS LIKE "iWD > Agent")) AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) -- no diffs if the interior IF clauses are not in brackets
attr | folder | displaysInFolder | displaysInFolder_Cloud | cloud |
---|---|---|---|---|
Agent Name | iWD > Service Objects | iWD > Agent | ||
Employee ID | iWD > Agent | |||
Interaction Subtype | iWD > Agent | |||
Interaction Type | iWD > Agent | |||
Result Code | iWD > Agent |
Testing iWD > Classification[ | edit source]
attr | folder | displaysInFolder | displaysInFolder_Cloud | cloud |
---|---|---|---|---|
Category | iWD > Classification | |||
Customer Segment | iWD > Classification | |||
Media Channel | iWD > Classification | |||
Product | iWD > Classification | |||
Product Subtype | iWD > Classification | |||
Source Process | iWD > Classification | |||
Source Process Subtype | iWD > Classification | |||
Source Tenant | iWD > Classification |
Existing query for GCXIMCPRG:
attr | folder | displaysInFolder | displaysInFolder_Cloud | cloud |
---|---|---|---|---|
Category | iWD > Classification | |||
Custom Dimension | iWD | iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | "none" | |
Customer Segment | iWD > Classification | |||
Department | iWD | iWD > Age • iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | none | |
Media Channel | iWD > Classification | |||
Process | iWD | iWD > Age • iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | "none" | yes |
Product | iWD > Classification | |||
Product Subtype | iWD > Classification | |||
Source Process | iWD > Classification | |||
Source Process Subtype | iWD > Classification | |||
Source Tenant | iWD > Classification |