Excel-Like Filter Error In Grid, Does not display menu for only one Field

[Levi Leonards]

I am having an error with one of  the fields in my Grid Control. All other fields create the Excel-Like Filtering menus when the Column Filter Icon is pressed, but one filter does not display the menu, but instead creates input boxes and blank buttons below the Grid.

It look like this:

Show rows where

[INPUT BOX] [INPUT BOX]

[RADIO BUTTON] AND [RADIO BUTTON] OR

[INPUT BOX] [INPUT BOX]

[BLANK BUTTON] [BLANK BUTTON]

Attached is an image of what is created after clicking the Column Filter

Attachment: Excel_Menu_Filter_Error_39d500fd.zip

[Vignesh Natarajan]

Hi Levi, 

 

Thanks for contacting Syncfusion Support. 

 

Query: “ but instead creates input boxes and blank buttons below the Grid.” 

 

From your query, we understand that you are facing issue while opening a excel filter dialog for certain column.The reported issue may occur when there is no record in ejGrid. Or Initially rendering the Grid with empty data and later updated the dataSource. By default Grid column will assign its type based on first record.  But when we bind empty dataSource to Grid, values will be null and column type will not be assigned. Hence the reported issue occur.  

 

To overcome the reported issue, we suggest you to specify Type property of the column to perform the filtering operation.   

 

Refer to the code example:- 

 

<ej:Grid ID="Grid1" runat="server" AllowPaging="true"> 

        <Columns> 

            <ej:Column Field="OrderID" /> 

            <ej:Column Field="CustomerID" Type="string" /> 

            <ej:Column Field="EmployeeID" Type="number" /> 

            .   .    . 

       </Columns> 

    </ej:Grid> 

 

Refer our UG and KB document fr your reference 

 

KB:https://www.syncfusion.com/kb/3539/error-in-filter-menu-number-date-and-boolean-columns-have-incorrect-operators 

 

UG: - https://help.syncfusion.com/aspnet-core/grid/columns#type 

 

Please get back to us if you need any further assistance. 

 

Regards, 

Vignesh Natarajan. 

 

[Levi Leonards]

Specifying the type fixed my error...thanks!

[Vignesh Natarajan]

Hi Levi, 

Thanks for the update. 

We are glad to hear that your query has been resolved by our solution.  

Please get back to us if you have further queries. 

Regards, 

Vignesh Natarajan.