go to post Paul Waterman · Oct 31 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. 0 0 https://community.intersystems.com/post/list-global-referenced-process-similar-zreference#comment-241436 go to post Paul Waterman · Jun 22, 2022 will that work? 0 0 https://community.intersystems.com/post/inline-if-and-assignment#comment-193296 go to post Paul Waterman · Oct 23, 2020 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 0 0 https://community.intersystems.com/post/give-it-try-sqlbuilder-tool#comment-136076 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.