cancel
Showing results for 
Search instead for 
Did you mean: 

DQL report asasistance

Smudgers9
Level 2

Hi,  The below report workeduntil we recently upgraded to 6.1 and now it fails with syntax errors.  Can you advise why this is failing please?

FROM path

Get basename, absname, created_on

If matchi(basename,’"*User name*")=1

OR matchi(basename,’"*name*")=1

OR matchi(basename,’"*Address*")=1

AND extension IN ("doc","PDF","csv","JPG","PNG","vsd","ppt","xls","docx","xlsx","rtf","txt")

AND created_on >= datetime("2014/12/10 00:00", "YYYY/MM/DD HH:mm")

AND created_on <= datetime("2015/02/20 00:00", "YYYY/MM/DD HH:mm")

 

2 REPLIES 2

VirgilDobos
Level 6
Partner    VIP    Accredited Certified

What is the error you are getting? Is it not giving you any hints on which table/column got changed?

--Virgil

Rod_p1
Level 6
Employee Accredited Certified

Does it validate and not just return data? The scope is likely older than your retention and may be a problem.

Check the reportrun log for the report to see if it errs or just returns no data.
also for you comparison can you define your created_on to a human time as your conditional  will not work on the epoch value returned.

Try formatdate(created_on,'YYYY-MM-DD HH:mm') AS created_date replacing your 'created_on' in the Get stmt.


Rod