Add other fields to filters

[DiogoTeixeira]

Hi,

I’m using the SuiteCRM-7.11.17 on CentOS 7.8 with Apache v2.4.6, php v7.2.34 and Mysql v5.6.49.

How can I add other fields to a filter?
In “Studio” I can edit the filters.
I can use the fields that are “Hidden”. But I can’t add fields from other tables to it, which are related. For example, to filter by team.
I also found that if I add a new field to a module, I can then use that field in the filter, but only in this module.
How should I do?

Thanks,
Best regards.

[BrozTechnologies]

Check this post to see if it helps:

Problem when trying to Filter by Related Module's Field

We are very keen to be able to filter by a related module’s field so were pleased to come across: My colleague tried to add exactly this code to our our SuiteCRM installation and it didn’t work. I wonder if anybody could assist as to why. We had tried searching for contacts whose account type was ‘Press’. When we looked in the error log, it included the following: …LEFT JOIN accounts accounts ON accounts.id=jtl0.account_id AND accounts.deleted=0 AND accounts.deleted=0 where ((contacts.i…

Thanks,

BrozTechnologies