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

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