Errors while using Query Builder

I am using the OOB code - 

import * as React from 'react';
import * as ReactDom from 'react-dom';
import { QueryBuilderComponent } from '@syncfusion/ej2-react-querybuilder';
import { DataManager, ODataV4Adaptor } from '@syncfusion/ej2-data';
function AdvancedSearchCase() {
    let data = new DataManager({
        url: 'https://services.odata.org/V4/Northwind/Northwind.svc/Orders/',
        adaptor: new ODataV4Adaptor
    });
    let columnData = [
        { field: 'EmployeeID', label: 'EmployeeID', type: 'number' },
        { field: 'FirstName', label: 'FirstName', type: 'string' },
        { field: 'TitleOfCourtesy', label: 'Title Of Courtesy', type: 'boolean', values: ['Mr.', 'Mrs.'] },
        { field: 'Title', label: 'Title', type: 'string' },
        { field: 'HireDate', label: 'HireDate', type: 'date', format: 'dd/MM/yyyy' },
        { field: 'Country', label: 'Country', type: 'string' },
        { field: 'City', label: 'City', type: 'string' }
    ];
    let importRules = {
        'condition': 'and',
        'rules': [{
                'label': 'EmployeeID',
                'field': 'EmployeeID',
                'type': 'number',
                'operator': 'equal',
                'value': 1
            },
            {
                'label': 'Title',
                'field': 'Title',
                'type': 'string',
                'operator': 'equal',
                'value': 'Sales Manager'
            }]
    };
    return (<QueryBuilderComponent width='100%' dataSource={data} columns={columnData} rule={importRules}></QueryBuilderComponent>);
}
export default AdvancedSearchCase;


I am getting the following error - 

adaptors.js:608 Uncaught TypeError: Cannot read properties of undefined (reading 'indexOf')

    at UrlAdaptor.processQuery (adaptors.js:608:1)

    at DataManager.executeLocal (manager.js:214:1)

    at QueryBuilder.render (query-builder.js:3445:1)

    at QueryBuilderComponent.render (querybuilder.component.js:38:1)

    at Component.appendTo (component.js:224:1)

    at ComponentBase.renderReactComponent (component-base.js:71:1)

    at ComponentBase.componentDidMount (component-base.js:52:1)

    at commitLayoutEffectOnFiber (react-dom.development.js:23305:1)

    at commitLayoutMountEffects_complete (react-dom.development.js:24688:1)

    at commitLayoutEffects_begin (react-dom.development.js:24674:1)




1 Reply

KV Keerthikaran Venkatachalam Syncfusion Team September 1, 2023 05:36 PM UTC

Hi Ameet,


We have checked the reported query and prepared the sample based on the requirements. It's working fine. Please refer to the sample below.


Sample Link: https://stackblitz.com/edit/react-8doeg9-zcafa2?file=index.js


If you still facing issue, could you please share the issue's replicable sample or replicate the issue in our sample with replication steps and a video demonstration? Based on that, we will check and provide you with a better solution quickly.


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


Regards,

KeerthiKaran K V


Loader.
Up arrow icon