Apex 20.1-20.2 - Autocomplete issue - need solution

Leon_M

Text with Autocomplete in Interactive grid does not work as expected.

When changing value line by line, at some point, the mouse (or Enter key) would not select the value from dropdown.

To reproduce: Enter some value on one row, then same value on next row of the same column. On second or third occasion, autocomplete will "stuck" and you won't be able to select same value neither by mouse nor by "Enter" key.

Test:

https://apex.oracle.com/pls/apex/f?p=108817:2

user: guest

pass: password

P2 - Customers - State Autocompl column

Video recording of the issue (Passcode: 9!=8ciE4) :

https://arhomes.zoom.us/rec/share/WFqmdkTqM6G0RElhu74ROGjK9eZ2ztokGNgQIWmEA7oufSwkWEuINW1q_H2M7npI.Adeg3B3zuJc9CE7g

Our users have to change dozens of rows with the same value when working on a project.

We need solution for this bug please?

Anthony Rayner-Oracle

Hi,

Thanks for reporting this. I was able to reproduce it and have filed bug #32808045.

I'm afraid the only workaround I can offer (and something that it looks like you've tried already yourself on the test page), is to switch to using the 'Popup LOV', and set 'Search as you type' for a somewhat similar user experience.

Hope that helps,

Anthony

Leon_M

@Anthony Rayner-Oracle

Thank you for your suggestion. Unfortunately we can't use Popup LOV either as it has another issue in Interactive grid.

The issue was reported here:

https://community.oracle.com/tech/developers/discussion/4340268/apex-20-1-popup-lov-in-interactive-grid-causing-issue/p1?new=1

The bug #31689248 was opened for this issue. Unfortunately the bug was not resolved in Apex 21.1 release.

Hopefully the bug #32808045 that you filed will be resolved soon.

We prefer to use Autocomplete as it is already implemented in our Apps.

Thanks again,

Leon

Anthony Rayner-Oracle

Hi Leon,

I'm sorry about this, and also the blocking bug with regards using Popup LOV, I was not aware of that.

I have raised the severity of the autocomplete bug, so it will be prioritised for the next release. I'm sorry I can't give you a better answer than this today. I've also made a note of this thread in the bug, so we can provide any updates here.

Regards,

Anthony

Farhan2

I am using text field with auto complete on oracle cloud service.

my list is from a table containing 90k rows. Chrome seems to hang when trying to autocomplete.

is there anything I can do to prevent the page busy error in chrome?

RobDavis

Is there any progress on solving bug #31689248 or bug #32808045? Is either still open? This is still an issue in 21.2