Advanced reference qualifier for variable in record producer

[abjaffrey]

Hi all,

I have a use case in a record producer form

• there is a requested for field which references the user table
• there is an asset details field which references alm_hardware table

My need is that based on requested for, the asset details variable should only display the assets assigned to the selected user. can someone help me with this.

Advanced ref qualifier for the variable :

javascript: new getGroupMember().assignedAssets(caller_id);

SI:

    assignedAssets : function(getUser)

    {

        var assets = [];

        var abc = new GlideRecord('alm_hardware');

        abc.addQuery('assigned_to',getUser);

        abc.query();

        while(abc.next()){

            assets.push('asset_tag');

        }

        return assets;

    },

[Sebastian L · Accepted solution]

javascript: 'assigned_to='+current.variables.caller_id

Just add this to the reference qualifier of  your asset details

[Sebastian L · Accepted solution]

javascript: 'assigned_to='+current.variables.caller_id

Just add this to the reference qualifier of  your asset details

[abjaffrey · Accepted solution]

hi @Sebastian L 

thanks for the response, it worked.