I have a requirement to create a dashboard that shows the full lifecycle of an interaction from it's creation to subsequent requests, incidents, or cases created from it through their lifecycles (i.e. incident is created from an interaction => the incident has a problem created from it => the problem record has a corresponding change request created).
I have created a database view to merge the interaction_related_record table with the task table but am unable to get the data I need from the database view.
My where clause does not seem to produce any records where there should be.
Where Clause:
task_sys_id = interactionRelRecord_document_id
What am I missing? Any assistance is greatly appreciated!!
