# 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. 

![](/files/-LgbDR3oundWHXMLie4S)

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

![](/files/-LgbEqQfTpa2ibI95bN_)

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).

![](/files/-LgbGcHtplQYBelJ7W2N)

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

![](/files/-LgbHBlpeh0U_6VLSJgz)

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.

![](/files/-LgbHpLjaUEsRqhHFiOQ)

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}}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.accuserv.cloud/administration/tile-reports/query-placeholders.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.