How to show assets based on requested for.

[Pradeep36]

I have order guide with two variable sets

Variable set 1 has requested for variable(Reference -sys_user)

variable set2 has select your hardware(Reference -alm_hardaware)

I am using reference qualifier to shows assigned to requested and retirement date of asset is before today's date.

But select hardware shows all the assets. If i take of retirement date from reference qualifier it shows assets assigned to user. My reference Qualifier

javascript&colon;'assigned_to='+current.variables.requested_for +^retirement_date<javascript&colon;gs.beginningOfToday()^EQ

[Jitendra Kumar1 · Accepted solution]

Hi Pradeep,

You can call a Script Include from the reference qualifier like

javascript&colon;new CustomScriptInc().getRetiredAsset(current.variables.requested_for);

In the Script Include you will write some piece of code like

getRetiredAsset: function(user) {

        var hardware = new GlideRecord('alm_hardware');

        hardware.addQuery("assigned_to", user);

        hardware.addEncodedQuery("retired<javascript&colon;gs.beginningOfToday()");

        hardware.query();

        var arr =[];

        while(hardware.next()){

            arr.push(hardware.sys_id.toString());

        }

        return 'sys_idIN' +arr.toString();

    },

Here I have taken retired field but you need to take retirement date as per your requirement.

Please mark it as helpful and accepted solution if it solves your issue.

Thanks,

Jitendra

[Gaurav Vaze]

I used similar kind of thing and it worked, kudos to you