2 Replies Latest reply on Aug 11, 2017 7:26 PM by BillC

    APEX 5.1.1: textfield autocomplete and lov does not fit together

    Christian Rackerseder

      Hi all,

       

      when defining a column in an interactive grid as textfield with autocomplete

      (guess it is the same for an item)

      it is possible to select a lov to check the autocompletion against.

       

      However at runtime apex gives an error that the query would deliver the wrong number of columns.

      To fix this the dev env allows one to go directly to the shared components where on can create a new lov.

      But now the lov wizard is going to enforce that the lov has to be made up of two columns.

       

      At the end I use a local SQL-Statement (one column) at the autocomplete textfield.

       

      How should this fit toghether?

       

       

      Best regards,

      Christian