Query Placeholders

The advantage of using placeholders is the values only need to be updated in the Report Settings Admin page and this will automatically feed through to any SQL that uses the placeholder variable.

To open the placeholder admin section go to Admin and Settings. Scroll down to Report Settings.

To add a new place holder enter a name under New Query Placeholders and click Add. Scroll to the bottom of Report Settings and the placeholder will be available. (A refresh of the page may be required).

Type or copy text for the values to be included in the placeholder and click Add.

To remove a value from the place holder click the small x to the right of the name.

In the SQL where clause use the format {{placeholdername}} as shown.

To remove a placeholder then click Delete beside the placeholder name.

In the latest version of default tiles, the placeholders used are as follows.

{{REPAIRSCONTRACTS}}

{{VOIDCONTRACTS}}

{{GASCONTRACTS}}

{{URGENTJOBTYPES}}

{{EMERGENCYJOBTYPES}}

{{ROUTINEJOBTYPES}}

{{NOACCESS}}

{{OPENSTATUS}}

{{COMPLETESTATUS}}

{{ONSITE}}

{{OTHERPARTS}}

{{NOTRADES}}