Question

Autosearch for filters in datagrid - instead of clicking on search

0

Hello everyone, I have filters in the top row of a datagrid. However I want the search input fields to automatically search when the user inputs a value instead of having to first click on “Search”. Is that even possible or do I need an external datagrid widget for this functionality? See the image below – e.g. the user types in a name and then has to click on the search button for the results to appear.

asked 2022-02-02

Markus Czegedi

2 answers

0

It is not possible with the out of the box data grid. You will have to create custom or use an external widget to achieve this.

answered 2022-02-02

Shreyash Mehta

Matteo Timmermans · Accepted Answer · 2022-02-02

Hi Markus,

This in not included in the default functionality of the data grid. What you could do however.

- Set the datagrid in a dataview with Search Helper as entity.

- On the search helper entity create te attributes you want to search for (First name/ Last name) etc.

- When opening the page create an object of this helper entity, with all values empty

- Remove the current search fields in the datagrid

- Set text boxes for the attributes where you want to look for.

- Set an on change microflow for when a value is entered where you set a commit activity for the helper entity. You don't commit the entity but only refresh in the client.

- Set the datagrid source to Microflow and in the DS microflow, create a retrieve where you used the values of the helper to search objects in the database.

Hope this helps!