autosys java_Code snippet(不定期更新)

1. Fire the notification event

gs.eventQueue("event_name", current, null, null);

parm1: event name

parm2: glide record

parm3: sys id if notification event 1 checkbox is ticked. if not it will work in email script event parm.

parm4: as top.

2. Copy attachments from one table to another

new GlideSysAttachment.copy("source_table_name", source_record_sys_id, "target_table_name", target_record_sys_id);

3.The client script to reload a form

reloadWindow(window);

4.Get the display value for a language

var lang = gs.getSession().getLanguage(); // puts the user's current language in a variable

gs.getSession().setLanguage("es"); // sets the session language to whatever you want, this one is Spanish

gs.print(gr.title.getDisplayValue()); // prints the Spanish translation of the "title" field of the GlideRecord variable "gr"

gs.getSession().setLanguage(lang); // sets the langauge back to what it was

5.Set Attachment to be Mandatory

try { //Works in non-portal ui

var attachments = document.getElementById('header_attachment_list_label');

if (attachments.style.visibility == 'hidden' || attachments.style.display == 'none' ) {

g_form.addErrorMessage('You must attach the completed form before submitting this request.');

return false;

}

} catch(e) { //For Service Portal

var count = getSCAttachmentCount(); //this function was created in UI script in global scope.

if(count <= 0) {

g_form.addErrorMessage('You must attach the completed form before submitting this request.');

return false;

}

}

//need write to UI Script file and Include in the Portal Themes

function getSCAttachmentCount() {

var length;

try {

length = angular.element("#sc_cat_item").scope().attachments.length;

} catch(e) {

length = -1;

}

return length;

}

6. Calculate the next workday by Schedule

var duration = '3 00:00:00';

//var dayDuration = new GlideDuration(duration);

var startDate = new GlideDateTime(created_on);

var slaDef = new SLADefinition();

slaDef.setSchedule(scheduleId); //need to create a schedule

//slaDef.setDuration(dayDuration);

slaDef.setDuration(duration);

var endDate = slaDef.getExampleBreachTime(startDate);

//如果要使用GlideDuration，需使用毫秒加特定时间比如60*60*9*1000*天数

7.Loop to make fields to be read only

var fields = g_form.getEditableFields();

for (var x = 0; x < fields.length; x++) {

if (fields[x] != 'work_notes' && fields[x] != 'work_start' &&fields[x] != 'work_end') {

g_form.setReadOnly(fields[x], true);

}

}

8.Get the label for a choice list value

var choiceValue = g_form.getValue();

var choiceLabel = g_form.getOption(, choiceValue).text;

9.Get Display Value in Client Script for Reference field (unsupport Service Portal)

var user = g_form.getReference('caller_id', callBack);

function callBack(user){

alert(user.name);

}

10.How to get the first comment in activity log

current.comments.getJournalEntry(-1)

11.Convert duration to seconds in javascript

var slaDuration = current.sla.duration;

var duration = slaDuration.getGlideObject().getNumericValue();

var durationSeconds = (duration/1000);

