Excel Tools

Has anyone used the queryAppianLogs function to select a count from the files with a group by and a where condition ?

No matter what I try I'm getting a null value return ... using the query without the group by returns data, using the count without the where also returns data but when combining the two together to get a simple count from the removed processes log where the timestamp is today returns nothing.

Is this is a feature of the plug in ? We're using 2.5.0 

Any hints / tips would be appreciated. 

Thanks 

Paul

Has anyone used the queryAppianLogs function to select a count from the files with a group by and a where condition ?

No matter what I try I'm getting a null value return ... using the query without the group by returns data, using the count without the where also returns data but when combining the two together to get a simple count from the removed processes log where the timestamp is today returns nothing.

Is this is a feature of the plug in ? We're using 2.5.0 

Any hints / tips would be appreciated. 

Thanks 

Paul