Generic Report Query
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 password, unencrypted TFN, and all other information in Paradigm which requires safety and privacy, and would break privacy principles if generated irresponsibly.
As a guide in building your own query, you can try loading any base or saved reports which 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.
INFO: 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.
Â
Advanced Report Builder | Order By Clauses | Alternative Data Formats | Bulk Student Select | Complex Filter Clause Operators | Nested Operators Using Brackets | User-Defined Parameters | Summarise Data | Generic Report Query
Â
Â