Hi,
trying to run DB query (db connect1) on dashboard using the following command:
<panel>
<title>My title</title>
<single>
<title>Nmy title</title>
<searchString> | dbquery "DBNAME"" SELECT * FROM XXX Where CreatedDate >=dateadd(d,datediff(d,0, getdate()),-7) and CreatedDate<dateadd(d,datediff(d,0, getdate()),0)" | stats count </searchString>
</single>
</panel>
getting the error
Encountered the following error while trying to update: In handler 'views': Error parsing XML on line 95: Couldn't find end of Start Tag dateadd line 95
how can i count event from the last week not using sql syntax?
... View more