Get assignment group in workflow script

[Nawal]

Hi, 

i m trying to retrieve the assignement group related to the choice selected in the catalog item.

with this script in a task activity : 

var a= current.variables.la_reclamation_concerne.getDisplayValue();

//gs.log(a,'aaaa'); ==> good value.

var getag=new GlideRecord('u_sctask_assignment_socle_open'); ==> for every choice, an assignment group is dedicated in this table.

getag.addQuery('sys_id',a);

//gs.info("Field value iss "+getag.u_recl);

getag.query();

if(getag.next())

{

task.assignment_group=getag.u_assignment_group_open;

}

the variable in the catalog item : la_reclamation_concerne : "Lookup select box"

Any Idea why it s not working?

Thank you for your help

[Musab Rasheed]

Hello,

getag.addQuery('sys_id',a);

Compare with a String field as you are comparing with Lookup display value so comparing with sys_id won't work so either try with name or other field. Otherwise if Lookup value will give you sys_id then remove get DisplayValue()

Regards

[Nawal]

i tried with this and still not working : 

var a= current.variables.la_reclamation_concerne;

gs.log(a,'aaaa');

var getag=new GlideRecord('u_sctask_assignment_socle_open');

getag.addQuery('u_recl',a);

//gs.log(getag,'aa');
gs.info("Field value iss "+getag.u_recl);

getag.query();

if(getag.next())

{

task.assignment_group=getag.u_assignment_group_open.getValue();

}

[Mohith Devatte]

what value are you exactly getting in LOG?

[Nawal]

the log gives the value of the choice : 

Base de données DB2

value choosen in the form