Uploaded image for project: 'In-Portal CMS'
  1. In-Portal CMS
  2. INP-90

Error in database query syntax, when table aliases are used in "option_key_field" or "option_title_field" field options

    XMLWordPrintable

    Details

    • 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

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              alex Alex
              Reporter:
              alex Alex
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: