Search and date format not working

[Ivan Petrov]

Hello,

The search bar doesn't work for me. Also when I set a date column with custom format like CustomFormat="@(new{ type = "date" , format= "dd.MM.yyyy" })" the format is not like the one specified.

[Renjith Singh Rajendran]

Hi Ivan,

Thanks for contacting Syncfusion support.

Query 1 :  The search bar doesn't work for me.

We need more details to further proceed on this and provide you a solution as early as possible. Please share with us the following details for better assistance.

         

             1 . Share the details of the type of data, in which you have faced the search problem.

             2 . Share the sample which you have tried from your side.

             3 . Share the Syncfusion version details.

             2 . Share the details of script error if any occurred in the console.

Query 2 : I set a date column with custom format like CustomFormat

We have deprecated the CustomFormat property of Grid Column in our latest versions 17.4.0.40 and you can use Format property of GridColumn to apply date format in C# standard. So kindly upgrade to our latest version to apply date format in C# standard. Please find the latest Nuget package and release notes regarding the changes we have implemented in our Grid. 

Nuget:  https://www.nuget.org/packages/Syncfusion.EJ2.Blazor/17.4.0.40 

Release Notes: https://ej2.syncfusion.com/blazor/documentation/release-notes/17.4.39/#grid
 

https://ej2.syncfusion.com/blazor/documentation/release-notes/17.4.39/#common 

  

Kindly refer the below documentation to upgrade to our latest version 

https://ej2.syncfusion.com/blazor/documentation/grid/how-to/upgrade-application-to-latest-version/ 

Please get back to us if you need further assistance.

Regards,

Renjith Singh Rajendran.

[Ivan Petrov]

I am talking about the general search (in the upper right part of the grid) that searches all of the columns. I am using version  17.4.0.40 and the data in the columns are strings but when searching for specific content the search does not work.

[Vignesh Natarajan]

Hi Ivan,  

 

Query: “I am using version  17.4.0.40 and the data in the columns are strings but when searching for specific content the search does not work” 

 

We are not able to reproduce the reported issue at our end with the provided details. We are able to search the string values properly in 17.4.0.40 version. So kindly share the details requested in the previous update to validate the issue further along with video demonstration.  

 

Kindly download the sample from below which we have prepared using our latest version  

 

Sample: https://www.syncfusion.com/downloads/support/forum/150189/ze/BlazorApp1-968685464  

 

If possible try to reproduce the reported issue in provided sample and get back to us. 

 

Regards, 

Vignesh Natarajan. 

[Bobby Caldwell]

So I am also running into an issue where Search does not work when using a custom DataAdaptor and at least 1 GridColumn has ForeignKeyField, ForeignKeyValue and DataSource defined. I was able to reproduce the issue in the example project you provided.

Attached a copy of the modified example project.

Edit: Also should I make a new topic for this, since my issue is specific to searching only?

Attachment: BlazorApp1SearchWithCustomDataAdaptor_94510dc5.zip

[Vignesh Natarajan]

Hi Bobby,  

 

Thanks for contacting Syncfusion support.  

 

Query: “Search does not work when using a custom DataAdaptor and at least 1 GridColumn has ForeignKeyField, ForeignKeyValue and DataSource defined” 

 

Currently, we don’t have support to perform search action in Foreign key column. We have considered this as a feature “Need to provide search support for foreignkey column in Blazor Grid”. We have logged a feature task for the same and added to our feature request list. We are always trying to make our products better and feature requests like yours are a key part of our product growth efforts. 

  

At the planning stage for every release cycle, we review all open features and identify features for implementation based on specific parameters including product vision and technological feasibility. We have planned to implement this feature in our next release 2020 Volume 1 release which is  expected to be rolled out in the month of March 2020.  

 

You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link.  

 

Link : https://www.syncfusion.com/feedback/11386/need-to-provide-search-support-for-foreignkey-column-in-blazor-grid  

 

Till then we appreciate your patience 

 

Regards, 

Vignesh Natarajan. 

[Bobby Caldwell]

This is great that you are looking into making the search feature work with foreignkey columns. However in one of my grids, there is only one column with a foreignkey, while the rest are just string and boolean columns. Why would having 1 foreignkey column completely break searching? I would still like to search against the other columns. Is that possible?

[Vignesh Natarajan]

Hi Bobby,  

 

Query: “I would still like to search against the other columns. Is that possible?” 

 

Yes. As an workaround we can achieve your requirement (to search in specific columns with custom adaptor) by defining the GridSearchSettings and GridFilterSettings under the EjsGrid. Refer the below code example.  

 

<EjsGrid @ref="grid" TValue="Order" Toolbar="@(new List<string> { "Search"})" Height="315">   

    <GridFilterSettings Columns="@FilterCols"></GridFilterSettings> 

    <GridSearchSettings Fields="@Cols"></GridSearchSettings> 

    <EjsDataManager AdaptorInstance="@typeof(CustomAdaptor)" Adaptor="Adaptors.CustomAdaptor"></EjsDataManager> 

    <GridColumns> 

. . . . . . . . . . . 

    </GridColumns> 

</EjsGrid> 

 

@code{ 

    EjsGrid<Order> grid { get; set; } 

    public List<GridFilterColumn> FilterCols = new List<GridFilterColumn>(); 

    public static List<Order> Orders { get; set; } 

    public string[] Cols = new string[] { "OrderID", "OrderDate", "Freight" }; // define the columns here excluding the foreignkey column 

 

Please get back to us if you have further queries. 

 

Regards, 

Vignesh Natarajan.