User: Jdruker/GCXI PG CloudRestricted/TEST PREMISE DISPLAY

From Genesys Documentation
Jump to: navigation, search

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 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 7 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 "" 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
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

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
Result Code iWD > Agent
Interaction Subtype iWD > Agent
Interaction Type iWD > Agent