Need to get the records for a reference field based on another fields value

[Yesh]

Hi Team,

I have field named Category which is a reference type field, referencing table contains two fields: Category and Plant. I have another Field called Plant Name in the current table, it is also a reference type field. By selecting the plant name, I need the records for category in which the selected plant name matches with the Plant which is there in Category table.

Current Table:

Category Table:

Is there any suggestion, how to achieve this?

Thanks,

Yesh

[Tapish Sharma1]

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

[Yesh]

Hi Tapish,

The plant name field is a Reference field with choice.

Thanks,

Yesh

[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

[Rahul Talreja]

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