Hi,
I need to filter the HR Case (sn_hr_core_case) table where a Task from Task (task) table is Assigned To = Me.
I have tried adding a filter "Parent => Task Fields" then "Parent > Assigned To" but nothing shows up on the table list view.
I validate the list through My Requests page in ESC Portal (/esc?id=my_requests) and the objective is to display the same HR requests from portal to the HR Case table list view.
Screenshot below are the records that I need to display on the HR Case table.
Any help with the filter query for the list view is greatly appreciated.
Thanks!
@amielalcala :
The challenge is what @Ankur Bawiskar said, that these are different tables and you do have one of the following options:
1. You create a list of the HR Cases with the following filter and add the "parent" field:
The downside here is, that you won't see all of the "HR Cases fields", but only the Number. You can do the same within the HR Agent Workspace, but there you would only be able to add the "default parent" (task table) fields, and not the HR Case fields
2. You could also create a report, with a "related list condition" - that would satisfy your requirement. However, you would then need to add this report either to a dashboard or run it always:
Unfortunately, there is no "easy" way for your ask. You could also go down the route of create a "database view" - but that might be an overkill here.
Cheers,
Julian
