Is is possible to apply filter with m2m table?

[valter479]

Is is possible to apply filter to a reference field that has a m2m table?

For example:

Locations (cmn_location) has m2m relationship with groups. When adding location to incident form, is possible to filter out only locations that have a specific group?

Thanks,

Valter

[valter479]

Hi Drew,

I thought it was working but anytime I put the condition (^name=Test Group) it doesn't filter out. It show all location that have at least one group.

Any ideas why?

Also according to this Including a related list query, at the note section, it says System PropertiesList V3 must be enabled. Paris or Quebec doesn't have that system properties and I believe List V3 has been deprecated/not allow in new deployments according to this article. 

[DrewW · Accepted solution]

This is what the docs say

*****

Note: Related list queries must be enabled in System PropertiesList v3. Select the Allow related list query conditions to be added through the filter check box to enable it.

You can build a related list query for a list that uses List v2, however, the filter conditions cannot be modified until you removed the related list condition in the breadcrumb.

*****

So it can be used there is just no way to edit the query using the list until that part is removed.

Make sure you have the SNUtils installed in Chrome or Firefox.  Then go to Reporting and build the query you need using what ever filter.  Once done you can then just double click on some white space at the end of the filter breadcrumb and it will give you a popup that has the query you need to use.