I have created a dashboard with table where I have couple of filters.
I’m using elasticsearch datasource
My requirement is when I select Transaction Type= PO only PO events have to be displayed, when I select Transaction Type= ASN, then it should display only those appropriate transaction type. Currently I’m able to display that.
Since each transaction type has its own group/orderby clause.I’m thinking to write multiple different queries inside a panel, but how to choose query A when I select the transaction type=PO and choose query B when select transaction type=ASN,
OR
How can i combine all into one query with conditional statements if i want to explore that option?
tried the below query but its not working
Query: AuditID.keyword:* AND NOT AuditID.keyword:“” AND TransactionType:(“${TransactionType}” == “PurchaseOrder”) AND PONumber:“$PONumber”
Any help is appreciated. Thank you!!