How can I set reference field with sys_id?

[richgk]

I have the following code:

var gr = new GlideRecord('new_call');

gr.addQuery('transferred_to',current.request); // we're looking for the original CALL

gr.query();                               // perform the query

// If the call that was transferred to this request task was found

if (gr.getRowCount() == 1) {

      while (gr.next()){

              gs.log('>> RGK <<' + gr.number);

              gs.log('>> RGK <<' + gr.sys_id);

              current.u_call_number = gr.sys_id;

      }

}

Which produces the following output:

Information       >> RGK <<CALL0004026

Information       >> RGK <<f87c10b4dba083402d4dfb041d9619e4

The field on the current form named u_call_number is a reference to a call (new_call table), but when setting this field to be the sys_id the form does not display anything. The 2nd line in the log output looks to be the sys_id for the CALL so what can be wrong?

Thanks,

Rich.

[roshanrao]

Admittedly, I don't completely understand the relationship between your tables. Assuming all that is correct, I'd do something like this ...

var gr = new GlideRecord('new_call');

gr.addQuery('transferred_to',current.request); // we're looking for the original CALL

gr.query();                               // perform the query

// If the call that was transferred to this request task was found

if (gr.next()){

              gs.log('>> RGK <<' + gr.number);

              gs.log('>> RGK <<' + gr.sys_id);

              current.u_call_number = gr.getUniqueValue();

}

[Deepak Kumar5]

var gr = new GlideRecord('new_call');
gr.addQuery('transferred_to',current.request); // we're looking for the original CALL
gr.query();                               // perform the query

// If the call that was transferred to this request task was found

if (gr.getRowCount() == 1) {
       while (gr.next()){
               gs.log('>> RGK <<' + gr.number);
               gs.log('>> RGK <<' + gr.getDisplayValue());
               current.u_call_number = gr.sys_id;
       }
}

[richgk]

I've made that change but the u_call_number field remains blank although the log data shows that it is retrieving the sys_id OK.

The relationship is that I have created a reference field in the sctask table in order to link back to the Call addon application table new_call (this application is not enabled out of the box).

[Deepak Kumar5]

current.u_call_number = gr.getDisplayValue();