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

Positions with no assigned person

edited Jan 25, 2018 1:32PM in Reporting and Analytics for HCM 1 comment

Summary

Trying to get an "outer join" type result set with Position and Assignment

Content

We have an analysis that starts from the Position and brings Assignment Details for that position.  We want to filter on attributes of the Assignment (Assignment Status Type) but also include those with no assigned person so we added Assignment Status Type is Null

The "is Null" does not work and these rows are not returned.

Can someone tell me how the "is null" works and/or provide another way to bring these Positions?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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