You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Logical SQL not returning data

in Reporting and Analytics for HCM 1 comment

Summary:

I have built a report using logical SQL is not returning expected data - possible subquery issue


Content (please ensure you mask any confidential information):

Hello

I have built a report using logical SQL to show the latest date someone completed a version of a training course, but also to highlight when their record shows they have not completed either version ( 2024 or 2025).

I have used a union for this, with the top part returning the people who have completed one of the courses, and the bottom showing anyone who has completed neither.

This did appear to be working, but it now appears that the bottom half is not returning data. I think this is linked to the subquery in the SQL as if I look at using one learning item name it works, but I don't understand why the IN statement and having 2 listed does not produce any results.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!