The requirement is to filter a custom report to show only workers terminated after a user-prompted date. In Workday, filters are defined in the Filter tab of the custom report definition, and conditions can be combined using AND/OR logic to refine the dataset. Let’s analyze the requirement and options:
Key Conditions:
Workers must beterminated, so the "Worker Status" field must equal "Terminated."
The termination must occuraftera user-specified date, so the "Termination Date" must be greater than the prompted value.
Both conditions must be true for a worker to appear in the report, requiring anANDcombination.
Option Analysis:
A. Worker Status is equal to the value "Terminated" OR Termination Date is greater than a value retrieved from a prompt: Incorrect. Using OR means the report would include workers who are terminated (regardless of date) OR workers with a termination date after the prompt (even if not terminated), which doesn’t meet the strict requirement of terminated workers after a specific date.
B. Worker Status is equal to the value retrieved from a prompt AND Termination Date is less than a value retrieved from a prompt: Incorrect. Worker Status shouldn’t be a prompted value (it’s fixed as "Terminated"), and "less than" would show terminations before the date, not after.
C. Worker Status is equal to the value retrieved from a prompt OR Termination Date is equal to a value retrieved from a prompt: Incorrect. Worker Status shouldn’t be prompted, and "equal to" limits the filter to exact matches, not "after" the date. OR logic also broadens the scope incorrectly.
D. Worker Status is equal to the value "Terminated" AND Termination Date is greater than a value retrieved from a prompt: Correct. This ensures workers are terminated (fixed value) AND their termination date is after the user-entered date, precisely meeting the requirement.
Implementation:
In the custom report’s Filter tab, add two conditions:
Field: Termination Date, Operator: greater than, Value: Prompt for Date (configured as a report prompt).
Set the logical operator between conditions toAND.
Test with a sample date to verify only terminated workers after that date appear.
References from Workday Pro Integrations Study Guide:
Workday Report Writer Fundamentals: Section on "Creating and Managing Filters" details combining conditions with AND/OR logic and using prompts.
Integration System Fundamentals: Notes how filtered reports support integration data sources with dynamic user inputs.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit