IRP Admin
Common Tasks (1)
Open
Interventions (1)
Open
Languages (1)
Open
Questions & Answers (1)
Open
Reviews (1)
Open
Site Scripts (1)
Open
Web Services (1)
Open
Training Videos
Peer Support

SQL Editor

You can find this section under Programming Utilities > SQL Editor in the IRP Admin left navigation menu.

This section shares some functionality with the Reports section. You can use the SQL Editor to:

  • Add a Report
  • Edit a Report
  • Run a Report
  • Download Report Data
  • Run SQL

Reports allow you to pull information from your IRP database on any aspect of your IRP instance with a few exceptions for sensitive information such as passwords, card details, and so forth. You can create and run Reports within the IRP or export them as a delimited text file, which can then be opened with your spreadsheet software for formatting and further analysis. To create reports, you will require knowledge of the SQL programming language and an understanding of the structure of your IRP’s database.

If your Admin User account has DBA access, you will be able to create and run SQL scripts to pull data from the database quickly.

We strongly advise you speak to your Support Team with regards to setting up and editing Reports or running SQL scripts.

How To Guides (6)

Close
Open
How To Add a Report
Open
How To Edit a Report
Open
How To Download Report Data
Open
How To Run a Report
Open
How To Run a SQL Script
Close
How To Add an Email Report

You use Email Reports to send emails to a specific set of customers.

To create an Email Report, follow these steps:

  1. Go to Programming Utilities > SQL Editor in the IRP left navigation menu.
  2. Scroll to the SQL Editor section and enter the following details:

    Setting Description
    SQL

    The report will consist of multiple lines such as those shown below:

    SELECT -1 AS MailingListID,'emailaddress2@domain2.com' AS EmailAddress UNION
    SELECT -1 AS MailingListID,'emailaddress3@domain3.ie' AS EmailAddress UNION
    SELECT -1 AS MailingListID,'emailaddress5@domain5.com' AS EmailAddress

    Each line will contain an email address for a specific customer. The last line should not have a UNION command as there are no further statements to combine.

    Depending on user preference, you may find it easier to create the script in an external editor and paste the finished script into the SQL text box once finished.

    Report Type This should be set to Email.
    Report Title

    The title/name used to identify this report within your IRP. We advise that titles include the area and the operation. For example, a report which will be used to send emails to all Australian Customers could be called:

    Emails - All Australian Customers

    Save As Report This must be checked to save the SQL query entered in the SQL section as an Email Report. If you do not save the report, you will not be able to use it to send emails.
  3. Click the button to run and save the SQL query.

    Any errors with the query will be highlighted at the top of the page:

    If the query is valid, it will run and the results will be displayed in the Report Results section once finished.

    If you have checked the Save As Report checkbox, this will also save the report.

  4. You must now set up an email to send to this list of customers. This is described in further detail in the How To Send an Email article in the Emails help topic.

Copyright © 2020 IRP Commerce. Use of this website constitutes acceptance of the IRP World Terms of Use, IRP Privacy Policy and IRP Cookie Policy

IRP Commerce Limited, Concourse 3, Catalyst, BT3 9DT, UK. Company Number: NI 041856. VAT Number: GB 888249658
A Deloitte Fast 50 Company seven times: 2010, 2011, 2012, 2013, 2014, 2018 & 2019