Is it possible to create a Database View that implements a table self join? For example I would like to find all sys_user records where there are duplicate email addresses(the incoming email to user matching process obviously has a problem with dupli...
We have a need to parse XML data in some of our javascripts.I have seen a few references in the wiki to glide helpers such as GlideXMLUtil and GlideXMLDocument in various code samples.Is there any documentation that provides descriptions of the avail...
Hi,I want to retrieve the ServiceNow release(aspen/berlin/calgary/dublin) or buildtag of my instance and use it in server side script.I have checked some system properties which have release details but the properties vary from instance to instance.P...
I watched the Gamification of IT webinar the other day (if you didn't, be sure to watch the recording!) and I want to build my own version.What really caught my eye was that they had a Condition Builder on a custom table. I had no idea such a thing w...
We need to be able to pull in data which shows every single Assignment Group that has worked on an IncidentTo do this we were directed to Reports section of Service Now and told to work with the 'Incident_Metric' view.I was able to successfully setup...
When personalizing the sc_req_item form, there is a form object labeled 'Delivery Plan Schedule'. When adding this to the form (by default it is added to the Self Service form), it display a summary of the Tasks associated with the Item.I want to be ...
Hi,I am modifying a list control and within my Omit New Script, I want the list of the new roles that are currently set for the list control.I want to avoid making a trip to the server to query the table just to get the value of the field when I am a...
We are trying to filter the group dropdown list in the on-call rotation calendar module so that the current logged on user only sees groups where they are the manager or a member. Currently, we have hundreds of groups wanting to use the on-call rotat...
HiI need the sys_ids from table 'service_offering' that have no entry in the related table 'service_subscribe_company' (m2m relation).I tried the following: // Seek active services without subscribtion var ysys = ''; var gr1 = new GlideRecord('servic...
Hi,We are looking for some date comparison validations in Client Scripts.We are facing an issue where we need to obtain current date/time value for user. The issue is that:1. We do not want to use Ajax calls in client scripts2. If we obtain date/time...
I'm attempting to query the category->catalog items join table to get a set of request items that i can then pass to a list and display on a page. All I need is the request items. I'm trying to query the sc_cat_item_category table to get my list and ...
Hi,We have a url type of field in incident table, On form view that field value appears properly,but in List view the complete url is not coming in column hence user is not able to redirect to desired page.Is there anyway that somehow complete url va...
Hi Experts,Can you please tell me how to update my jQuery library in UI Script. I copied and pasted the jquery script from the link ("http://code.jquery.com/jquery-1.10.1.min.js") into my UI Scripts. I have called the jquery by
Hi All,I'm facing "This request requires HTTP authentication ()" these error while calling the SOAP Message.Given these properties are checked.1. Require authorization for incoming RSS requests.2. Require authorization for incoming SOAP requests3. Re...
Mid Server JDBC Connection Caching - Can it be turned off?Is it possible to turn off Mid Server Connection Caching? I have a situation where I run a scheduled data import daily via JDBC and in my networking environment if traffic is not seen on the f...
