Active Query Builder support area

Auto completion in the query column panel

Avatar
  • updated
  • Completed

Hello,

We are currently evaluating the ASP.NET version of the component and it looks very promising as we were able to build a quick example quite easily and even customize it to our needs (sort of tables, views, fields alphabetically addition of actions like preview results, etc.).

Our tables or views have a lot of columns so it will be very helful to help the user when he starts entering a field name.

Currently the drop down opens and displays the list of available fields but it does not position the scrollbar where the field match.

For instance I have 4 columns called: PlaceOfBirth, PlaceOfJob, PlaceOfLiving, PlaceOfVacation. I expect, when I start typying Place, that the dropdown popup position itself at the first column so I can see which one is correct and select it (either Tab if it's the first one, either clicking with the mouse, either ideally by pressing up and down arrows).


Is this possible and I miss something in the configuration of the component ?


Thanks in advance,


Eric

Avatar
Andrey Zavyalov, PM

Hello, Eric.


Thank you for your feedback.


Currently it is not possible to filter fields by typing. We will think about the possibility to implement this quickly. Please give us a few days to investigate this.

Avatar
Andrey Zavyalov, PM

This feature will be added soon.

Avatar
Andrey Zavyalov, PM

Field lookup list in Expression column of the Query Results Grid is improved.

Search by typing in inline cell edtor is possible now. Jump between search results with the Up and Down arrow keys.

Avatar
EricFra

Hi,


Thanks a lot for the quick update, I just tested it and it works pretty well the only issue I have is that the search is conducted anywhere in the column name so if I type "name" and I have a column called "Dynameters", it will be selected and If I press tab it will be selected by default while before the default selected columns should have been the first one starting with "name".

As I think both search mode are usefull, is there any parameter to specify that the search should be conducted only on start of the column ?


THanks in advance,


Eric

Avatar
Andrey Zavyalov, PM

Currently there's no such option. Possibly we will add it in one of the next minor versions.

Avatar
Andrey Zavyalov, PM
The new Grid.QuickFilterInExpressionMatchFromBeginning property is added.
Avatar
EricFra
Thanks a lot, we will test this.
We change the implementation of the application to use the windows form .NET version (due to issue with latency on the network where we plan to use the component).
As part of the component is shared between ASP.NET and WinForm, I think it will work for both.
Right ?
Eric
Avatar
Andrey Zavyalov, PM
No, this property is for ASP.NET version only.
Avatar
EricFra
Any chance to have this for the Winform version ?
Avatar
Andrey Zavyalov, PM
Yes, it is possible. It will behave in a different way than in ASP.NET version (filtration instead of searching).