User: Marudhu.pandian@genesys.com/GCXI PG CloudRestricted2
Baseline to test GCXI_Attribute__displaysInFolder._value vs. displaysInFolder HOLDS[ | edit source]
GCXI_Attribute__displaysInFolder._value LIKE "iWD > Agent"[ | edit source]
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 |
GCXI_Attribute.displaysInFolder HOLDS LIKE "iWD > Agent"[ | edit source]
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 > Agent 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 |
Success?[ | edit source]
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 > Age[ | edit source]
attr | folder | displaysInFolder | displaysInFolder_Cloud | cloud |
---|---|---|---|---|
Age Range | iWD > Age | |||
Age Range 1 day | iWD > Age | |||
Age Range 1 hour | iWD > Age | |||
Age Range 15 min | iWD > Age | |||
Age Range 4 hour | iWD > Age | |||
Age Range 8 hour | iWD > Age | |||
Age Range Minutes | iWD > Age | |||
Age Range Week | iWD > Age |
Existing query for GCXIMCPRG:
attr | folder | displaysInFolder | displaysInFolder_Cloud | cloud |
---|---|---|---|---|
Age Range | iWD > Age | |||
Age Range 1 day | iWD > Age | |||
Age Range 1 hour | iWD > Age | |||
Age Range 15 min | iWD > Age | |||
Age Range 4 hour | iWD > Age | |||
Age Range 8 hour | iWD > Age | |||
Age Range Minutes | iWD > Age | |||
Age Range Week | iWD > Age | |||
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 |
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 |
Instructive failures of logic and/or syntax[ | edit source]
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 |