# Generic Report Query

## Overview <a href="#overview" id="overview"></a>

If you are familiar with SQL, the data elements in Paradigm, and how to build queries from scratch, this feature could be your playground when it comes to extracting data or information to produce meaningful reports. This would require utmost care and responsibility though, not to anyway compromise your business or institution’s data in Paradigm.

{% hint style="danger" %}
**BE ADVISED**:

You are not allowed to extract or generate plain text passwords, unencrypted TFN, and all other information in Paradigm that requires safety and privacy, and would break privacy principles if generated irresponsibly.
{% endhint %}

## Workflow

1. Navigate to **Reports** > **Report Builder** menu. [**Load any** Base Report/Saved Report](/home/paradigm-knowledge-base/generating-reports/workflows/build-a-report/step-1-select-a-base-report.md).
2. After loading any Base/Saved Report, go to the **Generic Report Query** tab and enter/paste your generic query.

<figure><img src="/files/SQqn3z4P9tGEqOUJc3mN" alt=""><figcaption><p>generic report query section in Report Builder</p></figcaption></figure>

3. With your query entered/pasted on the space, you can now proceed to [save the report](/home/paradigm-knowledge-base/generating-reports/workflows/build-a-report/step-5-save-report.md) or [generate the result](/home/paradigm-knowledge-base/generating-reports/workflows/build-a-report/step-7-produce-report.md).

## View SQL of Existing Reports

As a guide in building your query, you can try loading any base or saved reports that are designed closer to the output that you want to produce and just edit or change some lines of the query that will meet your requirements, you can go to the **SAVE REPORT** section and click the **VIEW SQL** button.

<figure><img src="/files/BRl4GrrEPEaz6uyg1mpC" alt=""><figcaption></figcaption></figure>

After clicking the **VIEW SQL** button, it will then load the SQL Query of the report for your perusal.

To get rid of the SQL Query section, just click the **LOAD BASE REPORT** button to refresh the page and you’ll be ready to write or create your customised SQL query under the **GENERIC REPORT QUERY** section, and save and produce your report as required.


---

# 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.silverband.com.au/home/paradigm-knowledge-base/generating-reports/workflows/advanced-report-builder/generic-report-query.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.