Advanced Reference Qualifier for variable in Record Producer (Report Incident)

[Kasia5]

Hi All

I have two variables in Recor Producer:

'Affected user' with reference to sys_user table

and 'Configuration item' with refernce to 'cmdb_ci' table and mapped to 'Configuration item' in incident form.

Base on user from Affected user I want to show only these Configuration items which are assigned to this user.

How can I achieve this?

Thanks in advance. 

[J Siva]

Hi @Kasia5 

Just want to confirm, are you assigning CIs to the individual users rather than the assignment groups?

If yes, then the advanced ref qualifier should be like below,

javascript&colon;"<User field backend name from CMDB>="+current.variables.affected_user;

Note: please replace the <User field backend name from CMDB> with actual field name, like ci_owner etc

Hope this helps.

[Brad Bowman · Accepted solution]

Use a qualifier like this

where v_affected_user is the name of the Affected user variable