Value Set Query to Get Unique Assignment Details — Cloud Customer Connect
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

Value Set Query to Get Unique Assignment Details

in HCM Integrations 6 comments

Hi Team,

Need input on Value set Creation to get unique assignment details out of multiple rows. Currently, I am using the below query which gives me 2 rows, due to same date start but different day projected end. As per the requirement, I need to get min of start date and if the start date are same then the max of projected end date. However, I tried the aggregate function use in Value set but it did not work. Hence I thought of going by sorting mechanism and do a rownum = 1 to achieve the required row in a fast

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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