Malformed query in popups when MultiEnum fields are present #10464
Labels
Status:Requires Updates
Issues & PRs which requires input or update from the author
Type: Bug
Bugs within the core SuiteCRM codebase
Issue
When you have one or more MultEnum field in a Popup, you select more values in one MultiEnum filter field and you have some other filter value within other fields, the where clause is built without brackets and you get OR and AND clauses mixed with unwanted results.
This problem is not present in ListViews where brackets are put (look at method processSearchForm in include/MVC/View/views/view.list.php)
Possible Fix
Easy fix is in include/Popups/PopupSmarty.php in method _get_where_clause().
Change:
to
Steps to Reproduce the Issue
Context
No response
Version
Bug still present in actual GitHub code (7.14.4)
What browser are you currently using?
Chrome
Browser Version
not significant
Environment Information
not significant
Operating System and Version
not significant
The text was updated successfully, but these errors were encountered: