Hey,
I have a big base search and I want to add a condition in the search that would remove/ filter out Asset_State if either Development or "Pre-Production" ONLY IF Asset_Environment!="PKI Offline" Status="2.
At the moment, this is the line in the query I have for this:
.......| if(Asset_Environment!="PKI Offline" Status="2, search NOT (Asset_State!="Development" OR Asset_State!="Pre-Production") |....
Syntactically, I know this is incorrect .... can someone please help???
Many thanks as always!!!