not sure of this, but I think an additonal WHERE might be missing from the combined statement.
I would try this:
&where=(where (and (contains DLP_EventView.UserName "user.name") (newerThan DLP_EventView.InsertionTime 7776000)))
instead of this:
&where=(and (contains DLP_EventView.UserName "user.name") (newerThan DLP_EventView.InsertionTime 7776000))
the reason might be is that first "where" is the http "where" and the new "where" is submitted to the SELECT clause.
Told you, not sure of this, but according to the WebAPI guide, another WHERE is needed within the expression. See ex. p31.
(Also I would use a SELECT * first until I got sure the statement is working, then add the actual field names to display.)
Hi. I tried your suggestion but the result is the same - the page that is returned only says "OK:" with no data.
I'm using cURL with webAPI, and there is a sort of debug mode, by enabling
--trace FILE Write a debug trace to the given file
command. sometimes helps, showing where the command has stuck.
Try it with cURL.
In additon: have you tried running the combined statement in the ePO GUI (if applicable)?