How do you create a UNION when creating a report?

[Robert Campbell]

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.

[Maik Skoddow]

Hi
did you set the system property glide.ui.list.allow_extended_fields to "true"?

Maik

[Robert Campbell]

Is that what that first checkbox does?

[Robert Campbell · Accepted solution]

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.