SugarCRM Build Filter 'contrains' keyword related search functionality is not working for few modules

Resently we upgraded the SugarCRM application 13.0.2 to version 14.0.1.
After upgraded few modules build filter, 'contains' keyword based search functionally is not working.

When I try to filter the 'contrains' keyword empty values is returning.

When I create the new 'state' record i then in the dropdown 'country' values is also selected. after create the new 'state' record. when I try to filter based on the 'country' values using 'contains' keyword , then empty value is displaying.

Note: Country is a relationship module for the state module.

0 Andre Serrazina 4 months ago

Hello Saravanan Madhachetty ,

I’m working on reproducing your scenario locally to gain a better understanding of the issue you’re encountering.

As you described, I created a new module called Countries and added a relationship to one of the stock modules—Accounts in my case.

I also added the Countries module to the list view and search view.

After doing so, I was able to successfully search for countries, as shown in the video below. The “contains” filter allows me to select a country from the list, and in my tests, it correctly returned the Accounts associated with the selected country.

Could you confirm if your scenario is similar? If not, could you provide more details on how Countries is related to States and share a couple of screenshots showing your relationship setup and the behavior you’re observing on your end?

Thank you in advance!

Best regards,

André