Agenda

PS Query for Functional Users – Intermediate to Advanced (Part 2)

Track: Student Information System (SIS)

Session Number: 10943
Date: Wed, Mar 6th, 2024
Time: 2:00 PM - 3:00 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:
-- Miscellaneous intermediate to advanced 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 is Part 2 of a two-part series. Part 1 is session #10501.
Sub-Categorization: Campus Community
Session Type: 2-Part Series

Focus Area: Data to Decisions
Session Length: Two-Part Series (2-60 min)
Cross Listed Areas: trk-1741, trk-1796, trk-1736
ERP Systems: Oracle
Knowledge Level: Intermediate
Field of Study: Select a Value
CPE: No
Sub-Categorization: Campus Community
Session Type: 2-Part Series

Focus Area: Data to Decisions
Session Length: Two-Part Series (2-60 min)
Cross Listed Areas: trk-1741, trk-1796, trk-1736
ERP Systems: Oracle
Knowledge Level: Intermediate
Field of Study: Select a Value
CPE: No