Export Policies: Difference between revisions
Content added Content deleted
Michaeldakin (talk | contribs) No edit summary Tag: Reverted |
Michaeldakin (talk | contribs) No edit summary |
||
(29 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
{{#cargo_query: |
{{#cargo_query: |
||
|tables=Policies |
|tables=Policies |
||
|fields= |
|fields=Stream |
||
,_pageName |
|||
⚫ | |||
,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 |
|||
⚫ | |||
⚫ | |||
,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 |
|limit=840 |
||
|format=csv |
|||
|link text=Export all Policies |
|link text=Export all Policies |
||
}} |
}} |
||
<!-- |
|||
⚫ | |||
{{#sub:{{{category|}}} |3}} |
|||
⚫ | |||
⚫ | |||
--> |