Latest Activity

code

VQL to show all cached sources and when it was last refreshed?

Is there a way to get a result set that has the view, number of rows and the last cache refresh date? I want to make this a data set availbe easily to end-users to see when the cache was last updated. I have scoured the user documentation but do not ...

vql query LASTCACHEREFRESH Cache

code

Incremental mode last_modified_date > '@LASTCACHEREFRESH'

What is the date format of the variable LASTCACHEREFRESH My data has a column last_updated with a data type as "text" and value like "2019-01-22 11:00" but using the condition last_updated > @LASTCACHEREFRESH and the cache does not get loaded. I ha...

LASTCACHEREFRESH