Write a code for server script for fetching a custom table value ?

[1dusjhyahnt]

[Vishal Birajdar]

Hi @1dusjhyahnt 

try this :

(function() {
  /* populate the 'data' object */
  /* e.g., data.table = $sp.getValue('table'); */

      /*1. Declare the array*/
var myArray =[];
/*2. Glide record on table*/
var grInc = new GlideRecord('u_artificatory');
grInc.addQuery('sys_id','458688b893c04210e4f0398efaba10e7');
grInc.query();

if(grInc.next()){
/*2.1 Create empty object*/
var myObject = {

};
               /*2.2 Set object values*/
myObject.name = grInc.getValue('u_name');   //updated 
myObject.class = grInc.getValue('u_class');   //updated
/*2.3 Push object in array*/
myArray.push(myObject);
}
/*3. Set array to data */
data.values = myArray;
   
      gs.addInfoMessage(data.values[0].name);  //updated
gs.addInfoMessage(data.values[0].class);  //updated

})();

[1dusjhyahnt]

hi @Vishal Birajdar 

not getting any value 

[Vishal Birajdar]

hmm...strange...

May be because of 'class' identifier

try this....

(function() {
  /* populate the 'data' object */
  /* e.g., data.table = $sp.getValue('table'); */

      /*1. Declare the array*/
var myArray =[];
/*2. Glide record on table*/
var grInc = new GlideRecord('u_artificatory');
grInc.addQuery('sys_id','458688b893c04210e4f0398efaba10e7');
grInc.query();

if(grInc.next()){
/*2.1 Create empty object*/
var myObject = {

};
               /*2.2 Set object values*/
myObject.name = grInc.getValue('u_name');   
myObject.class_name = grInc.getValue('u_class');   //updated
/*2.3 Push object in array*/
myArray.push(myObject);
}
/*3. Set array to data */
data.values = myArray;
   
      gs.addInfoMessage(data.values[0].name);  
gs.addInfoMessage(data.values[0].class_name);  
})();

If this is not working then check in background script once...

[1dusjhyahnt]

now working

[Vishal Birajdar]

Cool....!!!