Hi again, I didn't see if/how this is possible in the docs - I would like a real-time trigger for new/updated servicenow incidents that has the structure of A and B and (C or D). So ABC or ABD would be accepted triggers. The docs only explain using only ANDs or only ORs. There was not much info on the servicenow query language except that it was a filter and not described as part of the trigger. Clarity would be helpful. Image of my AND version, but there was no option to add an OR after doing ANDs.
(The rather odd looking second clause "not equal to true is true" is because I want to include both false and null values, and the drop down list of conditions doesn't allow me to check for that combination)
Looks like formulas in the data fields is the way to do this. Continuing this for clarity, my use case is more A and B and (C or D or E), which would ABC or ABD or ABE, but it would seem much faster to combine 2 simple ANDs and (C or D or E) in one step vs, three long AND formulas. Can I do the 2 simple ANDs and (C or D or E) in one step? or rather what would the data field look like to combine the C or D or E into one datafield formula so I can use the three AND version? Thanks again for your help.
Yes 😀 Over to you to try it out in your Dev environment...
I have nothing to try, since I don't know how to do blind ORs in the trigger form. If there is no way to do it, just tell me, as I've already spent time reading and looking for examples before I asked. Again, the question is one of efficiency, speed, and readability of code --> Can I do the 2 simple ANDs and (C or D or E) in one step? I have to pose the question this way since I've asked other folks and they suggest 3 ORs which misses the 3 ANDs, where the last AND is the 3 ORs. Inquiring minds want to know.
I'm not able to access slack on my computer to give you a screenshot, but try to make a variable that calculates as true like 1==1 && 2==2. Then try 1==1 || 2==1. After that, string them together with some parenthesis. Do this all in a test recipe not in the trigger so you can see how the values react. Once you have the formula you want, put it in the trigger
Thanks Amy, that helps! I didn't know that OR was simply pipe symbols. I'm not familiar with Ruby and past attempts to try ruby formatting failed. Now I can do what RussellJ said and try stuff in dev.