Hey all,
I am building a database view for a customer that gets all Dashboards (par_dashboards) from the new Platform Analytics and displays all data visualizations so that we can get a sense of when DV's were either last updated or run. From there, these can be cleaned up manually by this team.
I am having trouble connecting the PAR Dashboard Widget to the PAR Component/Visualization. I can't seem to find a way in the PAR Component table to link back up to the Dashboard Widget table.
Is there any other way I can link like the display names together or reveal something that can JOIN these tables together? See the highlighted cell below on the problematic Where clause.
