I have an event panel with 5 dropdown boxes as shown to be able to filter the base results based of 5 categories
by app name - there are two Apps BPE and BPO
by sts eg 400's or 500's response codes etc
by mtd eg API method POST PATCH GET etc
by booking ref
by cal eg Calling API
This is the event search I created to return the base results
app=BP* sts=* | table at,req.bookingReference,app,mtd,cid,sts,dur,rsc,cal,req.offerOptionCode | rename req.bookingReference as bookingReference, req.offerOptionCode as offerOptionCode| search app=* AND mtd=* AND sts=* AND bookingReference=* AND cal=* | sort by at asc
When i remove the "search app=* AND mtd=* AND sts=* AND bookingReference=* AND cal=*" from the query, I then seem to get all the expected results which include POST PATCH and GET items, but with it included, I only get POST method results and not the GET and PATCH items.
i suspect the AND statements are the culprit...I tried OR but then the filters don't work and won't filter the base results. Appreciate any guidance
Thanks
... View more