12.How to get the ID of an Annotation in form (Annotation can't work on Service Portal)

var refs = document.getElementsByClassName("annotation-wrapper");

refs[3].style.display = 'none';

13. Use GlideRecord in Client Script

var gr_user = new GlideRecord("sys_user");

gr_user.addQuery("active",true);

gr_user.query(function(gr_user){

while(gr_user.next()){

//do something

g_form.getValue("name");

}

});

14. How to convert attachment to base64 code as string

var attachment_sysid = "003a3ef24ff1120031577d2ca310c74b"/* some sys_id string */;

var gr = new GlideRecord("sys_attachment");

if (gr.get(attachment_sysid)) {

var ga = new GlideSysAttachment();

var binData = ga.getBytes(gr); //getBytes function is not list in api doument but it can work.

var base64Data = GlideStringUtil.base64Encode(binData); //GlideStringUtil is global common util but not list in api document

}

//使用GlideSysAttachment转换出的数据会有5M的限制，可以使用如下方式突破5M限制。

var gsa = GlideSysAttachmentInputStream(gr.getValue("sys_id"));

var baos = new Packages.java.io.ByteArrayOutputStream();

gsa.writeTo(baos);

var binData = baos.toByteArray();

var base64Data = GlideStringUtil.base64Encode(binData);

var urlData = GlideStringUtil.urlEncode(base64Data);

......

*15. How to sort Reference type with order field by out of box.

find attribute option in default value tab and type as below.

ref_ac_order_by=u_order /*u_order is customer filed*/

Reference类型的variable，在attribute设置下拉框中多个column提示

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=email,ref_ac_order_by=sys_class_name,ref_ac_columns_search=true

*16. Change the category of all 'software' incidents to 'hardware' without updating sys fields.

var gr = new GlideRecord('incident');

gr.addQuery('category', 'software');

gr.query();

while(gr.next()){

gr.category = 'hardware';

gr.setWorkflow(false); //Do not run business rules

gr.autoSysFields(false); //Do not update system fields

gr.update();

}

*17. UI Action Validation

//UI Action中勾选Client，并设置唯一自定义Action名字iedRejectComments。

//UI Action中勾选Client后的代码为客户端和服务端代码混合。

function checkComments(){

var flag = confirm('Are you sure you want to reject the request?');

if(flag){

g_form.clearMessages();

g_form.setValue("state",107);//触发已设置好的UI policy:"当状态为107的时候将某字段设置为强制填写"

gsftSubmit(null, g_form.getFormElement(), 'iedRejectComments');

return true;

}

return false;

}

if (typeof window == 'undefined') callServerSide();

function callServerSide(){

current.state = 107;

current.update();

action.setRedirectURL(current);

gs.addInfoMessage('The request has been rejected.');

}

*18. save base64 file to specified record

var attachement = new GlideSysAttachment();

var base64String = File; //File为base64Encode的字符串代码

var attachment_sys_id = attachement.writeBase64(gr,"test.gif","application/gif",base64String );

gs.info("attachment_sys_id"+attachment_sys_id);

//Note: GlideSysAttachment这个对象只能适用于Scope范围，Global不识别。

*19.Catalog Item的client script 获取URL参数

function onLoad() {

var requestBy = getParameterValue("id");//id 为querystring的key

}

function getParameterValue(name) {

name = name.replace(/[\[]/, "\\\[").replace(/[\]]/, "\\\]");

var regexS = "[\\?&]" + name + "=([^]*)";

var regex = new RegExp(regexS);

var results = regex.exec(unescape(top.location));

if (results == null) {

return "";

} else {

return unescape(results[1]);

}

//使用console.log去观察top这个对象会有惊喜。

*20.UI Action打开模态对话框

function openPopUp(){

var dialogClass = window.GlideModal ? GlideModal : GlideDialogWindow;

var dialog = new dialogClass("contract_renew_popup");

dialog.setWidth("800");

dialog.setTitle(getMessage("Renew The Contract"));

dialog.setPreference("sys_id", g_form.getUniqueValue());

dialog.setPreference("short_text", "Please verify or update the conditions of this contract renewal:");

dialog.render(); //Open the dialog

}

*21.ClientScript选择表单所有field的方法

for (var index = 0; index < g_form.elements.length; index++) {

var name = g_form.elements[index].fieldName;

g_form.setMandatory(name,false);

g_form.setReadOnly(name,true);

}//g_form.elements不适用于Portal 端 widget里的client code

*22.how to do cache clear

type cache.do in your application navigator

*23.how to get message in both client and server side

Client Side:

getMessage("msg_key", function(msg){ alert(msg); });

Server Side:

gs.getMessage("msg_key");

*24.modify import set template default 10000 row limit

Create new global system properties named 'glide.import_template.row_limit' and the type is Integer