Export Policies: Difference between revisions
no edit summary
Michaeldakin (talk | contribs) (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]...") |
Michaeldakin (talk | contribs) No edit summary |
||
(37 intermediate revisions by the same user not shown) | |||
Line 1:
{{#cargo_query:
|tables=Policies
|fields=
,_pageName
,PolicyID=Policies[policyid] ▼
,SUBSTRING( Category, 4)
,Policy=Policies[policy]▼
,SUBSTRING( SubCategory, 2)
,CONCAT( PolicyID, ' - ', Policy) = Policy
|where=Approval="Yes"
|order by=Stream,Category,SubCategory, Policy
|limit=840
|format=csv
|link text=Export all Policies
}}
<!--
,Category
{{#sub:{{{category|}}} |3}}
-->
|