Hi experts,
My requirement is to create a dashboard to showcase the playbook activities. We have a sourcing request table (sn_shop_sourcing_activity) which is linked to the playbook execution table (sys_pd_activity). The sourcing request table has got fields such as service tier, sourcing type, request type etc. The requirement is to create an interactive filter for these fields and the graph/data of the playbook dashboard should change based on the interactive filters. The issue is there is no primary key between these tables i.e. there is no common field between the sourcing and playbook table. But if I dot walk the field "lane.process definition" in the sys_pd_activity, I am able to see a field named "input record" which is the request number of the sourcing record from the sourcing table. Can anyone tell me if it is possible to do this or not? For eg, I want to see all the playbook activities with Service Tier 1 and Service Tier 2. How do I achieve it?
Thanks in advance,
Ash
