- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-07-2023 05:26 PM
Is there a way to do a UNION in a report? I'm trying to use interactive filters and I need to use a choice filter on two tables cmdb_ci_service and u_cmdb_ci_business_application because these two tables have the "services" we need. When I create an interactive filter on the cmdb_ci_service table and check the two check boxes,
when I use the filter, it doesn't filter anything because the report is based off the cmdb_ci table and I filter by class. If I create the interactive filter on the cmdb_ci table, this field/column doesn't exist.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-09-2023 05:55 AM
Since u_cmdb_ci_business_application is an extension of cmdb_ci_service, I only needed to change my report to use cmdb_ci_service rather than cmdb_ci and left this filter as-is and everything works fine but only because I have that first checkbox checked. If it is not checked, it won't filter properly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-07-2023 07:41 PM
Hi
did you set the system property glide.ui.list.allow_extended_fields to "true"?
Maik
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-09-2023 05:54 AM
Is that what that first checkbox does?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-09-2023 05:55 AM
Since u_cmdb_ci_business_application is an extension of cmdb_ci_service, I only needed to change my report to use cmdb_ci_service rather than cmdb_ci and left this filter as-is and everything works fine but only because I have that first checkbox checked. If it is not checked, it won't filter properly.