-
Type: Bug Report
-
Status: Closed
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: 4.3.9
-
Fix Version/s: 5.0.0
-
Component/s: Data Management
-
Labels:None
-
External issue URL:
-
External issue ID:109
-
Copy Issue Key:
-
Patch Instructions:
In some case we need to use JOIN in database queries, that are used in "options_sql" option for field. In many cases there is a possibility, that fields, selected in "option_key_field"/"option_title_field" options will be present in more, then one table, used in JOIN. This will result in database query error.
I propose to strip table alias (if any) when building field options list.