Does anyone know the script to filter on records created 90 days or 3 months ago within the Where Clause of a Table within a Database View? Below is the javascript command I have applied but this does not work. Note 'sa_timestamp' is the field that d...
Hi, I want to call email template in Send email action in flow designer to set the body and subject. @Ankur Bawiskar Any idea here? Thanks in advance, Bala
I am using getDisplayValue() to get the label name of a field.However, it is retrieved in English.How can I get it in Japanese?
Hi, I am creating a demo workflow for service catalog item which creates catalog tasks after approving the request: When I ran validator I received an ValidateTableChange with detail as below: I checked everything and assigned those tasks to the ri...
Background: We are using the script below to add a summary of the requested item in our catalog items to the work notes of the the sc_task. This was previously only used in catalog items with 1:1 relationships for Request -> Requested Item -> Service...
Hi All,i have multiple records in a target table with the same user ID. As per the requirement i want to update all the records in target table using one source record. i am using an excel with data for 5 fields. rest of the column data will remain s...
Hello Everyone, I am not sure which one to use about the following: My team has a Record Producer for customers to submit tickets. I was tasked to add a Region in the form. So, the other fields for example: Sports The Table is INCIDENT, the Column is...
I'm currently building out a notification for when an assessment survey comes back with a subpar result. I've been successful in triggering the notification via an event, but the e-mail that gets sent is blank. My email scripted is named assessmen...
Hi All, I am writing a Business rule (after/update) if any user goes inactive then it script will assign approval records to users manager. (function executeRule(current, previous /*null when async*/) { var gr=new GlideRecord('sysapproval_approver'...
I want to report the information counted by type of tag attached to the incident. I want to join the incident table and the tag table in the database view. I want to know how to join the incident table and the tag table.① I don't know the name of the...
What is the impact of writing a business rule with Application set as Global on a table which is defined in a scoped application? Please cite an example to help understand the reply better. Regards, Anish
I have a sample code snippet using a g:ui_input_field where the field size is set staticly with "size=75". Can this be set dynamically to adjust to the width of the UI page? <tr> <td colspan="2" > <j:set var="jvar_mandatory" value="false"/> ...
We have a script action that is triggered by events. This script action runs against a single table in the CMDB, usually around 10000 in an hour. Some entries in this table can be affected by the script action up to 100 times in a single instance. ...
macro macro Hi All, Using catalog variable 'Macro with label' I have created Glide List as per script: <?xml version="1.0" encoding="utf-8" ?><j:jelly trim="true" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null"> <j:set var="jva...
Hello Community, We have external system and we are looking the way to synch bulk records from external system to service now using import set API. Can anyone help us with high level so that we can implement the logic. Thanks, Nagesh
