User: Jdruker/GCXI PG CloudRestricted2

From Genesys Documentation
Jump to: navigation, search

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