Hi,
My query is somewhat similar,

Have created a catalog item with three variable : 'User' (reference field) , 'Device', 'Device Name'.

Once the user is selected in 'User' field, 'Device' field populates with the sys_id (from sys_audit , cmdb_ci_computer table where table name:cmdb_ci_computer and Field_name:Assigned_to).

But, the 3rd field i.e. 'Device Name' is not getting populated with the top old device that was assigned to the user.

I only want to display the old device (That was) assigned to user

If anybody could help me with this