Run a report on AI Search tables

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-16-2023 05:31 AM - edited 08-17-2023 08:25 AM
I'm looking for some input. Is it possible to create reports for AI Search besides those available on the AI Search Analytics dashboard?
Specifically, I'd like to be able to query AI Search using the sys_user's department and business_unit for portal searches.
Update: we were successful, but only by adding sys_search_event to the system property: glide.ui.permitted_tables. It was then necessary to delete associated drill down entries on sys_report_drill in order to prevent a drill-down error from rendering on the report.
Unless a better path is identified we may look into a database view to allow us to query on various sys_user fields without having to edit system properties. Does your instance have a different experience or solution?
- Labels:
-
AI Search