Video: Creator Toolbox - GlideQuery

[Chuck Tomasi]

On this episode, join Andrew, Brad, Chuck and special guest and creator of GlideQuery, Peter Bell, as they convert some of their legacy GlideRecord and GlideAggregate scripts to the new GlideQuery API.

Topics

• 00:00 Start
• 01:25 Welcome and introductions
• 04:45 GlideQuery Overview
• 08:51 Our objective
• 10:42 Screen share started
• 11:10 Converting an existing record insert
• 20:09 Bringing back extra data on insert
• 21:30 Using the $DISPLAY flag
• 29:44 Replacing GlideRecordSecure
• 30:28 Replacing GlideAggregate
• 37:04 having() explained
• 41:25 toArray() and what it returns
• 47:45 Checking if a profile exists
• 49:45 get() vs. where()/select() and selectOne()
• 51:58 using global.GQ.jsonDebug
• 53:22 Attempting to get() or insert()
• 58:48 Summary
• 1:00:01 Special announcements

Links

• Blog entries w/GlideQuery tag
• GlideQuery API Reference (Q)

About

Creator Toolbox is a weekly show provided by the ServiceNow Developer Program. Each Tuesday, join the Developer Advocate team and guests as they showcase the platform tools you need to get your job done quickly. Join us each Tuesday at 8AM PT/11AM ET (save the last Tuesday of each month.)

Hosts

Andrew Barnes, Brad Tilton, Chuck Tomasi, Peter Bell