Preface

This document records commonly used SQL statements, mainly focused on queries.

Queries

Query View ID

  • Query by View Name
SELECT name AS 'View name',
       savedqueryid AS 'View Id', 
       returnedtypecode AS 'Owning entity',
       description as 'Description'
FROM   savedquery
WHERE  name = 'Enter view name';
  • Query All Views under a Specific View
SELECT 
    v.SavedQueryId AS 'View Id',
    v.Name AS 'View name',
    v.returnedtypecode AS 'Owning entity'
FROM 
    SavedQuery v
WHERE 
    returnedtypecode = 'account'

Query Report/Report ID

SELECT reportid,
       name,
       filename,
       description,
       owneridname,
       componentstatename,
       createdon,
       createdbyname
FROM   report;