PS Query for Functional Users – Intermediate to Advanced Expressions
Track: Student Information Systems
Session Number: 4016
Date: Tue, Oct 25th, 2022
Time: 1:45 PM - 2:45 PM
Description:
Learn how to get more out of your queries as we take a look at some of the query functionality that UT Dallas has found to be the most helpful. We use PS Query for population selections, reports, pagelets, and more, and would love to share the expressions we have found the most helpful over the years!
This session is aimed at functional users with an intermediate level of knowledge with PS Query. Expressions:
-- Basics on Drilling URLs
-- Miscellaneous expressions
-- ListAgg, removing duplicate values, and getting around the 4,000 character constraint
-- Regular Expressions
-- Meta-SQL
• What else can we do with queries? Creating Queries as content references, related content, and in advanced BI reports
• Auditing queries we have created -- how to query on your queries
This session is aimed at functional users with an intermediate level of knowledge with PS Query. Expressions:
-- Basics on Drilling URLs
-- Miscellaneous expressions
-- ListAgg, removing duplicate values, and getting around the 4,000 character constraint
-- Regular Expressions
-- Meta-SQL
• What else can we do with queries? Creating Queries as content references, related content, and in advanced BI reports
• Auditing queries we have created -- how to query on your queries
Session Type: Presentation
Session Type: Presentation
Speakers
Primary Presenter
Jamie Frances Rose Polizzi
Information Systems Analyst
University of Texas at Dallas