Hi,

You can achieve this using advanced ref qualifier. Create a script include which will return the values for Category that matches the current Plant Name. call that script inlcude in ref qualifier.

Also your Plant name field looks like a choice field and not a ref, can you confirm

Please mark helpful/correct if this helped

Hi Tapish,

The plant name field is a Reference field with choice.

Thanks,

Yesh

Hi @Tapish Sharma ,

I have tried creating a script include and calling it in the reference qualifier. The script is returning a single record. Can you help me out with the script?

uniqueCat: function(plant) {
var pList = [];
var plan = new GlideRecordSecure('x_rfq_module_categories');
plan.addQuery('u_plant', plant);
plan.query();

while(plan.next()) {
gs.addInfoMessage(plan.u_category);//here i am getting all categories which are matched with plant name
pList.push(plan.sys_id);
}
return 'sys_idIN' + pList.toString();//only returning the last record
}

Thanks,

Yesh

Hi Yesh,
You can achieve this by advance reference qualifiers.
Try adding the below code.

javascript:"plant=" + current.variables.plant_name;

Please let me know if you are seeking someting more in it.

Please mark my answer correct/helpful as applicable!


Regards,
Rahul