Export Policies: Difference between revisions

no edit summary
No edit summary
No edit summary
 
(31 intermediate revisions by the same user not shown)
Line 1:
{{#cargo_query:
|tables=Policies
|fields=PolicyStream
,_pageName
,Category=Policies[category]
,SUBSTRING( Category, 4)
,SubCategory=Policies[subcategory]
,SUBSTRING( SubCategory, 2)
,Description=Policies[description]
,CONCAT( PolicyID, ' - ', Policy) = Policy
,CharterItem=Policies[charteritem]
|where=Approval="Yes"
,KeyPolicyid=Policies[keypolicyid]
|order by=Stream,Category,SubCategory, Policy
,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}}
 
 
,CategoryApproval=Policies[categoryapproval]
,StreamStatus=Policies[streamstatus]
-->