#happy2022workday day-046

Happy 2022 day-046! Today’s update…

Here is a fantastic #Workday Subfiltering challenge to prepare you for tomorrow’s Sharing Café (Wednesday, 2022-02-16). Hang out with us in the café as Gina Espinosa – MISM and I will be adding onto yesterday’s #workdayreporting challenge (listing only the beneficiaries who are 18 or younger for each worker) with the answer to today’s additional challenge.

Was yesterday’s Subfilter challenge easy (particularly if you viewed answers in the comments?)

Well, today’s challenge isn’t so easy (unless you saw Gina’s Subfilter sharing last year in #thesharingshow.) Here goes…

Review the picture and notice that the Worker BO has these two 1:M RBOs:

“Beneficiaries – People” : used in yesterday’s challenge, and again today

“Dependents” : similar perhaps to the list of beneficiaries, but this is a different RBO list with different Business Objects in it.

CHALLENGE: Use Subfilter (not calculated fields) to list all the beneficiaries and dependents who are 18 or younger for each worker.

Simple, right? Guess. Test. Maybe realize that this one is not so easy.

To be clear, this is the same report as yesterday, but today add also the Dependents who are 18 or under.

CLARIFICATION: Any beneficiary or dependent who is 19 or older should not appear. The Subfilter needs to handle both of the RBO lists.

Unlike yesterday’s #happy2022workday post, this time I am requesting that you please do not comment with the answer of how you did it. Instead, feel free to join us in the Sharing Café tomorrow (Wed) morning, 8-9am PST, and you can have the microphone and the screenshare to share with us your (possibly short) journey during these next 21 hours!

OTHER SUBFILTERING EXAMPLES: In the café we are open for all Subfiltering challenges, not just this one example