In this video, we'll show you how to add PSQuery links to your Insights Data Tables. These data grids display detailed data behind visualizations in a spreadsheet-like format and respond to selections and filters just like other visualizations, such as bar or pie charts. However, they are not actual spreadsheets and have specific limits on real estate and memory, so we can't expect unlimited rows and columns. When users need more columns, you can provide them with a keyed link to a PSQuery report.
Jump to specific sections:
00:00 Intro
00:15 Review the solution
02:19 First - See it working
02:56 Before Dashboard
03:14 Data Source Query
03:52 Build Display Query
04:48 Build PSQuery Drilling URL
06:14 Update Search Objects
07:23 Update Insights Seearch Index
08:03 Update Data Table with Query Link
08:30 Test the Solution
08:54 Wrap up
Youtube link: https://youtu.be/8wtvfbHliBo
PeopleTools Tech Tips: https://peopletoolstechtips.com/add-a-psquery-to-insights-data-tables/
Github: https://github.com/PeopleToolsTechTips/PT3-E055-Embed_PSQuery_into_Insights_Data_Tables
Production Notes:
A PT3 Production
Presenter: Randall Groncki
Music: Vlad Gluschenko — Overseas
License: CC BY 3.0: https://creativecommons.org/licenses/by/3.0/deed.en
https://www.youtube.com/channel/UCbDI_amaP4s_AdBskpskAtw