How to write json query with multiple where condition

sbxr — Sat, 16 Nov 2024 03:44:13 GMT

i want to add filter in all the tables 'Test1','Test2','Test3','Test4' where Status='Active' in below json Quey.

"{
'select': {
'from':[
'Test1',
'Test2',
'Test3',
'Test4'
],
'fields':[
{'field': 'Test1/Test1Id'},
{'field': 'Test1/Test1Name'},
{'field': 'Test1/Test1Description'},
{
'alias': [
{'name': 'Test1Status'},
{'field': 'Test1/Status'}
]
},
{'field': 'Test2/Test2Id'},
{'field': 'Test2/Test2Name'},
{'field': 'Test2/Test2Description'},
{
'alias': [
{'name': 'Test2Status'},
{'field': 'Test2/Status'}
]
},
{'field': 'Test3/Test3Id'},
{'field': 'Test3/Test3Code'},
{'field': 'Test3/Test3Name'},
{'field': 'Test3/Test3Description'},
{'field': 'Test3/LocalizedName'},
{'field': 'Test4/Test4Id'},
{'field': 'Test4/Test4Code'},
{'field': 'Test4/Test4Name'}
],
'joins':[
{'from':'Test1/Test2',
'on':'Test2/Test2Id'},
{'from':'Test2/Test3',
'on':'Test3/Test3Id'},
{'from':'Test3/Test4',
'on':'Test4/Test4Id'}
}
]
}
}"

topic How to write json query with multiple where condition in Talend Studio

How to write json query with multiple where condition