How to apply unions and left joins in value set of table type? — 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

How to apply unions and left joins in value set of table type?

in Workforce Management 2 comments

Summary:
I want to show time shift on time card. For this purpose, I am creating a value set of Table type to get time shift based on the "RESOURCE_TYPE" column in PER_SCHEDULE_ASSIGNMENTS table. I want to apply a left join to get my desired results however I cannot type it in "where" field for value set. Looking forward to your response on how to write a left join in value set.

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):



Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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