Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'}}]}}"