If the list layout of a table such as incident is configured adding a dot-walked field that references another table using a Function Definition field as its display value, when trying to open the listWe would like to show you a description here but the site won’t allow us. I hope this shines. ###Follow these steps to view the columns in a table: In the main ServiceNow Browser window, use the All menu to open System Definition > Tables. The exclusive source for Now Certified enterprise workflow apps from partners that complement and extend ServiceNowfuture ServiceNow best practice content, please contact us. This example shows how you can add ‘or’ conditions to your query. You can also learn from other related webpages that show how to use client script, GlideQueryCondition, condition. After expiry date, file and depending report will not be available. Related resources •CMDB and Discovery deployment •Populate and maintain your CMDB with Discovery •Success Checklist –Plan your architecture, instances, integrations, and data flows •Success Checklist –Discover and map your service assetsURLSearchParams. ServiceNow provides JavaScript APIs for use within scripts running on the ServiceNow platform to deliver common functionality. Business Rules are server-side logic that execute when database records are queried, updated, inserted, or deleted. Customer wantedDocumentation Find detailed information about ServiceNow products, apps, features, and releases. The end result is a nice, dynamic filter option for filtering where the user listed in a user field is a member of one of your groups! This is just one example of a fantastic capability in ServiceNow. Documentation Find detailed information about ServiceNow products, apps, features, and releases. It is often signals a mistake if somewhat. Create and automate order tasks with workflows to reduce fulfillment time, meet SLAs, and lower costs. The client-side GlideRecord API enables the use of some GlideRecord functionality in client-side scripts, such as client scripts and UI policy scripts. g "Assignment group" field) on each module tables like Incident, Change etc. The GlideQuery API is an alternative to GlideRecord to perform CRUD operations on record data from server-side scripts. myObj. This reference lists available classes and methods along with parameters, descriptions, and examples to make extending the ServiceNow platform easier. Step 2: Pick one of the apps as a trigger, which will kick off your automation. Impact Accelerate ROI and amplify your expertise. While GlideAggregate is probably a more performant operation, using . Extending an existing ServiceNow table means the new table inherits the parent table's columns as well as its business logic. Learning Build skills with instructor-led and online training. These methods have a wide variety of uses and are found at the heart of many of the business rules, UI actions, and scheduled job GlideAggregate - addEncodedQuery (String query) - Product Documentation: Utah - Now Support Portal. Actual behavior: When running script using 'CONTAINS' of addOrCondition with search_key via REST API , then it shows '=', not 'CONTAINS'. For example if you query for 5 columns, you can get back max 100,000 rows. Please note: These APIs are provided to support legacy applications in. Next, right-click on the breadcrumbs and select “Copy query”. The addQuery function will do a simple equals comparison when no comparator is provided. This article demonstrates how to configure Group Members (sys_user_grmember) edit capability, so that only the Group Manager is able to edit (as in add/remove) members from the group. Return to the REST API Explorer and paste the encoded query into the query parameter. The server-side API also has a GlideUser class but the server-side GlideUser class does not use the g_user object. However, the AddQuery() methodSimplify Queries with Encoded Queries. This tutorial blog post is one of those experiments. has () Returns a boolean value indicating if a given parameter, or parameter and value pair, exists. 1 Answer. When you issue complex SQL queries from. ServiceNow is one of the common cloud-based workflow automation platforms widely used by AWS customers. ServiceNow provides JavaScript APIs for use within scripts running on the ServiceNow platform to deliver common functionality. This reference lists available classes and methods along with parameters, descriptions, and examples to make extending the ServiceNow platform easier. Here’s a common question: “How do I use a scripted GlideRecord query to get all records in a given table that have attachments?” Often, people in the Community Forums will suggest querying the table, iterating through every single record, running . It is recommended that new. For Flow Designer, setting up credentials is a bit different. Open the list filter and select the conditions for the current (Problem) table. There are two options available, documented here. This reference lists available classes and methods along with parameters, descriptions, and examples to make extending the ServiceNow platform easier. The minuscule time savings. Both addNullQuery () and addNotNullQuery () accept a single argument; a string, indicating which field should be checked. ServiceNow provides JavaScript APIs for use within scripts running on the ServiceNow platform to deliver common functionality. Community Ask questions, give advice, and connect with fellow ServiceNow professionals. This reference lists available classes and methods along with parameters, descriptions, and examples to make extending the ServiceNow platform easier. Skip to page content. Once we have defined the object of a table using the GlideRecord class, we can query to retrieve the records from the table: gr. Replace PASTE_USER_SYS_ID_HERE with the Sys ID for your patent attorney record. Business Rules are server-side logic that execute when database records are queried, updated, inserted, or deleted. Dotwalking is presumed in the Now platform and should be reasonably familiar to most GlideRecord developers. Partner Grow your business with promotions, news, and marketing tools. build(); // Returns. It doesn’t make sense to say “orWhere” if we didn’t already state a prior where clause. ServiceNow actually recommends that you use GlideAggregate wherever you can, over getRowCount(). Phase 2: Developing your application Add components and content to your application. O ne of the basic (but often forgotten) guidelines that should be followed whenever you consider importing any data into your ServiceNow instance is to only import the information that is actually. As I understand, ServiceNow also has the power to use iFrames within its Knowledge Base pages. Alternative to GlideRecord and Glidequery - Support and Troubleshooting - Now Support Portal. Click View / Run and choose to Create a Report option. On the Action, you’ll see a scripting icon next to any field that allows scripting. Description. ServiceNow provides JavaScript APIs for use within scripts running on the ServiceNow platform to deliver common functionality. Click RELATED LISTS CONDITIONS to expand the section. How search works: Punctuation and capital letters are ignored. Learning Build skills with instructor-led and online training. Lists have a condition builder to create more complex query. Impact Accelerate ROI and amplify your expertise. Used to search the database for matching records. This reference lists available classes and methods along with parameters, descriptions, and examples to make extending the ServiceNow platform easier. Related list conditions allow you to include a relationship with another table in the filter. The Now Support portal is your launchpad to access self-help, get technical support, and manage your ServiceNow instances. Documentation Find detailed information about ServiceNow products, apps, features, and releases. The GlideRecord API is the primary means of interfacing with the database on the server-side code. Orchestration for Employee OnboardingThe ServiceNow ODBC Driver is a powerful tool that allows you to connect with live ServiceNow data, directly from any applications that support ODBC connectivity. company). Service Portal widgets can use snRecordPicker and snReferencePicker directives in order to render a dropdown box with autocomplete functionality. "Before query Business Rule" on a "task" record suppose to filter the data based on the AddQuery() method and parameters supplied in "script" section of the business rule. This reference lists available classes and methods along with parameters, descriptions, and examples to make extending the ServiceNow platform easier. With built-in, optimized data processing, the CData Python Connector offers unmatched performance for interacting with live ServiceNow data in Python. Create your transformation story. getUser (); gs. It is a common use case to report on request items and the related variable values. getUserName () Returns the User ID (user_name) for the currently. Learning Build skills with instructor-led and online training. If you. The MID Server initiates all communications with the ServiceNow® instance. Reference qualifier on reference field (e. The first parameter will sort in Ascending order whilst the latter in Descending order. Your only option is to retrieve all records from one table first, the other table separately and then implement the join logic client side. ServiceNow provides JavaScript APIs for use within scripts running on the ServiceNow platform to deliver common functionality. Dotwalking Just like GlideRecord, GlideQuery. ServiceNow provides a number of methods (SOAP, REST API), JDBC, LDAP, Data Export, Email, CTI through which it can be integrated with other tools like Event Monitoring Tools – Netcool, Jira, Slack. When creating a database view it is sometimes necessary to join tables via a Document ID type field. Usage. AI Search in action. incorporated in California, June 28, 2004. It dramatically simplifies filtering and reading in fields referenced by the current table instead of executing another GlideQuery. Please note: The APIs below are intended for scoped applications and may behave differently in the global scope. Possibly something like making an SQL call from powershell. All rights reserved. 2. In the Search fields related list, click New. Learning Build skills with instructor-led and online training. Please let us know what you think about this format and the content in. Please note: The APIs below are intended for scoped applications and. Impact Accelerate ROI and amplify your expertise. The GlideRecord API is used for database operations. Whether you take virtual or in-person courses from ServiceNow, or from one of our Certified Training Partners, you will learn to be successful with the Now Platform. They are ordered from left to right. Dotwalking and Flags Similar to GlideRecord, GlideQuery supports dotwalking, both when using select and where. Different from the official ServiceNow documentation sources, everything here comes from ServiceNow admins, developers, and consultants like you! Every solution has been used and proven in an actual production ServiceNow. Members of the ServiceNow Developer Program can use their PDI as long as there is. RLQUERY is what Related List Conditions in reports use. This example shows how you can add ‘or’ conditions to your query. Partner Grow your business with promotions, news, and marketing tools. This means that the client script can retrieve data from the server without having to make a round-trip request to the server, which can be slower and use more network resources. I'm trying to create a widget in ServiceNow that displays all the knowledge articles that is relevant to a user based on their location and occupation. Glidesoft, Inc. Please note: The APIs below are intended for scoped applications and may behave differently in the global scope. query += " "; query += "}"; alert ( query); Now that you’ve got this, from any List you can right-click on the header and the bottom option will be “Get GlideRecord Query” and you can copy the resulting code. This reference lists available classes and methods along with parameters, descriptions, and examples to make extending the ServiceNow platform easier. ServiceNow provides a large number of baseline widgets. The CMDB Query Builder allows you to easily build complex infrastructure and service queries that span multiple CMDB classes, and that involves many CIs that are connected by different relationships. addQuery () Operators. It requires using “Connection and Credential Aliases” in the IntegrationHub application. Conditions are evaluated before the rule is executed, if the condition is met, the script is evaluated and executed. Having reviewed availableSkip to page content. . If you are not sure whether a class is part of the client-side or server-side API, check the API Reference. With built-in, optimized data processing, the CData Python Connector offers unmatched performance for interacting with live ServiceNow data in Python. Loading. Special characters like underscores (_) are removed. query() C and D are correct. Must be in quotes. Viewed 1k times 1 I m trying to implement a script that queries a table and checks for certain criteria. : Order the dashboard. It’s nothing complicated, but can still save a bit of time. Loading. ServiceNow provides JavaScript APIs for use within scripts running on the ServiceNow platform to deliver common functionality. It is often signals a mistake if somewhat. Use the Chrome REST Plugin to put in REST details - GET (That pulls data. On the other hand, when the addNotNullQuery () method is. Navigate to your environment "latest", select the ellipsis button and then select Approvals and checks. To explicitly AND or OR a condition in a query, use the methods from the. Partner Grow your business with promotions, news, and marketing tools ServiceNow Learn about ServiceNow products & solutions. Instead, create a script include and use the API, or use the REST APIs. It is recommended that new. gs. GraphQL is an open-source data query and manipulation language for APIs. Basic GlideRecord queryCommunity Ask questions, give advice, and connect with fellow ServiceNow professionals. Customer service management is the orchestration of tasks between customers, customer service, and other teams to quickly resolve issues and requests. Partner Grow your business with promotions, news, and marketing tools. This plugin is activated by default starting with Madrid instances. The most relevant topics (based on weighting and matching to search terms) are listed first in search results. Search for ServiceNow and select the. We would like to show you a description here but the site won’t allow us. You basically need to enter two parameters to your request, which are user and group. snow_record creates, updates or deletes a record in a specified table in the Service Now instance. New Developer Program members automatically receive a PDI running the latest release. We would like to show you a description here but the site won’t allow us. ServiceNow provides JavaScript APIs for use within scripts running on the ServiceNow platform to deliver common functionality. Skip to page content. Documentation Find detailed information about ServiceNow products, apps, features, and releases. Community Ask questions, give advice, and connect with fellow ServiceNow professionals. This article covers working with choices in ServiceNOW. Tutorial on using encoded queries to simplify complex GlideRecord queries. addQuery('priority', 1); grOR. It dramatically simplifies filtering and reading in fields referenced by the current table instead of executing another GlideQuery. 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. Legacy Capabilities. ServiceNow provides JavaScript APIs for use within scripts running on the ServiceNow platform to deliver common functionality. If any of the query statements need to be OR'ed, use the GlideQueryConditionmethod addOrCondition(). This way, if the user enters anything. Actual behavior: When running script using 'CONTAINS' of addOrCondition with search_key via REST API , then it shows '=', not 'CONTAINS'. ServiceNow ® capabilities through hands-on, real-world instruction to helps you meet your goals. The tenant setting Dataset Execute Queries REST API, found under Integration settings, must be enabled. Here is an example of using the addQuery() method in a GlideRecord query: var gr = new. Here is an example of using the addQuery() method in a GlideRecord query: var gr = new GlideRecord('incident'); gr. IntegrationHub. ‘Ask For Approval’ or ‘Update Record'). Add an "OR" Condition to a GlideRecord Query in ServiceNow Raw GlideRecordOr. The generalized strategy is: Create a GlideRecord object for the table of interest. Developer Build, test, and deploy applications. Widgets. If there is no condition, the system. One table request per query. Select the privacy level from the menu on the Data Source Settings page. We would like to show you a description here but the site won’t allow us. How do I put an OR condition in this script? - ServiceNow CommunityIf you are looking for a way to write a script that can handle multiple conditions with OR logic in ServiceNow, you can find helpful tips and solutions in this developer forum post. Developer Build, test, and deploy applications. This reference lists available classes and methods along with parameters, descriptions, and examples to make extending the ServiceNow platform easier. Please note: The APIs below are intended for scoped applications and. Once we have defined the object of a table using the GlideRecord class, we can query to retrieve the records from the table: gr. This reference lists available classes and methods along with parameters, descriptions, and examples to make extending the ServiceNow platform easier. addEncodedQuery() C. This reference lists available classes and methods along with parameters, descriptions, and examples to make extending the ServiceNow platform easier. This reference lists available classes and methods along with parameters, descriptions, and examples to make extending the ServiceNow platform easier. DataColumn where Table1. Log in to manage upgrades, follow changes, view knowledge content, and more. //Find all incidents. Not all queries are easy to write, though, especially if you need to work with date fields or OR operators. Impact Accelerate ROI and amplify your expertise. The GlideQuery API lets you: Use standard JavaScript objects and types for queries. A default set of query parameters are displayed for the API. Select External Import as Source type. ServiceNow improves service levels, energizes employees, and enables your enterprise to work at lightspeed. e. So it recognises any user and group changes made to any of the applicable. We would like to show you a description here but the site won’t allow us. Type sc_req_item. Create a linked service to ServiceNow using UI. - Selection from. Please note: These APIs are provided to support legacy applications in the global scope. getParameterValue ('paramName') RP. Edit: spelling. To create a dashboard, use the Self-Service > Dashboards button. API is not supported in scoped applications. This article aims at providing steps to create a report for the above scenario. Building strong functionality in ServiceNow begins with writing high-quality code. In short, it’s a staging table combined with some transformation logic that allows you to import data into your ServiceNow instance. • Created and managed Tablespaces, monitored the data files space, resizing and adding new data files. Please note: These APIs are provided to support legacy applications in the global scope. Extend the Now Platform with additional applications and features. . Description. This happens in two stages: Load the data into a temporary/staging table; Transform the data and push it into the desired target table; Let’s jump right into building one. SNMP discovery Explained - Support and Troubleshooting - Now Support Portal. Documentation Find detailed information about ServiceNow products, apps, features, and releases. Use these tools and templates to help communicate and document your implementation success to your organization. Return to the REST API Explorer and paste the encoded query into the query parameter. Laravel's database query builder provides a convenient, fluent interface to creating and running database queries. To describe a parameter, you specify its name, location (in), data type (defined by either schema or content) and other attributes, such as description. GraphQL offers many benefits over REST API’s, including: Fetching data across multiple sources from a single API call. Like Reference fields, Document ID fields allow the record to reference another record. GlideRecord - insert () - Product Documentation: Tokyo - Now Support Portal. addQuery('active', true); gr. Clicking a breadcrumb removes all the conditions to its right. ServiceNow provides client-side JavaScript APIs allowing all of you to control aspects of how ServiceNow is displayed and functions within the web browser. There is an API built into the DOM which allows you to get query parameters on the client without doing any of your own regex-ing: var x = document. Create a Before business rule that evaluates if one of the record fields is empty or null by using the '. What is RLQUERY? Related List Query is something you can add to an Encoded Query to query a child table within one GlideRecord query. All of the methods below return true or false based on changes to the ‘current’ record. The exclusive source for Now Certified enterprise workflow apps from partners that complement and extend ServiceNow. 4 © 2021 ServiceNow, Inc. GlideQuery - GlideQuery (String table) - Product Documentation: Tokyo - Now Support Portal. addOrQuery() and addAndQuery() are not methods from the GlideRecord API. I'm trying to write a query that includes encoded queries, but am not sure if my syntax is even correct (99. Business Rules | ServiceNow Developers. "Before query Business Rule" on a "task" record suppose to filter the data based on the AddQuery() method and parameters supplied in "script" section of the business rule. Impact Accelerate ROI and amplify your expertise. There are also live events, courses curated by job role, and more. ServiceNow provides JavaScript APIs for use within scripts running on the ServiceNow platform to deliver common functionality. . One features of ServiceNow you may have missed is the ability to utilize Related List Queries (RLQUERY) using GlideRecord. May 2, 2016 at 18:07. a) GlideSystem (gs) b) GlideUser (g_user) c) GlideDateTime d) GlideDate e) GlideForm (g_form), When do onSubmit Client Scripts execute their script logic? More than one response may be. addOrCondition ('category', 'software');. Scheduled imports bring relevant SCCM data into the ServiceNow instance from a SQL Server database and map the data to the appropriate tables in the. Please note: These APIs are provided to support legacy applications in. Documentation Find detailed information about ServiceNow products, apps, features, and releases. Solution Sage. Navigate to the list view for the desired table. Skip to page contentWe would like to show you a description here but the site won’t allow us. : Where to place the dashboard in the dashboard selection list. addOrQuery() D. var gr = new GlideRecord ('incident'); var grOR = gr. The best way to actually retrieve the the sys_id for a record is just to open that record, right-click the header for the record, and select the ‘Copy URL’ menu option. In the Navigator expand the node for the OData feed, right-click a table, and click Edit to open the Query Editor. The ServiceNow solution The ServiceNow®Configuration Management Database is an easy-to-use, cloud-based single system of record for your IT infrastructure and digital service data. addQuery (fieldname, operator, value); //. addQuery. ID= Table2. Execute the query. This reference lists available classes and methods along with parameters, descriptions, and examples to make extending the ServiceNow platform easier. addEncodedQuery() C. The key to making this work is the g_list object that has the. Documentation Find detailed information about ServiceNow products, apps, features, and releases. 2 minutes. . addAndQuery() E. To create a dashboard when viewing a dashboard, click the. method the queries are ANDed. query(); A GlideRecord contains both records and fields. query(); while (gr. Learning Build skills with instructor-led and online training. ServiceNow, the ServiceNow logo, Now, Now Platform, and other ServiceNow marks are trademarks and/or registeredSelect the OData feed from the list and then click Edit Credential. Please note: These APIs are provided to support legacy applications in. Enter a unique name for the input. It can be called with only two parameters, table field and comparison value, such as qc. ServiceNow provides JavaScript APIs for use within scripts running on the ServiceNow platform to deliver common functionality. For each question, determine your response then click anywhere in the question to see the answer. The function accepts a number of different parameters. This article shows how to connect to ServiceNow with the CData Python Connector and use petl and pandas to extract, transform, and load ServiceNow data. Breadcrumbs offer a quick form of filter navigation. Want to verify your understanding of server-side scripting? These questions will help you assess your progress. Please note: The APIs below are intended for scoped applications and. Administrators may want to add criteria to GlideRecordThis is an extremely common pattern to code against when building applications in ServiceNow. If. How to create a text search list view for a particular table Resolution When performing a global search in a ServiceNow instance, the various task lists returned by the query will first attempt to locateThere is query on how we can get the details of the survey along with the task record for which that survey is submitted on a report for survey_response table. Navigate down to the “Export” option and select between your options. Developer Build, test, and deploy applications. Much of the behavior of a ServiceNow instance is controlled by System Properties. The first orWhere in a query must be preceded by a where, whereNull, or whereNotNull. Create record for M365 Apps Health advisory in ServiceNow. The content pack gives you instant access to multiple. However, Confluence Cloud can not be used within iFrames. Please note: These APIs are provided to support legacy applications in the global scope. Impact Accelerate ROI and amplify your expertise. servicenow; or ask your own question. By default the Dependency Views map displays 3 levels. On the form, fill in the fields. Adding an. A GlideRecord contains both records and fields. . Right-click the end of the filter breadcrumb and select the Copy query menu item. You can connect Amazon Kendra to your ServiceNow data source. The ‘DYNAMIC’ keyword indicates the use of a dynamic filter, and what follows is the sys_id of the corresponding dynamic filter record. The standard ‘addQuery’ parameter acts like an ‘and’ condition in your query. On the filter list select "Show related fields". 1. You should first verify your query through the ServiceNow UI before attempting to use it in an API call. A GlideRecord contains both records and fields. Since Business Rules are evaluated whenever an insert, update, delete or query action is made to a record, it is important to ensure you are using conditions. Improper use of any of these security mechanisms can cause you some pretty serious problems so it’s important to know what you’re. This article contains various examples to navigate by url in ServiceNow. Communicate your success (zip) Success Story E-mail. Useful Scripts. The first orWhere in a query must be preceded by a where, whereNull, or whereNotNull. 1. Figure 1. ServiceNow provides JavaScript APIs for use within scripts running on the ServiceNow platform to deliver common functionality. addQuery ('priority. Copy URL menu option. Watch this short video to see how users can find. Enable customers with self-service options like order tracking and creating cases when they need help. How to Connect ServiceNow to Excel using REST Webservices. ServiceNow Products. The ServiceNow® AI Search application provides a modern consumer-grade search engine for ServiceNow® Service Portal, ServiceNow® Now Mobile, and ServiceNow® Virtual Agent. Some query parameters, such as sysparm_group_by, accept a field name or a comma separated list of field names. next()) { // process the incident record } Loading. ServiceNow admins use addQuery() to select records from a table, based off of a field and value match. ITOM describes the individual processes and services that are administered by an IT department—this includes administrative. Documentation Find detailed information about ServiceNow products, apps, features, and releases. getUser () Returns a reference to the user object for the currently logged-in user. addOrQuery() and addAndQuery() are not methods from the GlideRecord API. Please note: The APIs below are intended for scoped applications and may behave differently in the global scope. (function executeRule(current, previous /*null when async*/) { // Create a GlideRecord object var. Now Platform. Documentation Find detailed information about ServiceNow products, apps, features, and releases. Partner Grow your business with promotions, news, and marketing tools. ServiceNow provides JavaScript APIs for use within scripts running on the ServiceNow platform to deliver common functionality. This action can also be taken by right-clicking any record in a list. GlideRecord is used for database operations. • Schema/Logical Objects refreshes & Logical Backup using Datapump utility. 2. ServiceNow provides JavaScript APIs for use within scripts running on the ServiceNow platform to deliver common functionality. This reference lists available classes and methods along with parameters, descriptions, and examples to make extending the ServiceNow platform easier. To select fields from a slushbucket. Documentation Find detailed information about ServiceNow products, apps, features, and releases. The next step is to test it using the REST API Explorer. 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. If the value is not specified in the task, the value of environment variable SN_INSTANCE will be used instead. Loading. In this case, I’m using a Script Include named ‘u. This reference lists available classes and methods along with parameters, descriptions, and examples to make extending the ServiceNow platform easier. ANSWER: Responses 1, 3, and 4 are correct. Using methods in the GlideRecord API, you can return all the records in a table, return records based on specific conditions or keywords, or return records from multiple. Please note: The APIs below are intended for scoped applications and may behave differently in the global scope. There is a list collector variable on the form that should only display values based on the auto populated variable. addQuery() B. The maps can show both upstream and downstream dependencies for the root CI. Developer Build, test, and deploy applications. The most relevant topics (based on weighting and matching to search terms) are listed first in search results. Champion. Glidesoft, Inc. URLSearchParams. When a table is referenced to another table, the default search condition will always be the column label set to true in the dictionary & STARTS WITH. Partner Grow your business with promotions, news, and marketing tools. This is the All Applications tab, which shows all application menus and modules. The relationship between users and groups is stored on sys_user_grmemeber table. It is designed to mimic the familiar GlideRecord interface you know with pythonic support where applicable. Queries made with the client-side are executed on the server. The first piece is the ‘Reference qual’ field value on the dictionary entry of the reference field (Assignment group in this case). If you instantiate a GlideRecord object, and pass it an invalid query string like this: var myGR = new GlideRecord ('incident'); myGr. No where clauses can be used after an orWhere clause. get ('paramName')" Also, while we’re discussing the RP. The GlideQuery API lets you: Use standard JavaScript objects and types for queries. This reference lists available classes and methods along with parameters, descriptions, and examples to make extending the ServiceNow platform easier. GlideSystem, GlideDateTime, and GlideDate are part of the ServiceNow server-side API. This is not easily accomplished using the Service Now Report Builder.