Search fields of related records in Grid search

[Greg Hendricks]

Hello,

I am using the built in search function for my Grid and each record has a list of related records named "People".  I tried adding the People field to GridSearchSettings, but I am not getting any results when I search for the name of a person.  How can I specify fields from related records to search or provide my own search method?

[Prathap Senthil]

Hi Greg Hendricks,

Based on your query, we suspect you have bound the grid column's Field property to a List<T> type, as shown in the example below:

public class RecordModel
{ public int Id { get; set; }
public string Name { get; set; }
public List<Person> People { get; set; }
-----
}

We would like to inform you that, based on your requirement, our current functionality does not support data operations or CRUD operations on columns that represent one-to-many relationships (List<Class>). Already, we have already considered a feature task to implement this feature “Provide data operation for one to many relationship columns” request, and added this to our feature request list. Based on specific parameters including product vision and technological feasibility we will implement this feature in any of our upcoming releases.

Please follow up on the feedback report page link below for future updates regarding the release timeline for this feature.

Feedback Link: https://www.syncfusion.com/feedback/12731/provide-data-operation-for-one-to-many-relationship-columns  

You can also communicate with us regarding the open feature any time using our above feedback report page. We do not have immediate plan to implement this feature and it will be included in any of our upcoming releases. So that we will prioritize the improvement for every release based on demands. Thanks for your understanding.

Regards,
Prathap Senthil

[Greg Hendricks]

Thank you for the response.  Is there a way to override the default grid search function with my own?

[Prathap Senthil]

Regarding your requirement, we regret to inform you that it is currently not feasible to override the inbuilt searching functionality when using the one-to-many column. Thank you for your understanding.