/
Model Queries Project: Last date run

Model Queries Project: Last date run

Owned by Elizabeth Storrs, created
Jan 23, 2025
1 min read

Slate Instance

all

Requestor

Elizabeth Storrs

Date

Jan 23, 2025

Status

PENDING

Summary Description

develop usable custom sql query: when was query last run

External Documentation

TechConnect Ticket

 

Box Folder

 

Desired Deliverable

A query that returns last run date for queries

  • sort by last run date, newest to oldest

  • filter to ask about specific queries

  • export link to query itself

  • only active queries

Research

from https://community.technolutions.net/archived-posts/post/query-last-run-date-export-Abn4VkLrg6yuRuT

SELECT
q.[name]
,qr.[created] as [Last Run?]
,u.[name] as [Run by]
,q.[created]
,q.[updated]
,[folder]
,[sql_updated]
,[folder1]
,[folder2]
FROM [query] q
Left Join [query.run] qr on (q.[id] =

Have built in TUH: https://gradhlthsci.admissions.tufts.edu/manage/query/build?id=1930526c-d35d-486c-a2cc-ce5c28da739b

Returns more than 8K queries

Testing Plan

 

Outcome