How do I change the order in the dynamic dropdown (auto-suggest) database

[D X]

Hello all,

In a confluence page, I have a dropdown (auto-suggest) database object.
The query associated just call a field on a view.

Field values are like this :

aaa.toto.aim
aaa.toto.becare
toto
toto.aim
toto.aim.thisis
toto.becare
toto.becare.xxx

When I start fill value like 'toto', results are display in above order.

I suppose the component make a like '%dropdownvalue%' on database.

How it's possible to have the suggest results in this order (starting with entered value) :

toto
toto.aim
toto.aim.thisis
toto.becare
toto.becare.xxx
aaa.toto.aim
aaa.toto.becare

Thanks in advance.
Regards,

Xavier

[D X]

Hi Minh Tran,

sorry for the late answer. I finally solved my issue in adding a where clause on the query associated to the component.

regards

[Minh Tran]

@D X What dropdown (auto-suggest) are you using? Can you clarify more?