We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Search in grid foreign field values

Thread ID:

Created:

Updated:

Platform:

Replies:

147066 Aug 30,2019 02:08 PM UTC Sep 2,2019 07:33 AM UTC ASP.NET MVC - EJ 2 1
loading
Tags: Grid
Vanderlei
Asked On August 30, 2019 02:08 PM UTC

Hi guys,

Using EJ2, ASP NET MVC, VS2017

I´d like to be able to search for foreign field values in a grid component. Please see the code bellow:


In this code I am able to search in "numdemanda", it is working fine. I am trying to add search capability to look for values in "clienterz" field (first ForeignKeyValue) and in "itemnome" field (second ForeignKeyValue). 
1 - All field values are listing ok in grid, is it possible to search in its values?
2 - Is it possible to filter grid based on ForeignKeyValues as well?

Thank you!


Pavithra Subramaniyam [Syncfusion]
Replied On September 2, 2019 07:33 AM UTC

Hi Vanderlei, 
 
Query#1: All field values are listing ok in grid, is it possible to search in its values? 
 
Yes, In essential JavaScript 2 Grid foreign Key columns , you need to provide the “foreignKeyField” value in the searchSettings property which is the default behavior. So you can filter the foreignKey values based on the entered values in search box or in searchSettings option 
 
Query#2: Is it possible to filter grid based on ForeignKeyValues as well? 
 
Yes you can filter the foreign key values by default without any customization. Please refer to the below demo link for your reference. 
 
 
Please get back to us if you need any further assistance on this. 
 
Regards, 
Pavithra S. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon