Export Policies: Difference between revisions
Content added Content deleted
Michaeldakin (talk | contribs) No edit summary |
Michaeldakin (talk | contribs) No edit summary |
||
(7 intermediate revisions by the same user not shown) | |||
Line 2: | Line 2: | ||
|tables=Policies |
|tables=Policies |
||
|fields=Stream |
|fields=Stream |
||
,_pageName |
|||
,SUBSTRING( Category, 4) |
,SUBSTRING( Category, 4) |
||
,SUBSTRING( SubCategory, 2) |
,SUBSTRING( SubCategory, 2) |
||
,CONCAT( PolicyID, ' - ', Policy) = Policy |
,CONCAT( PolicyID, ' - ', Policy) = Policy |
||
|where=Approval="Yes" |
|where=Approval="Yes" |
||
|order by=Stream,Category,SubCategory |
|order by=Stream,Category,SubCategory, Policy |
||
|limit=840 |
|limit=840 |
||
|format=csv |
|format=csv |