The following SQL identifies custom queries created in your system from the PSQRYDEFN PeopleTools table. It includes the query type (and the operator ID who owns the query if it is private). select QRYNAME as "Query Name", DESCR as "Query Description", CREATEOPRID as "Created By", CREATEDTTM as"Created On", LASTUPDDTTM as "Last Updated By", LASTUPDOPRID as "Last Updated On", case when OPRID != ' 'then 'Private - ' || OPRID else 'Public' end as "Query Type", VERSION as "Revisions", QRYAPPROVED as"Query Approved?", APPROVEOPRID as "Approved By", APPROVEDTTM as "Approved On"from PSQRYDEFNwhereLASTUPDOPRID != 'PPLSOFT'
Note to run in SQL server, change the || concatenation operator to a plus sign (+). |
相关文章
- 03-06Vue3 自定义指令Custom Directives
- 03-06[React] Write a Custom State Hook in React
- 03-06【CF 710F】String Set Queries
- 03-06PI-Custom adapter module
- 03-06[题解] SPOJ GSS1 - Can you answer these queries I
- 03-06Content-based table retrieval for web queries
- 03-062020-web前端-vue项目出错-[Vue warn]: Invalid prop: custom validator check failed for prop "index"
- 03-06Codechef March Challenge 2021 Random Walk Queries(RWALKS) (动态点分治)
- 03-06SPOJ 2916 Can you answer these queries V(线段树-分类讨论)
- 03-06SPOJ 1557. Can you answer these queries II 线段树