Multiple Json Object as Table

[Deepak Jain]

How to add multiple json object and use predicate for and and or condition with join table

json data: {EMPLOYEE:[ {EMPID:1, NAME:DEEPAK}, {EMPID:2, NAME:JAIN}, {EMPID:3, NAME:SATISH}],              
                   SALARY:[ {EMPID:1, SALARY:20000}, {EMPID:2, SALARY:30000}, {EMPID:3, SALARY:35000}]

1. I want to fetch empid 1 salary with datamanger where predicate condition

2. I want to fetch salary for empid 1 or 3

3. I want to fetch salary for empid 1 and 3

make a query like

from Employee where (id=1 or id=2) and (salary=35000 or salary=20000)

[Prasanna Kumar Viswanathan]

Hi Deepak, 

 

Thanks for contacting Syncfusion support. 

 

Query : How to add multiple json object and use predicate for and and or condition with join table 

 

By default grid and datamanager only deals with array of JSON data. But the given data is in the object format, not a valid json array. if you bind JSON array to the grid or DataManager, you can able to filter the data using filterSettings.columns and query.  

 

Please refer the below documentation for DataManager query and filterSettings.columns    

 

 https://ej2.syncfusion.com/javascript/documentation/data/querying/#build-complex-filter-criteria-using-code-classlanguage-textpredicatecode 

 

https://ej2.syncfusion.com/javascript/documentation/grid/filtering/?no-cache=1#filter-operators 

          

Please get back to us if you need further assistance. 

 

Regards, 

Prasanna Kumar N.S.V 

 

[Deepak Jain]

Hi Prasanna,

I have not mentioned that I using datamanager with Grid. My requirements are different with your solution provided.

I am cascading to dropdowns with third json

dropdown 1 json : [{HQ_ID:1, HQ_NAME: "Agra"},
{HQ_ID:2, HQ_NAME: "Delhi"}]

dropdown 2 json : [{EMP_ID:1, EMP_NAME: "DEEPAK"},
{EMP_ID:2, EMP_NAME: "PRADEEP"}]

third json: [{empid_1: 1, empid_2: 0, hqid:1}, {empid_1: 0, empid_2, hqid: 2}]

I want to cascade a dropdown with this scenerio using predicate

query should be like this

where (empid_1 =  EMP_IDor empid_2 = EMP_ID) and hqid= HQ_ID

[Sureshkumar P]

Hi Deepak, 

 

We have checked the reported requirement. We prepared a cascading sample with a predicate query for filtering more than one field. Kindly refer the below code, 

 

var predicate = new ej.data.Predicate('StateId', 'startswith', stateObj.value, true);  

       predicate = predicate.or('StateName', 'contains', stateObj.value,true); 

 

We created a sample based on your requirement. please find the sample here: https://stackblitz.com/edit/iwq5d6-h898t6?file=index.js  

 

Regards, 

Sureshkumar P 

[Deepak Jain]

Thanks for your reply.

A single level predicating is fine but my requirement is more complex than your solution.

I want something like this

var predicate = new ej.data.Predicate('EMP_ID_1', 'equal', profile.EmpId, true); 

predicate.or('EMP_ID_2', 'equal', profile.EmpId, true);

predicate.or('EMP_ID_3', 'equal', profile.EmpId, true);

predicate.or('EMP_ID_4', 'equal', profile.EmpId, true);

var predicate2 = new ej.data.Predicate(predicate); 

predicate2 = predicate.and('StateId', 'equal', stateObj.value,true);

so the query will be like this where (emp_id_1=1 or emp_id_2=1 or emp_id_3=1 or emp_id_4=1) and state_id = 4

[Sureshkumar P]

Hi Deepak, 

 

Thanks for your update 

 

We have checked the reported requirement. We would like to let you know that you can more than one query in the predicate option as mentioned in the code snippet, 

 

var predicate = new ej.data.Predicate('StateId', 'startswith', stateObj.value, true); 

predicate = predicate.or('StateName', 'contains', stateObj.value, true); 

predicate = predicate.or('CountryId', 'contains', stateObj.value, true); 

 

var tempQuery1 = new ej.data.Query().where(predicate); 

 

var tempQuery1 = new ej.data.Query().where(predicate); 

 

And pass the predicate in the where query.to get rid of your facing issue. 

 

Regards, 

Sureshkumar P