Export Policies: Difference between revisions

no edit summary
(Created page with "{{#cargo_query: |tables=Policies |fields=_pageName=Title ,PolicyID=Policies[policyid] ,Policy=Policies[policy] ,Category=Policies[category] ,SubCategory=Policies[subcategory] ,Description=Policies[description] ,CharterItem=Policies[charteritem] ,KeyPolicyid=Policies[keypolicyid] ,Stream=Policies[stream] ,Approval=Policies[approval] ,OriginalPolicy=Policies[originalpolicy] ,Status=Policies[status] ,PolicyPaper=Policies[policypaper] ,SupportDocs1=Policies[supportdocs1]...")
 
No edit summary
 
(37 intermediate revisions by the same user not shown)
Line 1:
{{#cargo_query:
|tables=Policies
|fields=_pageName=TitleStream
,_pageName
,PolicyID=Policies[policyid]
,SUBSTRING( Category, 4)
,Policy=Policies[policy]
,SUBSTRING( SubCategory, 2)
,Category=Policies[category]
,CONCAT( PolicyID, ' - ', Policy) = Policy
,SubCategory=Policies[subcategory]
|where=Approval="Yes"
,Description=Policies[description]
|order by=Stream,Category,SubCategory, Policy
,CharterItem=Policies[charteritem]
,KeyPolicyid=Policies[keypolicyid]
,Stream=Policies[stream]
,Approval=Policies[approval]
,OriginalPolicy=Policies[originalpolicy]
,Status=Policies[status]
,PolicyPaper=Policies[policypaper]
,SupportDocs1=Policies[supportdocs1]
,SupportDocs2=Policies[supportdocs2]
,SupportDocs3=Policies[supportdocs3]
,UpdatedBy=Policies[updatedby]
,DateUpdated=Policies[dateupdated]
|limit=840
|format=csv
|link text=Export all Policies
}}
 
 
<!--
,Category
{{#sub:{{{category|}}} |3}}
 
 
,PolicyIDApproval=Policies[policyidapproval]
,PolicyStatus=Policies[policystatus]
-->