Query Builder - Supported data types

[KS]

Hello,

I've been looking in the documentation trying to find what kinds of data types are supported by the Query Builder, but I haven't been able to find any.

Would it support things like TimeSpans, Booleans, etc?

Thank you,
KS

[Keerthikaran Venkatachalam]

Hi Ks,

We have checked the reported query, and the querybuilder column supports data types such as string, number, boolean, and date. Kindly refer to the below code snippet and UG Link.

  <ejs-querybuilder width="70%" [rule]="importRules">

    <e-columns>

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

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

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

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

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

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

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

    </e-columns>

  </ejs-querybuilder>

UG Link: https://ej2.syncfusion.com/angular/documentation/query-builder/getting-started#rendering-with-rule

Get back to us if you need any further assistance on this.

Regards,

KeerthiKaran K V