Page 1 of 1
Query to list new files added within the last 'x' days
Posted: Fri Mar 10, 2023 5:49 pm
by jjbahnsen
Does anyone have a SQL query that will list all the new files added to the vault for a specific time period along with several variable values? My SQL query skills aren't too bad but I haven't been able to figure this out. Thanks!
Re: Query to list new files added within the last 'x' days
Posted: Mon Mar 13, 2023 11:04 am
by bnemec
There is added to vault and first check in, they're different but I believe searchable.
Searching variable values in SQL is more difficult IMO. I use the API search, when possible, for searching by variable value. I've done it with SQL in the past but it took a lot of searching and research to find the right joins to get the correct data. The variable values are stored by version and the version number in the variable value row is the last version that the variable value changed, so not necessarily the latest version.