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 | cloud |
|---|---|---|---|
| Agent Name | iWD > Service Objects | iWD > Agent | |
| Custom Dimension | iWD | iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | |
| Department | iWD | iWD > Age • iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | |
| Employee ID | iWD > Agent | ||
| Interaction Subtype | iWD > Agent | ||
| Interaction Type | iWD > Agent | ||
| Process | iWD | iWD > Age • iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | 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 | cloud |
|---|---|---|---|
| Agent Name | iWD > Service Objects | iWD > Agent | |
| Custom Dimension | iWD | iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | |
| Department | iWD | iWD > Age • iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | |
| Employee ID | iWD > Agent | ||
| Interaction Subtype | iWD > Agent | ||
| Interaction Type | iWD > Agent | ||
| Process | iWD | iWD > Age • iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | 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 but different order
| attr | folder | displaysInFolder | displaysInFolder_Cloud | cloud |
|---|---|---|---|---|
| Agent Name | iWD > Service Objects | iWD > Agent | ||
| Employee ID | iWD > Agent | |||
| Result Code | iWD > Agent | |||
| Interaction Subtype | iWD > Agent | |||
| Interaction Type | 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 | |
| Process | iWD | iWD > Age • iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | "none" | yes |
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 8 results
| attr | folder | displaysInFolder | displaysInFolder_Cloud | cloud |
|---|---|---|---|---|
| Employee ID | iWD > Agent | |||
| Result Code | iWD > Agent | |||
| Interaction Subtype | iWD > Agent | |||
| Interaction Type | iWD > Agent | |||
| Custom Dimension | iWD | iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | "none" | |
| Process | iWD | iWD > Age • iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | "none" | yes |
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 "none") OR GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "iWD > Agent") AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) -- should be 8 results
| attr | folder | displaysInFolder | displaysInFolder_Cloud | cloud |
|---|---|---|---|---|
| Employee ID | iWD > Agent | |||
| Result Code | iWD > Agent | |||
| Interaction Subtype | iWD > Agent | |||
| Interaction Type | iWD > Agent | |||
| Custom Dimension | iWD | iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | "none" | |
| Process | iWD | iWD > Age • iWD > Agent • iWD > Capture • iWD > Classification • iWD > Queue | "none" | yes |