When using IN operator, Value does not populate correctly in Query builder

Question

I am trying to populate data from the controller into the builder. I can get it working with the equal and greaterthan operators. However, when I try to use the in operator. The value is not rendering correctly and is causing a console error. The value is the string "JEWEL" and when I see it in the query builder it shows ,J,E,W,E,L. This is causing a console error. I need it to render the entire string as a single string.

QueryBuilderRule rule = new QueryBuilderRule { Label = splitString[0], Field = splitString[0], Type = "string", Operator = "in", Value = "JEWEL" });

QueryBuilderRule query = new QueryBuilderRule()

{

Condition = condition,

Rules = rule

};

ViewBag.rule = query;

<ejs-querybuilder id="querybuilder" width="73%" rule="ViewBag.rule" columns="ViewBag.Columns" maxGroupCount=5 created="createdControl">

</ejs-querybuilder>

Thanks,

Dana

Gayathri KarunaiAnandam · Accepted Answer

Hi Dana, We have checked your reported query. We would like to let you know that for in operator our behavior is when there is datasource we will render multiselect component. If there is no datasource, we will render textbox component. We have prepared a sample in which textbox will render. Please check the below code snippet and sample. Index.cshtml

HomeController.cs public ActionResult Index() { List values = new List { "Sales Manager" }; QueryBuilderRule rule = new QueryBuilderRule() { Condition = "and", Rules = new List() { new QueryBuilderRule { Label="Employee ID", Field="EmployeeID", Type="number", Operator="equal", Value = 1 }, new QueryBuilderRule { Label="Title", Field="Title", Type="string", Operator="in", Value = values } } }; ViewBag.rule = rule; return View(); } Sample: https://www.syncfusion.com/downloads/support/forum/163401/ze/Qb_core-1594035992 Please get back to us, if you need further assistance. Regards, Gayathri K

Gayathri KarunaiAnandam · Answer

Hi Dana,

Thank you for contacting Syncfusion support.

We have checked your reported query. We would like to let you know that “in” operator is used to select multiple items. So, we render a multiselect component. In your code snippet, you have used a single string as value. So, it split the value into multiple items. For in operator, you have to pass the value in an array. Please check the below code snippet and sample

HomeController.cs

List<string> values = new List<string> { "Sales Manager" };

QueryBuilderRule rule = new QueryBuilderRule()

{

Condition = "and",

Rules = new List<QueryBuilderRule>()

{

new QueryBuilderRule { Label="Employee ID", Field="EmployeeID", Type="number", Operator="equal", Value = 1 },

new QueryBuilderRule { Label="Title", Field="Title", Type="string", Operator="in", Value = values }

}

};

ViewBag.rule = rule;

ViewBag.dataSource = EmployeeView.GetAllRecords();

return View();

Sample: https://www.syncfusion.com/downloads/support/forum/163401/ze/Qb_core702779370

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

Regards,

Gayathri K

Dana Kiehl · Answer

Hello,Thanks for the response. It partially solved the issue I was having. I can now get the array of items to populate in the box but only if I don't have a datasource. If I have a datasource the values don't populate and there is a multiselect dropdown to choose items from. If I take the datasource out, the values will populate upon rendering but there is obviously no multiselect dropdown. Thanks,Dana

Dana Kiehl · Answer

Thank you for your help on this, I was able to get this working on my project.

Gayathri KarunaiAnandam · Answer

Hi Dana, 

Thanks for the update. 

We are happy to hear that your requirement has been fulfilled. Please feel free to contact us if you need any further assistance on this. 

Regards, 
Gayathri K