Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
sbxr
Contributor III
Contributor III

How to write json query with multiple where condition

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'}
}
]
}
}"

Labels (3)
0 Replies