Limit Operator type

Hi,

As per title say, how I do show only "Equal" and "Contains" only in dropdown or maybe in radio button as shown in the demo.

The ASP.Net Core demo code is very confusing and lackluster compared to Javascript demo which is more complete, for me at least in how to replicate the result shown.


3 Replies 1 reply marked as answer

KV Keerthikaran Venkatachalam Syncfusion Team September 21, 2023 02:16 PM UTC

Hi Skye,


We have checked your reported query, and you can use the operators property of the querybuilder column to achieve your requirements. Please refer to the below code snippet.


@using Syncfusion.EJ2.QueryBuilder

@{

              List<string> values = new List<string> { "Mr.", "Mrs." };

              List<object> Operator = new List<object>{

                             new { key = "Equal", value = "equal" },

                             new { key = "Contains", value = "contains" },

              };

}

 

<ejs-querybuilder id="querybuilder" operators="ViewBag.Operator" width="73%">

              <e-querybuilder-columns>

                             <e-querybuilder-column field="EmployeeID" label="Employee ID" operators="Operator" type="number"></e-querybuilder-column>

                             <e-querybuilder-column field="FirstName" label="First Name" type="string"></e-querybuilder-column>

                             <e-querybuilder-column field="TitleOfCourtesy" label="Title Of Courtesy" type="boolean" values="values"></e-querybuilder-column>

                             <e-querybuilder-column field="Title" label="Title" type="string"></e-querybuilder-column>

                             <e-querybuilder-column field="HireDate" label="Hire Date" type="date" format="dd/MM/yyyy"></e-querybuilder-column>

                             <e-querybuilder-column field="Country" label="Country" type="string"></e-querybuilder-column>

                             <e-querybuilder-column field="City" label="City" type="string"></e-querybuilder-column>

              </e-querybuilder-columns>

 </ejs-querybuilder>


Please let us know if you need any further assistance on this.


Regards,

KeerthiKaran K V


Marked as answer

SK Skye October 16, 2023 08:37 AM UTC

Hi,


Thanks for the reply and the solutions, much appreaciate.



KV Keerthikaran Venkatachalam Syncfusion Team October 16, 2023 09:18 AM UTC

You are welcome, Skye. Please get back to us if you need any other assistance


Loader.
Up arrow icon