A while back I was working on a project where I ended up having to write some GlideRecord queries based on quite a few different tables and parameters. I was using syntax editor macros along with the find and replace feature in the syntax editor, but it seemed to me like it should be easier than.

I started thinking about what I really wanted, and what I decided was that I wanted a way to generate a GlideRecord query from a list that contained the table name, the encoded query string, the sort field, and allow me to set the variable name of the GlideRecord object. Once I had those goals, the execution was actually pretty straightforward, so I built it out and uploaded it to share.

Get GlideRecord Query from List

Here's a screenshot demo of how it works after you've uploaded the update set into your instance.

First you can go to any list and add some queries to the filter:

Then run the query and click the Get Query list banner ui action and you'll get a prompt to name you GlideRecord object variable.

Name it (something other than gr) and hit ok, and you'll get another popup with your generated GlideRecord code.

Now hit CTRL+C and paste that into your script editor of choice:

That's it! Just a simple way to easily generate a GlideRecord query from a list of records to use wherever you'd like.