https://www.servicenow.com/community/itsm-forum/database-view-where-clause-for-platform-analytics/m-p/3308127#M542970 <P>Hey all,</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="RyanPSchneider_0-1751474083009.png"><img src="https://www.servicenow.com/community/image/serverpage/image-id/452811i045445FC2639D840/image-size/medium?v=v2&amp;px=400" alt="RyanPSchneider_0-1751474083009.png" title="RyanPSchneider_0-1751474083009.png" /></span></P><P>&nbsp;</P> Wed, 02 Jul 2025 16:35:08 GMT RyanPSchneider 2025-07-02T16:35:08Z https://www.servicenow.com/community/itsm-forum/database-view-where-clause-for-platform-analytics/m-p/3308127#M542970 <P>Hey all,</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="RyanPSchneider_0-1751474083009.png"><img src="https://www.servicenow.com/community/image/serverpage/image-id/452811i045445FC2639D840/image-size/medium?v=v2&amp;px=400" alt="RyanPSchneider_0-1751474083009.png" title="RyanPSchneider_0-1751474083009.png" /></span></P><P>&nbsp;</P> Wed, 02 Jul 2025 16:35:08 GMT https://www.servicenow.com/community/itsm-forum/database-view-where-clause-for-platform-analytics/m-p/3308127#M542970 RyanPSchneider 2025-07-02T16:35:08Z https://www.servicenow.com/community/itsm-forum/database-view-where-clause-for-platform-analytics/m-p/3308142#M542971 <P><a href="https://www.servicenow.com/community/user/viewprofilepage/user-id/230909">@RyanPSchneider</a>&nbsp;I found out something related to this, please find the links below:</P><P><A href="https://www.servicenow.com/community/servicenow-ai-platform-forum/database-view-where-clause-behavior/m-p/2343641" target="_blank">Solved: Database view where clause behavior - ServiceNow Community</A></P><P><A href="https://www.servicenow.com/community/itsm-forum/database-view-where-clause/m-p/2474805" target="_blank">Solved: database view where clause - ServiceNow Community</A></P><P>&nbsp;</P><P>Mark my answer helpful if it helped you <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Wed, 02 Jul 2025 16:50:07 GMT https://www.servicenow.com/community/itsm-forum/database-view-where-clause-for-platform-analytics/m-p/3308142#M542971 PratikshaKate 2025-07-02T16:50:07Z