Hi All,I am running following query in backgroud script to validate if Encoded query takes date field. I formed this query using list filter -> copy query but its not working. Any suggestion how between operator to enter in encoded query string.My ...
How to make a field to open a file in local folder location. Need to be a field which containing a URL to open the file. Please help!!!!
Getting something similar to the following for scripts run through the "Scripts - Background" module:Time: 0:00:00.002 id: <instance name redacted>[glide.10] for: SELECT task0.`sys_id` FROM task task0 WHERE task0.`sys_class_name` = 'sc_req_item'....I...
Hi Team,can i add any custom field to existing table? can you point to documentation if it is available.After adding custom field, can i retrieve and update the field like existing fields.I am using Developer instance.Thanks in Advance,Aditya.
Hi,I have two Catalog Item sharing a single Workflow. I have added a hidden field in one of the Catalog Items based on which i am performing some calculations in the Workflow. The problem is that when i create a Requested Item from the Catalog Item t...
Hi All,I created a Pivot table in Reports . I need to add Color code like Red,Yellow and Green. in Report blocks.
Does anyone know where ServiceNow stores the values to be used in this table/field? Surely there's a table that we can call/query without having to write an AGGREGATE distinct query over the task table, esp. with hundreds of thousands of records.
I need to implement an UI button, Save and Stay that saves the ticket, but keeps it open, basically have the exact same functionality as right clicking on the menu bar and selecting save from the context menu. How would I do that? Suggestions?
Hi all -We have a List field on a form and the user needs to be able to select one or more for the slushbucket. On the backend I need the value of the selection to send in a SOAP message. However, I have a requirement for the name to be displayed...E...
I need to have a link that is clickable when you view the field in the table's list view.I originally attempted to create a URL field and did find that the link was clickable when you're viewing the column in list view. However, the field shows the e...
I have a currency field on a form called u_suspected_loss_local. The currency is stored in the local currency the user selects when completing the form. This is how it is shown on the form:However, when the confirmation email notification is sent, th...
I am currently using a UI Page to hold a form in which values are passed. The UI Page that I am using is public as it is like a support system so people do not have to login. When using new GlideRecord in the client script it seems like it is not all...
Scenario is if there is Eid holiday tomorrow we got to know this by today evening then how will we ensure that sla should not breach for any incident
I want to know how to use GlideScheduleThe problem here is timezone (how to specify or load for a specific schedule)var schedule = new GlideSchedule('090eecae0a0a0b260077e1dfa71da828', 'US/Pacific');and var startDate = new GlideDateTime('2014-10-25 0...
Hello, My use case is that I'm trying to create a view to build a pivote report that will show how many incidents and problem tasks are related to a given problem. However, when I try to only pull in incident records that have problem_id populate...
