gliderecord-patterns

GlideRecord supports standard CRUD operations in ServiceNow, allowing developers to insert, update, and delete records programmatically. You instantiate the GlideRecord class, specify the target table, and call the insert, update, or deleteRecord methods.

An encoded query in ServiceNow is a URL-encoded string representing complex database filters. Using addEncodedQuery with GlideRecord applies multiple conditions efficiently, replicating list view filters directly within server-side scripting for precise data retrieval.

GlideRecord bulk updates in ServiceNow involve querying a record set and iterating through the results to modify fields. You call update on each record within the loop, ensuring security constraints are checked while applying changes across multiple database entries.

GlideRecord security in ServiceNow involves enforcing access controls and query business rules during database operations. Developers must ensure scripts respect ACLs and avoid bypassing security checks when inserting, updating, or deleting records to maintain data integrity.

Slow GlideRecord performance in ServiceNow often stems from missing setLimit usage, inefficient addQuery conditions, or retrieving unnecessary fields. Optimizing database operations requires limiting result sets and ensuring queries leverage database indexes properly.