Hi All how can i use Glide Aggregate rather than using .getRowCount() in my code? Thanks. var userGr = new GlideRecord("sys_user"); userGr.addEncodedQuery("active=true^u_country=4538b7111b121100763d91eebc0713f1"); userGr.query(); if(userGr.hasNext(...
Hi All,I have a requirement to create a cleanup job on 'sysapproval_approver' table so that it can clean the records pending for more than a year. I want to set the limit to 100 via system property and want to call that property in the script. I do n...
In the service portal, for the catalog item attachment it should only take the file types of docx and xlsx file types only
Hi All,Could anyone help me to find some sample projects on servicenow admin/developer to work on. I am new to servicenow application and recently completed my certification as system admin.
My Business Unit wants the "More Information" to open when a selection is made on another field and replace the text within the More Information with an alternate text, depending on what is selected. Is that possible to do from a client script?The sc...
I have a catalog item with a date field (currently allowing users to pick a date and displays YYYY-MM-DD) and I need to change the appearance of the field. I need the field to be a YYYY-MM field and users to have the ability to select a month from t...
Hi Guys, I am looking for background script / fix script to remove more than 2k users who are wrongly assigned with a role ( which is not inherited ) under one of the group. I know ,removing user role, by going to each user record and move the role ...
In Order Management: How can I script a query in an 'onChange' Client Script on the 'Product Order' table to retrieve all the associated 'Order Line Items'? Order Line Item table: sn_ind_tmt_orm_order_line_itemProduct Order table: sn_ind_tmt_orm_prod...
Hi all, I created a flow as shown in below image . In create catalog task, I tried to set the field assignment group through scripting to get the group value from decision table but it was returning null for below code:: var UserCompany = fd_data._...
Hi there, when working with a scoped Script Include, I face the issue, that I cannot write into the document of the request.My Script Include is defined similar to this: var TestAjax = Class.create(); TestAjax.prototype = Object.extendsObject(globa...
I tried to follow the instructions, to stop creating a case based on a specific email. Went into email address filters and added to deny list. It is still creating a case. Any advice?
Hi everyone, I am encountering an odd issue. In Flow Designer, I have a simple "Look Up Records" action. This should look up records on the sys_documentation table (where Table = sys_user and Language = English). I have created this flow in the Globa...
Wanted to add tooltip/description for each of choice values in dropdown variable for catalog item. How can we do that?
Hello All,I want to check a date if it is after 5 weeks. How can I add the options here? If it is not possible, any alternatives to check the same?
I tried every which way to show sys_created_by as a column on the sys_log list. To no avail.First, when I click on the gear for "Personalize List", I don't even see sys_created_by as an option: Ok, let me try to force feed it on the sys_ui_list reco...
