We have a grid that uses local array data source that is list of orders:
It also uses one foreign key column (and respective additional array data source that is list of users):
Based upon similar custom search implementations we tried to implement custom search.
Search should look for match (user by name) and get list of filtered users.
Then it should look for match (orders) or where user is one from users' list.
The problem is predicate does not support filtering by presence in list. There is no option for
It could be that we are looking in wrong direction here, but searching by foreign key value seems to be very common use case.
Are there are any valid alternatives to our approach please?
Thank you for reaching out to Syncfusion Support.
We have reviewed your query regarding the search in a foreign key column by using predicate. To better assist you, we kindly request you to provide us with additional information. Could you please provide us with the following details:
A sample of the grid rendering code.
A sample of the foreign key column data and grid data.
The version of the Syncfusion package you are currently using.
With these details, we will be able to provide you with an accurate solution.