HR cases related to which on taxonomy

[Prateek07]

Hi All,

I want to create a report for HR cases, based in HR taxonomy, and sub topics and sub sub topics. I have checked in m2m_connected_content_list table. We do have mapping as developed/mentioned on the portal. I want to understand which catalog doesn't have any taxonomy attached and report them too.

I have tried dot walking the 'hr_service.producer.taxonomy_topic=Paycase' on hr case table. But the problem in when i show this in report we are not able to define how many cases are related to particular taxonomy or taxonomy sub topics and so on.

Thanks in advance.

[Susan Britt]

To determine which record producers for HR services are not tied to a taxonomy topic, you can quickly add that field (record producer.taxonomy topic) to your list view and see which are empty.  Since it's a dot-walked field, you'd need to update the global list layout for HR services.

HR cases are not directly tied to the topic, so you'd need to do some dot-walking there too - from the case's HR service > record producer > taxonomy topic.  You can dot-walk from the report.