Raw SQL Reports

Raw SQL Reports is a premium feature that allows you to create reports in Apricot by typing a SQL (Standard Query Language) statement into a report section, instead of dragging in columns as you would in a traditional report. SQL queries can expand the options available for reporting. Please note: SQL features in Apricot cover advanced Select statements but do not allow for Update, Insert, or Delete functions. Please check out our article on the Import Tool for updating or creating records in bulk.

Do You Have Access to Raw SQL Reports?

Raw SQL Reports is a premium feature, which means it is not available in every Apricot.

  1. To find out if you have access to this feature, click the Administrator tab at the top of the page.
  2. In the left hand menu, select Apricot Settings.
  3. Scroll down to the section called "A La Carte Features" and check that Raw SQL Reports has been enabled.

If you do not have access to this feature but would like to have it turned on for an additional fee, please contact the Apricot Customer Support team.

Add a SQL Section to a Report

To add a SQL section to a report, create a new report or open an existing report for editing in the Report Builder.

  1. In the Report Actions palette, select "Create New SQL Section." This will add a new blank text box to your report where you can enter a SQL query.
  2. Click into the text box and begin typing to enter your query to the report.
  3. When you are finished, click Publish Report to allow your users access to these results.

Using a SQL Report as a Data Dictionary

SQL queries can be written to satisfy a wide variety of reporting needs. A simple SQL query can create a "data dictionary" that describes the back-end labels given to each field in your Apricot database. This information can be useful if you need to reference this information in a different SQL report.

  1. Click into the text box and begin typing the SQL query. When you have finished, click out of the box to display the new SQL table.

Basic SQL Statement

Once this feature is turned on, you will also have access to view the SQL for your standard reports.

  1. Open the section properties for any report section,
  2. Expand the "Basic SQL Statement" option at the bottom of the properties window

Note: Raw SQL Sections are not supported in Ongoing Support. For any consultation time for this feature it will need to be purchased. Please contact your account manager for more information.

Did this answer your question?