GlideQuery Perks, Part 0.5: Resources
Before I start my GlideQuery series proper, I’d be remiss if I didn’t take two steps back and recognize all the great content already out there on the topic. I certainly didn’t discover all the benefits of GlideQuery myself, though I do have direct experience with most of them. This article will be a complete rundown on every publicly available resource I can find.
Mind you, I’m not presenting any of the following as pre-requisites to my series. I won’t assume you’ve engaged with any of this material beforehand. But likewise, I’ll do my best not to just regurgitate what others have said. Though of necessity I’ll be covering a lot of the same ground, wherever possible I’ll try to give it my own unique spin and share my own original usage examples.
So feel free to engage with as much or as little of what follows, or ignore it for now and explore it later if the rest of my series piques your interest.
Of course, the best place to start is arguably the official documentation. There are Docs pages for GlideQuery, Stream, and Optional. There are also mirrors of the same documentation on the Developer site (GlideQuery, Stream, and Optional).
Content featuring Peter Bell
Peter Bell is the senior engineer within ServiceNow who created GlideQuery as a side project to help him with his normal day job on the IT Asset Management team. Naturally, his own content is very well worth checking out.
Bell’s original CreatorCon 2020 breakout session, GlideQuery: A modern upgrade to GlideRecord (CCB3052) (and accompanying slide deck), is, as far as I know, the first time GlideQuery was announced officially to the public. It’s a great introduction to the API and all of its benefits over GlideRecord.
From January to April 2021, Bell published a series of excellent blog posts explaining how to use GlideQuery. There’s a lot of overlap here with the official documentation, but, where the docs simply list methods alphabetically, these posts order the topics more pedagogically:
In April ’21 Bell did an episode of Creator Toolbox on YouTube with Chuck Tomasi, Brad Tilton, and Andrew Barnes, “GlideQuery”. They work on refactoring some existing GlideRecord code to use GlideQuery instead, and along the way Bell shares a few interesting undocumented features.
In June ’21 Bell did another interview with Chuck Tomasi, this time on the Breakpoint podcast, “GlideQuery with Peter Bell”. This one is largely a review of the material in the original CreatorCon session, but he talks about some of the inspirations for GlideQuery and shares some useful info about the performance of GlideQuery compared to GlideRecord.
GlideQuery shipped in an early form as part of the ITAM suite in the Orlando release. A few people discovered it, but this post by Jace Benson is the only thing I can find that predates the official announcement: “What is GlideQuery”. After the official CreatorCon session came out (GlideQuery shipped officially in the Paris release), Benson followed his first post up with a full rundown of GlideQuery’s feature set: “Glide Freaking Query Wow”. Others have since posted cheat sheets for GlideQuery, such as Samuel Meylan’s “GlideQuery Cheat Sheet” and Alberto Colombo’s “GlideQuery Cheat Sheet”.
The above are the most important/useful bits of community content, but a number of other folks have blogged or published YouTube videos about GlideQuery (listing these in chronological order as far as dates could be ascertained):
- Dhruv Gupta: “GlideQuery Not GlideRecord”
- Lubos Strejcek: “GlideRecord or GlideQuery? That’s the question”
- John Skender: “GlideAggregate, GlideQuery or GlideRecord?”
- ServiceNow 911: “GlideRecord vs. GlideQuery”
- Steven Bell: “GlideQuery vs. GlideRecord: A Comparison”, Part 1 and Part 2
- Ahmed Drar: Querying with GlideQuery
- ismr: “GlideQuery API”, “GlideQuery Debug Functions”, and “GlideQuery Parse()”
Well, there you have it. That’s every single resource I can find online about GlideQuery. Have you found some additional documentation or a blog post, YouTube video, TikTok, or some other kind of media that I missed? Find me in the ServiceNow Developers Slack workspace or on Mastodon and let me know. Next up in the series I’ll start to dive into GlideQuery’s many benefits. Stay tuned!