I’m trying to filter a specific device within the following relevance, but no matter where I put the whose condition, it doesn’t work:
Q: (ID of item 1 of it as string | "N/A") of (elements of ((set of targeted computers of it - set of computers of results of it)) whose (name of it = "My Machine"), it) of bes actions whose (name of it as lowercase contains "MY ACTION" as lowercase)
E: The operator "name" is not defined.
I also tried filtering with:
exists targeted computers of it whose (name of it = "My Machine")
However, applying the filter directly on the targeted computers works but defeats the overall purpose of the query.
Your are running this as Session Relevance, right, in Web Reports or Dashboard or REST API?
From the parentheses I think you are evaluating name of it against the set, not against the elements of the set, so you may need to rearrange that bit. I’m typing on a phone now and cannot check, but hope that points you in a good direction. Ping me later if you’re still stuck and I’ll check from a console.
@vk.khurava Here is a suggestion following Jason’s input. One tip that I do is in the filter, I get the session relevance to work first by simply placing true in the whose clause. Once I get that to work, then I can filter based on my needs:
(ID of item 1 of it as string | "N/A") of ((elements of (set of targeted computers of it - set of computers of results of it)) whose (true), it) of bes actions whose (true)
Once I get the above working, then focus on the filter as a suggestion:
(ID of item 1 of it as string | "N/A") of ((elements of (set of targeted computers of it - set of computers of results of it)) whose (name of it = "My Machine"), it) of bes actions whose (name of it as lowercase contains "MY ACTION" as lowercase)
Thanks for the TIP@JasonWalker & for testing the relevance @gus getting desired results!
//Working one:
Q: (ID of item 1 of it as string | "N/A") of ((elements of (set of targeted computers of it - set of computers of results of it)) whose (name of it = "My Machine"), it) of bes actions whose (id of it = MY Action)
A: MY Action