How to filter a field of module B in the list view of module A

Question

Hi, 
 
 I have two modules "A" and "B". There exists a relation (one-to-many) between theses two modules. One module A may have many module B's. I have a field "status" in Module B. It is an enum field with following options ('Open', 'Lost', 'Won'). 
 I tried following HOW-TOs to filter the field in the list view of module A: HOWTO: Add a search field that searches another module &laquo; Sugar Developer Blog &ndash; SugarCRM (wordpress.com) Cross module searches in SugarCRM - Stack Overflow Filter by related module's field (urdhva-tech.com) None of them worked. The field "status" shows up in the Filter-Options and I'm able to select the desired value ('Open', 'Lost', 'Won'), but the resultset does not change. How can I debug this? Especially the query, which is fired when I'm trying to filter for "status". Any help appreciated. 
 
 Kind regards

Volkan Erdogan · Answer

Unfortunately you can not search for related data in a list view of a given module. It is possible but with some coding. 
 Instead you can create the dropdown field 'stautus' in the module B as well and configure a sugarLogic formula which copy value from that field in module A into module B. 
 This way you will search for a field in module B, which is a copy of such a field in module A.