search FNC Grid within web core application

[Fabian_Wildsch (Fabi)]

Good morning everyone,

im using the FNC Grid within my Web Core Application. Im having issues finding a property to have searchbox within the grid or make the grid columns searchable. Or is there no such option? If so, how else would i sort the grid? do i need to manually change the query string?

thanks in advance
best regards
fabian

[Pieter_Scheldeman (Pieter)]

Hi,

There is currently no search option available in the grid. To sort, it is indeed required to sort the dataset via a query.

[Fabian_Wildsch (Fabi)]

Thank you Pieter. Would be very helpful if this was considered in a possible future version.

can you help me how i would rewrite this query to also find non exact matches (as with SQL like%).

For example, if i search for an Adress "Car Dealer" and only type "Car Dea" that it would pop up?

This my query right now:
XDataWebDataSet1.QueryString := XDataWebDataSet1.QueryString +
'&$filter=adressname eq ''' + WebEdit1.Text + '''';

works if exact equal, but not if its only parts of it.

thank you in advance

best regards
fabian

[wlandgraf (Wagner Landgraf)]

@Fabi, you can use the contains function for that:

XDataWebDataSet1.QueryString := XDataWebDataSet1.QueryString +
'&$filter=contains(adressname, ''' + WebEdit1.Text + ''')';

More info: TMS Aurelius CRUD Endpoints | TMS XData documentation

[Fabian_Wildsch (Fabi)]

thank you very much!