Home > Forum > Forms > Autocomplete field showing all results

Autocomplete field showing all results

0

23.05.2023

11:05

Hi community!

We have 2 choice fields, first one is a dropdown (field1), second one has behaviour autocomplete (field2).

Dependent on selection in field1, datasource of field2 (which is an SQL query containing value of field1) changes. This is working as expected.

Picker search mode of field2 is set to 'Contains', minimum characters = 3.

Regardless of what is entered in field2, all available entries are shown and are not filtered.

Any ideas why this does not work as expected?

We are using Webcon version 2022.1.4.204 by the way.

Thanks a lot in advance & best regards, Nik

23.05.2023

15:26

Hi Nik,

Have you enabled the diagnostic mode to check which sql statement is executed?

I don’t have the version but I didn’t have any issues with cascading drop down in a while.

Best regards,
Daniel

Solution (0)

Helpful (0)

Wrong answer (0)

24.05.2023

19:09

In reply to: Daniel Krüger (Cosmo Consult)

Hi Daniel!

Thanks a lot. Yes, SQL queries are fine, also data is correct.

I found out that Autocomplete does not work at all, when datasource is an SQL query on current BPS database connection.

I added a new datasource on system level and also added a technical filter field, which is set on change of field1 and now everything works like a charm.

Best regards, Nik

Solution (0)

Helpful (0)

Wrong answer (0)