前言

记录常用的SQL，大部分以为查询为主。

查询

查询视图 Id

  • 根据视图名称查询
SELECT name AS 'View name',
       savedqueryid AS 'View Id',
       returnedtypecode AS 'Owning entity',
       description as 'Description'
FROM   savedquery
WHERE  name = '填写视图名称';
  • 查询某个视图下所有的视图
SELECT 
    v.SavedQueryId AS 'View Id', 
    v.Name AS 'View name',
    v.returnedtypecode AS 'Owning entity'
FROM 
    SavedQuery v
WHERE 
    returnedtypecode = 'account'

查询报表/报表 Id

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

查询附件容量

随手记，不好用。

-- 1 MB = 1024 * 1024 Bytes = 1,048,576 Bytes
SELECT SUM(filesize) / 1048576 AS TotalFileSizeMB
FROM   annotation;