Scoped GlideRecord is used for database operations. ServiceNow provides JavaScript APIs for use within scripts running on the ServiceNow platform to deliver common functionality. The code uses. GlideRecord - Global. Not all queries are easy to write, though, especially if you need to work with date fields or OR operators. If you are familiar with SQL, this method is similar to the "where" clause. You can create one or more queries for a single filter by calling this method multiple times. Execute the query. The client-side GlideRecord API cannot be used in scoped applications. But it's best practice to save dot-walking for reference fields, like for getting a Caller's Company name: gr. Always test queries on a sub-production instance prior to deploying them on a. GlideRecord - Global. If you are familiar with SQL, this method is similar to the "where" clause. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. GlideRecord - Global. How search works: Punctuation and capital letters are ignored. The scoped GlideAggregate class is an extension of GlideRecord and provides database aggregation (AVG, COUNT, GROUP_CONCAT, GROUP_CONCAT_DISTINCT, MAX, MIN, STDDEV, SUM) queries. If you are familiar with SQL, this method is similar to the "where" clause. GlideRecord. article for details on building and running queries. For information about GlideRecordSecure, which is a class inherited from GlideRecord that performs the same functions as GlideRecord, and also enforces ACLs, see the . GlideRecord. Scoped GlideRecord is used for database operations. For information about GlideRecordSecure, which is a class inherited from GlideRecord that performs the same functions as GlideRecord, and also enforces ACLs, see the . For information about GlideRecordSecure, which is a class inherited from GlideRecord that performs the same functions as GlideRecord, and also enforces ACLs, see the . Scoped GlideRecord is used for database operations. A GlideRecord contains both records and fields. addQuery(columnName, operatorName, value), where in the case of the dynamic field comparison operators, the value arg is the other column name. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. Scoped GlideRecord is used for database operations. However, GlideRecord gives OR precedence, doing the opposite (as in the second example). addOrCondition() isGlideRecord - Global. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that. addQuery(String fieldName, Object operator, Object value) Adds a filter to return records where the field meets the specified condition (field, operator, value). Scoped GlideRecord is used for database operations. addQuery ('priority', '1'); In the. The most common and fundamental scripting used in ServiceNow is GlideRecord. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that. Always test queries on a sub-production instance prior to deploying them on a. If you are familiar with SQL, this method is similar to the "where" clause. addQuery (String name, Object operator, Object value) Adds a filter to return records where the field meets the specified condition (field, operator, value). We’ve covered how to really understand addQuery() here. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that. Build the Query Condition(s) Use the addQuery() method to add query conditions. article for details on building and running queries. Please see this post for a detailled introduction. GlideRecord is used for database operations. A GlideRecord contains both records and fields. MySQL :: MySQL 8. company. Always test queries on a sub-production instance prior to deploying them on a. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. addQuery(String name, String operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table, that match the request. GlideRecord - Global. GlideRecord - Global. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that. Scoped GlideRecord is used for database operations. Always test queries on a sub-production instance prior to deploying them on a. This tutorial blog post is one of those experiments. addQuery(String fieldName, Object operator, Object value) Adds a filter to return records where the field meets the specified condition (field, operator, value). 0 Reference Manual :: 13 SQL Statement Syntax. If you are familiar with SQL, this method is similar to the "where" clause. With GlideRecord queries, you can find any set of records you need in ServiceNow. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. If you are familiar with SQL, this method is similar to the "where" clause. If you are familiar with SQL, this method is similar to the "where" clause. Scoped GlideRecord is used for database operations. When I try to run the script to check the local user table, it returns "sys_idNotValidnull" for the query statement I add. GlideRecord - Global. We are very interested in your feedback. Always test queries on a sub-production instance prior to deploying them on a. For information about GlideRecordSecure, which is a class inherited from GlideRecord that performs the same functions as GlideRecord, and also enforces ACLs, see the . A GlideRecord contains both records and fields. Use the API to instantiate a GlideRecord object and add query parameters, filters, limits, and ordering. We do this by initializing a variable and calling the GlideRecord API. GlideRecord - Global. addQuery(String name, Object operator, Object value) Adds a filter to return records where the field meets the specified condition (field, operator, value). addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. addQuery(String name, String operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table, that match the request. GlideRecord. A GlideRecord contains both records and fields. Operators available for condition builders. If you are familiar with SQL, this method is similar to the "where" clause. addQuery(String name, String operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table, that match the request. Scoped GlideRecord is used for database operations. This functionality can be helpful when creating customized reports or in. GlideRecord. Always test queries on a sub-production instance prior to deploying them on a. This also has the side-effect of giving us the “number” of incidents with that given problem_id. If you are familiar with SQL, this method is similar to the "where" clause. Scoped GlideRecord is used for database operations. Always test queries on a sub-production instance prior to deploying them on a. If you are familiar with SQL, this method is similar to the "where" clause. addQuery(String name, String operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table, that match the request. If you are familiar with SQL, this method is similar to the "where" clause. query(); while ( gr. addQuery(String name, String operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table, that match the request. addQuery(String name, Object operator, Object value) Adds a filter to return records where the field meets the specified condition (field, operator, value). GlideRecord - Global. Always test queries on a sub-production instance prior to deploying them on a. Scoped GlideRecord is used for database operations. Always test queries on a sub-production instance prior to deploying them on a. Scoped GlideRecord is used for database operations. addQuery(String name, String operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table, that match the request. You can create one or more queries for a single filter by calling this method multiple times. This cheat sheet was build with elements gathered from presentations and blog posts and also from reading the script include. GlideRecord Scripting. This just showcases the benefit and ease of using the encoded query as a shortcut. A GlideRecord is an object that contains records from a single table. article for details on building and running queries. For information about GlideRecordSecure, which is a class inherited from GlideRecord that performs the same functions as GlideRecord, and also enforces ACLs, see the . What is GlideQuery. GlideRecord. The GlideRecord class is the way to interact with the ServiceNow database from a script. The GlideRecord API is the primary means of interfacing with the database on the server-side code. ServiceNow provides several search operators for performing full text searches with GlideRecord using ServiceNow’s Zing search engine. addQuery(String name, String operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table, that match the request. GlideRecord - Global. If you are familiar with SQL, this method is similar to the "where" clause. Operator label. GlideRecord. A GlideRecord is an object that contains records from a single table. However the stock widgets in Service Portal are hardcoded to use “123TEXTQUERY321” which works great for single word searches but not so much for searches containing multiple words or phrases. THE "NEW" COMMAND. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. Scoped GlideRecord is used for database operations. Equivalent query operator. GlideRecord. addQuery(String name, String operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table, that match the request. Always test queries on a sub-production instance prior to deploying them on a. If you are familiar with SQL, this method is similar to the "where" clause. next ()) { // add code here to process the incident record } This script issues the query () to the database. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. A GlideRecord is an object that contains recordsGlideRecord - Global. If you are familiar with SQL, this method is similar to the "where" clause. GlideRecordOr. addQuery(String name, String operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table, that match the request. A GlideRecord contains both records and fields. If you are familiar with SQL, this method is similar to the "where" clause. If you are familiar with SQL, this method is similar to the "where" clause. query ();ServiceNow provides JavaScript APIs for use within scripts running on the ServiceNow platform to deliver common functionality. You can create one or more queries for a single filter by calling this method multiple times. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. For information about GlideRecordSecure, which is a class inherited from GlideRecord that performs the same functions as GlideRecord, and also enforces ACLs, see the . Use the API to instantiate a GlideRecord object and add query parameters, filters, limits, and ordering. Parameters: Name: Type: Description:. Scoped GlideRecord is used for database operations. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. The GlideRecord class is the way to interact with the ServiceNow database from a script. next() populates your GlideRecord variable with the values from the first returned record. For information about GlideRecordSecure, which is a class inherited from GlideRecord that performs the same functions as GlideRecord, and also enforces ACLs, see the . addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. Often, people in the Community Forums will suggest querying the table, iterating through every single record, running . Then it runs the query using the query () method and loops through the result set using the next () method. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. A GlideRecord contains both records and fields. If you are familiar with SQL, this method is similar to the "where" clause. If you are familiar with SQL, this method is similar to the "where" clause. GlideRecord. Always test queries on a sub-production instance prior to deploying them on a. addQuery(String name, String operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table, that match the request. addQuery(String name, Object operator, Object value) Adds a filter to return records where the field meets the specified condition (field, operator, value). If you are familiar with SQL, this method is similar to the "where" clause. GlideRecord. If you are familiar with SQL, this method is similar to the "where" clause. Dot walking 101 . The GlideRecord API is the primary means of interfacing with the database on the server-side code. If you are familiar with SQL, this method is similar to the "where" clause. GlideRecord - Global. See the GlideRecord API reference for a complete list of methods. SQL and GlideRecord address this ambiguity by using operator precedence. Always test queries on a sub-production instance prior to deploying them on a. GlideRecord/JavaScript Operators Update : Since ServiceNow removed the ability to do synchronous GlideRecord or GlideAjax calls from certain contexts such as the Service Portal, you. A GlideRecord contains both records and fields. For information about GlideRecordSecure, which is a class inherited from GlideRecord that performs the same functions as GlideRecord, and also enforces ACLs, see the . For information about GlideRecordSecure, which is a class inherited from GlideRecord that performs the same functions as GlideRecord, and also enforces ACLs, see the . GlideRecord. GlideRecord - Global. For information about GlideRecordSecure, which is a class inherited from GlideRecord that performs the same functions as GlideRecord, and also enforces ACLs, see the . GlideRecord. Known synonyms are applied. A GlideRecord contains both records and fields. If you are familiar with SQL, this method is similar to the "where" clause. GlideRecord - Global. If you are familiar with SQL, this method is similar to the "where" clause. addQuery(String name, String operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table, that match the request. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that. If you are familiar with SQL, this method is similar to the "where" clause. GlideRecord. GlideRecord - Global. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. For information about GlideRecordSecure, which is a class inherited from GlideRecord that performs the same functions as GlideRecord, and also enforces ACLs, see the . For information about GlideRecordSecure, which is a class inherited from GlideRecord that performs the same functions as GlideRecord, and also enforces ACLs, see the GlideServer APIs. Here is what the generalized strategy looks like in pseudo-code: // 1. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. If you are familiar with SQL, this method is similar to the "where" clause. Scoped GlideRecord is used for database operations. If you are familiar with SQL, this method is similar to the "where" clause. For information about GlideRecordSecure, which is a class inherited from GlideRecord that performs the same functions as GlideRecord, and also enforces ACLs, see the . addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. The GlideRecord API is the primary means of interfacing with the database on the server-side code. Always test queries on a sub-production instance prior to deploying them on a. The system provides a set of operators for use with filters, condition builders, and encoded queries. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. If you are familiar with SQL, this method is similar to the "where" clause. Always test queries on a sub-production instance prior to deploying them on a. GlideRecord Example (Run time: 00:01:05. A GlideRecord contains both records and fields. For information about GlideRecordSecure, which is a class inherited from GlideRecord that performs the same functions as GlideRecord, and also enforces ACLs, see the . If you are familiar with SQL, this method is similar to the "where" clause. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. GlideRecord - Global. Brittany is currently working on App Engine Studio. The GlideRecord API is the primary means of interfacing with the database on the server-side code. Scoped GlideRecord is used for database operations. GlideRecord. If you are familiar with SQL, this method is similar to the "where" clause. hasAttachment() on every single one, and adding those records to a list if that returns true. GlideRecord. GlideRecord. Scoped GlideRecord is used for database operations. The most relevant topics (based on weighting and matching to search terms) are listed first in search results. priority = 3. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. While it is easy to add multiple addQuery methods to our GlideRecord object, we need to add the OR condition in one of the existing addQuery method's object, as shown here: var gr = new GlideRecord ('incident'); var qc = gr. For information about GlideRecordSecure, which is a class inherited from GlideRecord that performs the same functions as GlideRecord, and also enforces ACLs, see the . NOTE: The GlideRecord API discussed here is a server-side API. GlideRecord - Global. In SQL, AND has precedence over OR, and so the parenthesis would wrap around the AND expression (the first example). GlideQuery Cheat Sheet. A GlideRecord contains both records and fields. GlideAggregate gets its result from built-in database functionality, which is much quicker and doesn't suffer from the scalability issues that GlideRecord does. A GlideRecord contains both records and fields. Always test queries on a sub-production instance prior to deploying them on a. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. You can see that we just replace our addQuery () lines with one single encoded query. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. This reference lists available classes and methods along with parameters, descriptions, and examples to make extending the ServiceNow platform easier. Step 1: Create a GlideRecord Object for the Table of Interest Step 2: Build the Query Condition(s) addQuery() Operators. GlideRecord - Client. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. addJoinQuery(String table, String primaryField, String joinTableField) Adds a filter to return records based on a relationship in a related table. If you are familiar with SQL, this method is similar to the "where" clause. GlideRecord provides access to fields via "Dot-walking", so when you query an incident you can access any field like this: gr. addQuery(String name, String operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table, that match the request. Client-side GlideRecord enables the use of some GlideRecord functionality in client-side scripts, such as client scripts and UI policy scripts. You can create one or more queries for a single filter by calling this method multiple times. GlideRecord is a ServiceNow API, and object type. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. There is a client-side GlideRecord API for global applications. GlideRecord - Global. If you are familiar with SQL, this method is similar to the "where" clause. The GlideRecord API is used for database operations. GlideRecord. Always test queries on a sub-production instance prior to deploying them on a. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. GlideRecord - Global. There is a known long-standing issue with GlideRecord where a retrieved variable cannot be accessed correctly directly. If you are familiar with SQL, this method is similar to the "where" clause. If you are familiar with SQL, this method is similar to the "where" clause. addQuery(String name, String operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table, that match the request. ChooseWindow will return all records between the first parameter (inclusive) and the second parameter (exclusive), so this example will return the 10 incidents between record 10-19 both inclusive. If you are familiar with SQL, this method is similar to the "where" clause. A GlideRecord contains both records and fields. ; Build the query condition(s). an attempt to document GlideQuery functions and methods. After declaring your GlideRecord variable and adding any filter conditions, call the . How search works: Punctuation and capital letters are ignored. If you are familiar with SQL, this method is similar to the "where" clause. To process all records from the incident table, add the following script: target. A GlideRecord contains both records and fields. A GlideRecord contains both records and fields. Tutorial on using encoded queries to simplify complex GlideRecord queries. Build the Query Condition(s) Use the addQuery() method to add query conditions. For information about GlideRecordSecure, which is a class inherited from GlideRecord that performs the same functions as GlideRecord, and also enforces ACLs, see the . GlideRecord. For information about GlideRecordSecure, which is a class inherited from GlideRecord that performs the same functions as GlideRecord, and also enforces ACLs, see the . You can create one or more queries for a single filter by calling this method multiple times. If you are familiar with SQL, this method is similar to the "where" clause. Raw. If you are familiar with SQL, this method is similar to the "where" clause. Always test queries on a sub-production instance prior to deploying them on a. For information about GlideRecordSecure, which is a class inherited from GlideRecord that performs the same functions as GlideRecord, and also enforces ACLs, see the . . Use the API to instantiate a GlideRecord object and add query parameters, filters, limits, and ordering. Scoped GlideRecord is used for database operations. Scoped GlideRecord is used for database operations. However, we do not care about that in this scenario. Retrieves only records of a specified class for tables which are extended. If you are familiar with SQL, this method is similar to the "where" clause. addQuery(String name, String operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table, that match the request. GlideRecord - Global. addJoinQuery(String table, String primaryField, String joinTableField) Adds a filter to return records based on a relationship in a related table. Create an object to store rows from a tablevar myObj = new GlideRecord('table_name');// 2. next()) { gs. A GlideRecord contains both records and fields. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. If you are familiar with SQL, this method is similar to the "where" clause. Known synonyms are applied. Use the API to instantiate a GlideRecord object and add query parameters, filters, limits, and ordering. See the GlideRecord API reference for a complete list of methods. Execute the query. Scoped GlideRecord is used for database operations. GlideRecord. GlideRecord. Please note: The APIs below are intended for scoped applications and. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. GlideRecord. The GlideRecord API is the primary means of interfacing with the database on the server-side code. These operators determine how the database query is formed on the server. GlideRecord. ) or deconstruct using the 3-argument gr. Special characters like underscores (_) are removed. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. You can create one or more queries for a single filter by calling this method multiple times. GlideRecord - Global. Parameters: Name: Type: Description:. Always test queries on a sub-production instance prior to deploying them on a. Please note: The APIs below are intended for scoped applications and. addEncodedQuery(. If you are familiar with SQL, this method is similar to the "where" clause. Scoped GlideRecord is used for database operations. GlideRecord. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. GlideRecord - Global. You can create one or more queries for a single filter by calling this method multiple times. Client scripts are scripts that run inside the user's browser (the 'client') when a page is loaded, when a form is modified, or when the form is submitted. GlideRecord. GlideRecordV3 - Client. Scoped GlideRecord is used for database operations. GlideRecord. If you are familiar with SQL, this method is similar to the "where" clause. var lscUser = new GlideRecord ('x_wadm_lsc_user');. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. We are experimenting with new training content delivery methods. ; Build the query condition(s). Operators available for filters and queries. If you are familiar with SQL, this method is similar to the "where" clause. The GlideRecord API is the primary means of interfacing with the database on the server-side code. GlideRecord. GlideRecord - Global. It returns a Boolean indicating whether a record was found, so you can use it as a condition of a while loop to iterate. chooseWindow ( 10, 20 ); gr. If you are familiar with SQL, this method is similar to the "where" clause. addQuery('category', 'Hardware'); Is the same as. gliderecord, cheat sheet. GlideRecord - Global. addQuery(String name, Object operator, Object value) Adds a filter to return records where the field meets the specified condition (field, operator, value). GlideRecord. The Script: var inc = new GlideRecord (“incident”); inc. For information about GlideRecordSecure, which is a class inherited from GlideRecord that performs the same functions as GlideRecord, and also enforces ACLs, see the . Always test queries on a sub-production instance prior to deploying them on a. If you are familiar with SQL, this method is similar to the "where" clause. Each call to next () would load the next record for processing. This method allows you to specify a field, an operator, and a value to filter the records by. addQuery(String name, String operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table, that match the request. For information about GlideRecordSecure, which is a class inherited from GlideRecord that performs the same functions as GlideRecord, and also enforces ACLs, see the . If you are familiar with SQL, this method is similar to the "where" clause. If you are familiar with SQL, this method is similar to the "where" clause. For information about GlideRecordSecure, which is a class inherited from GlideRecord that performs the same functions as GlideRecord, and also enforces ACLs, see the . A GlideRecord is an object that contains records from a single table. If you are familiar with SQL, this method is similar to the "where" clause. addJoinQuery(String table, String primaryField, String joinTableField) Adds a filter to return records based on a relationship in a related table. Alter and reuse these scripts found in this post for your ServiceNow implementation. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that. If you are familiar with SQL, this method is similar to the "where" clause. See the GlideRecord API reference for a complete list of methods. Always test queries on a sub-production instance prior to deploying them on a. Always test queries on a sub-production instance prior to deploying them on a. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. Scoped GlideRecord is used for database operations. If you are familiar with SQL, this method is similar to the "where" clause. A GlideRecord contains both records and fields. If you are familiar with SQL,. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. This is a draft Cheat Sheet for the GlideQuery. article for details on building and running queries. The GlideRecord API is the primary means of interfacing with the database on the server-side code. If you are familiar with SQL, this method is similar to the "where" clause. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. addQuery(String name, String operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table, that match the request. A GlideRecord is an object that contains records from a single table. GlideRecord - Client. In the past, Brittany. Table 1. Client-side GlideRecord enables the use of some GlideRecord functionality in client-side scripts, such as client scripts. 6 minute read. Always test queries on a sub-production instance prior to deploying them on a. GlideRecord - Global. Scoped GlideRecord is used for database operations. GlideRecord. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that. Scoped GlideRecord is used for database operations. GlideRecord. If you are familiar with SQL, this method is similar to the "where" clause. Scoped GlideRecord is used for database operations. Scoped GlideRecord is used for database operations. A GlideRecord contains both records and fields. Works with orderBy. addQuery(String name, Object operator, Object value) Provides the ability to build a request, which when executed, returns the rows from the specified table that match the request. For information about GlideRecordSecure, which is a class inherited from GlideRecord that performs the same functions as GlideRecord, and also enforces ACLs, see the . GlideRecord. Skip to page content.