Export Policies: Difference between revisions

no edit summary
No edit summary
No edit summary
 
(22 intermediate revisions by the same user not shown)
Line 1:
{{#cargo_query:
|tables=Policies
|fields=PolicyStream
,_pageName
,Category
,SUBSTRING( Category, 4)
,SUBSTRING( SubCategory , 2)
,Stream
,CONCAT( PolicyID, ' - ', Policy) = Policy
,Approval=Policies[approval]
|where=Approval="Yes"
,Status=Policies[status]
|order by=Stream,Category,SubCategory, Policy
|limit=840
|format=csv
|link text=Export all Policies
}}
 
 
<!--
,Category
{{#sub:{{{category|}}} |3}}
 
 
,Approval=Policies[approval]
,Status=Policies[status]
-->