How to filter List View by a related module’s field in SuiteCRM 8.6?

👨‍💻 Development Help
1

I’m trying to filter records in a module’s List View, but based on a field from a related custom module.

For example, in the Books module, I want to show only records where the related Author’s last name is “Smith”.

Is this kind of filtering supported in SuiteCRM 8.6?

Is it possible through the GraphQL filters or by extending the Angular List View component?

Any guidance or examples would be appreciated!

2

Yes it is possible to filter records based on a relate field. For example, we can filter contacts based on a selected account.
image

This can be achieved from studio → module → layouts → filter → advanced filter

image
image778×426 21.9 KB

3

Hi Harshad,

Thanks for your reply! I think there may have been a misunderstanding about my original question, so let me clarify it:

I’m not looking to just display related fields in the List View filter — rather, I want to filter the parent records in the List View based on a condition in the related module’s records .

For example:

In the Quotes module, each Quote is related to multiple Line_Items . I want to show only those Quotes in the List View where at least one related Line_Item has a name field that matches a certain value (e.g. contains ‘abc’) .

So the filtering condition is:

“Show Quotes where any related Line_Item’s name LIKE ‘%abc%’”

This type of cross-module filtering (based on child record fields) doesn’t seem to be supported by Studio or standard filters.

Do you know if this can be achieved via GraphQL or by customizing the Angular List View logic?

Any tips or examples would be much appreciated!

Thanks again :pray:

4