PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

How do I get around using a subquery in a field in PSQuery?

edited Feb 1, 2023 12:03AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 2 commentsAnswered

I had someone come to me with a request for a change to a query, to add a column with a simple 'Y' or 'N' to determine if any given student has enrolled in the term prompted. I wrote a simple CASE expression with a subquery in our SQL database, I saw it worked, so I tried to put it on PSQuery so others could access it, but I saw I cannot use subqueries in field expressions on PSQuery. I can't think around how to achieve this. I thought about writing and referencing a view, but the view would need

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center