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 |