Current i want to implement my own dashboard page and need to get result of custom query(SqlDataSource) and i am also trying to make it as extension.
Is there anyway that i can directly query to current sqlstorage? Or how can i get current ConnectionString of the job storage that i specified on startup?
My goal is: i am gonna save the return value of the job to by using jobfilters. And save that value to JobParameters table by using PerformedContext.Context.SetJobParameter
Hangfire already saves that value in one column but that value is json string. To filter by return value first i need to get all jobs. But i have hundreds of thousands of jobs. So it will be slow.
I hope u understand my point