-
Notifications
You must be signed in to change notification settings - Fork 11
/
general_module.js
70 lines (57 loc) · 1.54 KB
/
general_module.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
/*
* Module: General
* Created by: Mateus Mazzei Anzolin
* Version: 1.1
*/
/* --------- Glide Record --------- */
var gr = new GlideRecord('table_name');
gr.addQuery('field', 'value');
gr.addEncondedQuery('field=value');
gr.orderBy('field');
gr.query();
var array = [];
while(gr.next()){
array.push(gr.getValue('field'));
}
/* --------- Glide Aggragate --------- */
var agg = new GlideAggregate('table_name');
agg.addAggregate('COUNT', 'field');
agg.orderBy('field');
agg.addQuery('field', '>=', 'value');
agg.query();
while (agg.next()) {
var incidentCount = agg.getAggregate('COUNT', 'field');
}
/* --------- Glide Ajax --------- */
//Client Script
var ga = new GlideAjax('include_name');
ga.addParam('sysparm_name', 'getCampus');
ga.addParam('sysparm_field', g_form.getValue("field"));
ga.getXML(updateCampus);
/*Call Back*/
function updateCampus(response) {
var answer = response.responseXML.documentElement.getAttribute("answer");
var clearvalue;
if (answer) {
var returneddata = answer.evalJSON(true);
g_form.setValue("campus", returneddata.value);
} else {
g_form.setValue("campus", clearvalue);
}
}
//Script Include:
var include_name = Class.create();
include_name.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getCampus: function () {
var sysparm_field = this.getParameter('sysparm_field');
/*-- any code --*/
var json = new JSON();
var results = {
"value": "any_value")
};
if(results)
return json.encode(results);
}
} else return null;
}
});