Text field with autocomplete - shared components

Scott Wesley

Text fields with autocomplete only expects one column to be returned from the query, making the following an impossible selection.

because APEX does not allow definition of single column queries in Shared Components -> LOVs (as of 18.2)

This means we must use 'SQL Query' for the SQL definition.

Is there something in the pipeline to address this?

Scott Wesley

I found the following feature request (ABG7), almost 7 years old - but I don't think they've reviewed it after the "next" release.

https://apex.oracle.com/pls/apex/f?p=55447:19:103150602387281:::19:P19_ID:260356465368296977972392987893419249550