Getting the error "Given SQL statement is not allowed to be executed at this time."
Getting the error message when trying to run a query Given SQL statement is not allowed to be executed at this time.
Forum Posts
Resolved! Flow Designer Subflow- How do I get custom variables from JSON Payload?
This is going to be a very noob question but I'm working on my coding skills I'm using the Jira Spoke to integrate Jira with our ServiceNow instance. I have it working mostly except that it is not getting the values of 5 custom fields that are withi...
Resolved! ArrayUtil() contains and indexOf are not working in include script
Hi , In my scripted REST API include script i use ArrayUtil to compare the string which is available in the array, but both indexOf / contains always return false even provided the valid input . Could you please help to fix the issue ? Code : var ...
Resolved! Flow Designer Approvals not Triggering
I am creating my first flow designer and the approvals are not triggering for Service Catalog items. Can you help me figure out what I'm missing? (I have saved/activated prior to testing) Flow Designer Resulting Request Item: It creates the entry ...
Create an appointment booking option using a calendar for a catalog item(service) in Service Catalog.
I am trying to add an option for appointment booking option for a service item in service catalog. I activated plugins : Appointment booking and Field service management. I dont know how i can add the appoitnemnt booking option to the service catego...
Resolved! Copy filter conditions string from Reports
Hi folks,Anyone could help in the report scripting this time. I have created a report via View / Run and made it accessible to my team. To automate a record update process, I need to convert the filter conditions to a query (encoded query ) tha...
Cross-scope issues in HR Management module
Hi, I am trying to write to a scoped application table 'sn_hr_core_case_total_rewards' and I keep getting the error message as follows --> Create operation on table 'sn_hr_core_case_total_rewards' from scope 'Global' was denied. The application 'Glob...
How planned cost for "Resource Plan" is calculating
Hi All,I am working on Project and Portfolio management module. As part of that I am checking how "Planned Cost" and "Allocated Costs" are updating when Resource plan is requested and allocation done for the request. We know what is the logic they ...
Set value for reference field as a choice list
HI, I have a reference field and I have it set up as a choice list (drop down list). I am trying to set the value of this field via client script. I can set the value of the reference field. However, the display value is not selecting. I have used ...
Resolved! Background script to update closed date and time for incidents
We have around 4lach inactive incidents which is not updated closed date and time stamp. Planning to use back ground script to update the resolved date and time stamp to closed option as well. Is there any impact if we update all together in one shot...
Resolved! ServiceNow as OAuth Provider: How to get an ID Token
Hello folks!I'm tring to use serviceNow as an ID Provider for my legacy systems but haven't found a way to generate an ID Token. Use Case: A customer contact (CSM) tries to access a legacy system, gets redirected to ServiceNow login, authorizes the i...
Pass values when calling a GlideDialogForm with a UI Action
Im working on a UI Action that calls up a GlideDialogForm from a Catalog Task. Im using a bit of code I found here:http://www.servicenowguru.com/system-ui/glidedialogwindow-quickforms/function showMyForm(){//Get the table name and sys_id of the recor...
Resolved! How to update the created date ,2 days ago
How to update the created date ,by past 2 days ago from current date on incident . For example if incident0123 created 23-03-2021 - 2 days =incident0123 created 21-03-2021 How to achieve this.
How to resolve the issue Error: Cannot convert null to an object?
hello, I am currently working on the Flow designer actions named Lookup Records. I am trying to get values from a previous step and initializing it on the script step. Where the value from the table is null currentAlertCorpName -> this value is taken...
Resolved! How to set default value via gs.getproperty(), and set the value on field on the form
How to set default value via gs.getProperty(), and set the value on field on the form when field have "null" value. For example , "Email User Name" field on the incident form. I have created sys_property with sys_id ,now client required whenever fiel...
| User | Count |
|---|---|
| 76 | |
| 49 | |
| 30 | |
| 18 | |
| 12 |
