will that work?
But will it use a name or age index? Age index bad example but hey. Sqlquery is a class so you can extend/replace it. We came up with a syntax where the sql would generate based on the parameters. So you could do
SELECT TOP 5 ID, Name, Age, SSN FROM Sample.Person
WHERE 1=1
--If Name'=""
And Name %STARTSWITH :Name
--endif
--if Age'=""
AND Age >= :Age
--endif
Certifications & Credly badges:
Paul has no Certifications & Credly badges yet.
Global Masters badges:
Paul has no Global Masters badges yet.
Followers:
Paul has no followers yet.
Following:
Paul has not followed anybody yet.
The way I would gather the globals the process looks at would be to slip something into the logon code that traced all the $zr changes to a trace file. Its not exactly what you asked for as it wouldn't be on a different process.
s %oldzr=""
zbreak /trace:all:"/durable/trace.log"
zbreak $:"T":"%oldzr'=$zr":"s %oldzr=$zr w $zr"
d ..yourthing()
You could try to %Studio.Debugger Attach to the user's process and do a similar thing.