Child Tables Not Visible in Platform Analytics Reports

[AnupriyaC]

Hi Everyone,

I would really appreciate your help with this. In my PDI instance, Platform Analytics allows me to see all child tables under the Task table and dot-walk to them while adding columns in a report. However, in my dev instance, none of the child tables under Task are visible when trying to add columns in a Platform Analytics report. What could be causing this issue, and how can I make the child tables visible in my dev instance?

In My PDI: 

In MY Dev Instance:

Thanks in Advance!!!

[SebastianBarnes]

@AnupriyaC, were you ever able to find a solution to this? I am experiencing something similar.

[AnupriyaC · Accepted solution]

Hi @SebastianBarnes ,

There isn’t a direct solution for this, but I did find a workaround to bring those fields into view. 

1. When editing the report (task_sla in my case), click on the three-dot menu.
2. In the dropdown, you’ll see an “Open Record” option. (This will only appear after you save the report).
3. Selecting this will open the par_dashboard_widget record, which contains the metadata related to the table.
4. Within the JSON there, you can reference additional fields using the syntax:
   <reference_field>.ref_<reference_table2>.<field_on_referenced_table2> 
   (For example: task.ref_incident.number)
5. You’ll need to place it in the exact position in the JSON where you want the field to appear.

Essentially, modifying the JSON allows you to surface the field you need. You can follow the steps in the below attachment as well to understand better. I hope this helps.