I thought I’d share one of my favorite newish parts of ServiceNow: the GlideQuery class! It’s a modern replacement to the GlideRecord class for use in ServiceNow backend scripting based upon Functional Programming principles.
GlideQuery is IMO much easier to work with in many common use-cases, though many situations still where GlideRecord remains the superior choice. Nevertheless, I think you’ll enjoy using GlideQuery if you spend any considerable amount of time scripting on the platform!
Even if you take it slow at first, one thing I can immediately recommend is replacing
GlideAggregate.GlideQueryis designed to be able to replaceGlideAggregate, too, andGlideQuery’s aggregate methods are much less complicated to use by comparison. Total no-brainer for even the grooviest of developers 😉