Template:Search Amendments: Difference between revisions
Content deleted Content added
Michaeldakin (talk | contribs) No edit summary |
Michaeldakin (talk | contribs) No edit summary |
||
Line 5:
|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
|order by=Policies.PolicyID
}}
|
Revision as of 11:48, 31 July 2021
Used to carry out a search on all amendments and new policies. Uses Form:Search Amendments Admin