Create a report using keyword search in Envision
Im trying to generate a report in envision where the results returned are various specific keywords in URL header for a particular user.
I have it something like this :
Username = 'domain\john.doe'
URL LIKE '%example1%'
URL LIKE '%example2%'
As soon as I use the OR statement, the USERNAME statement is negated.. any help would be great.
I just tested this out and found an easy solution.
UserName = 'johndoe' AND (URL LIKE ('%example1%') OR URL LIKE ('%example2%'))
When adding the parens around the URL LIKE section it fixes the issue.
Hopefully this helps!