This wiki has been automatically closed because there have been no edits or log actions made within the last 60 days. If you are a user (who is not the bureaucrat) that wishes for this wiki to be reopened, please request that at Requests for reopening wikis. If this wiki is not reopened within 6 months it may be deleted. Note: If you are a bureaucrat on this wiki, you can go to Special:ManageWiki and uncheck the "Closed" box to reopen it.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 Amendments.Status="{{{status|}}}" OR "{{{status}}} IS NULL
|order by=Policies.PolicyID
}}
| |||
Revision as of 11:49, 31 July 2021
Used to carry out a search on all amendments and new policies. Uses Form:Search Amendments Admin