SQL Designer

This procedure provides an overview of common SQL syntax, including the SELECT, FROM, WHERE and ORDERBY statements.  SELECT Section The SELECT section specifies the data table and columns you want to retrieve. Use commas to separate mul...

This article demonstrates how to retrieve SQL code from Logic Blocks to generate reports in SQL Designer. Retrieving the SQL Code Go to Workflow → Logic Blocks Click on a Logic Block Click on the Custom Heading Section Click on the Cl...

This guide will demonstrate how to create a sample SQL Report to retrieve demographic details for consumers whose debt records have been archived. Note This sample report does not include all the data available in the debt.archive table. Cr...

SQL Designer Compliance Fields Available   debt.last_in_window_update debt.in_window_letters_sent debt.in_window_connected_calls debt.in_window_emails_sent debt.in_window_texts_sent debt.in_window_all_contact_attempts debt.in_window_...

SQL Designer Itemization Fields Available account.consent_to_contact_date_age, account.consent_to_contact_date_expires, account.consent_to_contact_date, account.in_window_all_contact_attempts, account.in_window_all_contacts, account.in_window_...

SQL views allow users to retrieve data directly from the relation database system that powers ACE. Views combine one or more underlying database tables to provide a stable and unified interface from which SQL Reports can be created. Locating SQL Vi...