What is the difference between Most Recent Query Run At Date vs Most Recent Query Date

[mandy_chan]

Knowledge Drop

Last tested: Nov 17, 2020
 

Most Recent Query Run At Date is the most recent query run per query ID. Essentially, it finds the most recent date that the query was run.

Most Recent Query Date takes the most recent date of the History ID.

So for instance, if the Most Recent Query Run at Date says 2020-11-06 but the Most Recent Query Date says 2020-10-02, this suggests that the History ID of that query was created on 2020-10-02, but the query was ran most recently on 2020-11-06.

Reminder: The query ID is a unique combination of SQL text, connection and other fields. It's created the first time a SQL query is ran on a connection. The query ID can be linked to many History IDs

This content is subject to limited support.