Help with creating searchable grid

Question

Hi,Please see the attached document. Attachment: Syncfusion_Help_Request_382ebde.zip

Renjith Singh Rajendran · Answer

Hi Dylan,Greetings
from Syncfusion support.By default,
the Grid’s inbuilt filtering
feature will be performed only for particular column in Grid. Only the
corresponding column will be affected with filter action. If you want
to search, then we have inbuilt searching
feature. With this searching feature you can search the entire grid columns
based on the search string value. We also have inbuilt Search
method to programmatically perform searching in grid. Please refer the below
references,https://blazor.syncfusion.com/documentation/datagrid/searching#search-by-external-buttonhttps://blazor.syncfusion.com/demos/datagrid/search?theme=fluentPlease get
back to us if you need further assistance.Regards,Renjith R

Dylan Smith · Answer

Thanks for your reply, Renjith.I have checked out your search feature, however by default it searches all column data at once. The dataset I'm using is large and searching that way through millions of records with many fields does not seem like feasible option to get back the data on an initial search. The initial search will hit a database and return the subset of data to populate the grid. I would prefer to have search boxes for each field, so that I can get a more exact query to the database.I like the design of the filter row, which is why a made a quick proof of concept with it.  Would you suggest that I create a custom toolbar with textboxes to perform the initial search? If so, is it possible to mimic the filter row, so that the custom textboxes sit within the proper column?Thank you.

Renjith Singh Rajendran · Answer

Hi Dylan,From your
update, we could see that you would like a behavior similar to our default
Filtering feature behavior(filter one column at a time). If so, then as
informed in our previous update by default Filtering feature will filter only a
particular column only. If you enter filter key in Address column, then
it will filter Address column alone. Then if you want to filter next
column(say Name) then you can type in the filterbar of Name
column and press enter to filter the column and so on.We have
prepared a video demo showing the behavior from our side. Please download the
attached sample and video demo and check this from your side.As from
your update, we infer that you want to filter only one column at a time,
so we have suggested our filtering feature. If we have misunderstood your
requirement or if you are still facing difficulties then kindly share with us a
video demo explaining the requirement/problem along with a simple issue
reproducing sample for us to proceed further.Regards,Renjith RAttachment: ServerApp_c479ba52.zip

Renjith Singh Rajendran · Answer

Please download and refer the video below.Attachment: filteringcolumns_ed65854c.zip