View source for User: Jose.druker@genesys.com/GEC DELTA MATRIX/Queries2

==Capabilities query used for first "publication"==
{{NoteFormat|Use the following link to download a CSV file: 
{{#cargo_query:
tables=GEcCap
|fields=IF( (Category LIKE "Dev and Rep"),"Admin, Development, and Reporting Tools",Category)=Category,Name=Name,CONCAT(IF(StatusAzure LIKE "%Planned%","Planned",IF(StatusAzure LIKE "%NA%","Not Applicable",IF(StatusAzure LIKE "%CONSOLIDATED%",CONCAT('Consolidated under ',CapabilityAzure),SUBSTRING(StatusAzure,3)))),'
 #azure<br/><br/>')=Genesys Engage cloud support on Azure,CONCAT(IF(StatusAWS LIKE "%NA%","Not Applicable",SUBSTRING(StatusAWS,3)),' #aws')=Genesys Engage cloud support on AWS,CONCAT(REPLACE(Notes,"/","/<wbr>"),IF(CapabilityAWS IS NOT NULL,IF(CapabilityAWS=Name,Name,CONCAT('<br/><br/><b>AWS capability name:</b> ',CapabilityAWS)),"") )=Notes,CONCAT( '[mailto:',REPLACE(SUBSTRING_INDEX(PM_SME,",",1)," ","."),'@genesys.com ',SUBSTRING_INDEX(PM_SME,",",1),']<br/>',IF( (PM_SME LIKE "%,%"), CONCAT('[mailto:',REPLACE(SUBSTRING_INDEX(PM_SME,",",-1)," ","."),'@genesys.com ',SUBSTRING_INDEX(PM_SME,",",-1),']'),""))=PM/SME
|where=_pageName LIKE "%Library/GEcCap%"
|format=csv
|limit=500
}}|2}}

{{#cargo_query:
tables=GEcCap
|fields=IF( (Category LIKE "Dev and Rep"),"Admin, Development, and Reporting Tools",Category)=Category,Name=Name,CONCAT(IF(StatusAzure LIKE "%Planned%","Planned",IF(StatusAzure LIKE "%NA%","Not Applicable",IF(StatusAzure LIKE "%CONSOLIDATED%",CONCAT('Consolidated under ',CapabilityAzure),SUBSTRING(StatusAzure,3)))),'
 #azure<br/><br/>')=Genesys Engage cloud support on Azure,CONCAT(IF(StatusAWS LIKE "%NA%","Not Applicable",SUBSTRING(StatusAWS,3)),' #aws')=Genesys Engage cloud support on AWS,CONCAT(REPLACE(Notes,"/","/<wbr>"),IF(CapabilityAWS IS NOT NULL,IF(CapabilityAWS=Name,Name,CONCAT('<br/><br/><b>AWS capability name:</b> ',CapabilityAWS)),"") )=Notes,CONCAT( '[mailto:',REPLACE(SUBSTRING_INDEX(PM_SME,",",1)," ","."),'@genesys.com ',SUBSTRING_INDEX(PM_SME,",",1),']<br/>',IF( (PM_SME LIKE "%,%"), CONCAT('[mailto:',REPLACE(SUBSTRING_INDEX(PM_SME,",",-1)," ","."),'@genesys.com ',SUBSTRING_INDEX(PM_SME,",",-1),']'),""))=PM/SME
|where=_pageName LIKE "%Library/GEcCap%"
|format=dynamic table
|rows per page=100
}}