Generic Report Query

This page will provide an overview on how and when to use the GENERIC REPORT QUERY section in Report Builder

Overview

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.

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.

Workflow

1. Navigate to Reports > Report Builder menu. Load any Base Report/Saved Report.

2. After loading any Base/Saved Report, go to the Generic Report Query tab and enter/paste your generic query.

generic report query section in Report Builder

1. With your query entered/pasted on the space, you can now proceed to save the report or generate the result.

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.

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.