I ran a home-brew trace for the length of 1 day that captured a few things that were running. The trace includes the specific query text, the parent entity text of that query, the Plan Handle, and the Query Plan Hash.
Usually I can use RedGate's SQL Search on the query text to find the entity I'm looking for but that was a no-go in this case. Unfortunately that was a day ago when the trace ran, and when I check the sys.dm_exec_cached_plans DMV, nothing is turning up for my plan handle.
Are there any other ways I can backtrace this query?
Update: Here's how the Query Store is currently configured on the database in question. Note sure if it can be useful for my case?