The Policy Hub

Template:Search Amendments: Difference between revisions

← Older edit
Content deleted Content added
No edit summary
No edit summary
 
(44 intermediate revisions by the same user not shown)
Line 1:
<noinclude>Used to carry out a search on all amendments and new policies. Uses [[Form:Search Amendments Admin]]
</noinclude><includeonly>
 
{{#cargo_query:table=Amendments, Policies
|join on=Amendments.PolicyHeader=Policies._pageName
|fields=CONCAT("[https://thepolicyhub.org.uk/wiki/Special:FormEdit/Amendments/[", Amendments._pageName, "?returnto=BackSA |", Policies.PolicyID, "]]")=Policy ID , CONCAT("[https://thepolicyhub.org.uk/wiki/Special:FormEdit/Amendments/[", Amendments._pageName, "?returnto=BackSA |", Amendments.Description, "]]")=Amendment, Amendments.Type, CONCAT("[[", Policies._pageName, '|',Policies.Policy, "]]")=Original Policy, Amendments.Approved, Amendments.Status
|where=Policies.PolicyID LIKE "%{{{policyid|}}}%" AND Policies.Policy LIKE "%{{{policy|}}}%" AND Amendments.PolicyHeader=Policies._pageName AND Amendments.Status="{{{status|}}}" OR Amendments.Status=""
|orderAND by=Policies.PolicyIDPolicy LIKE "%{{{policy|}}}%"
AND Amendments.Status LIKE "{{{status|}}}%"
|order by=Policies.PolicyID,Amendments._pageName
}}
</includeonly>
<!-- Amendments.Status IS NULL OR-->
<!--AND Amendments.PolicyHeader=Policies._pageName-->

Latest revision as of 15:02, 4 August 2021

Used to carry out a search on all amendments and new policies. Uses Form:Search Amendments


Retrieved from "https://thepolicyhub.org.uk/wiki/Template:Search_Amendments?oldid=25751"