How to show assigned laptops in assets based on custom field

Question

Hi all, I am trying to display laptops assigned to the user chosen in another field.
I have given each laptop the attribute "Assigned" and chosen their Atlassian accounts.

The goal is to display only the device assigned to that user via a service desk front end form for users.

When replacing "Assigned" = ${customfield_11447.label} with "Assigned" = ${reporter.label}. It does work, if i will try and get the same (myself) from a customfield, it won't show anything.

Anything I am doing wrong here?, I have been googling/reading documentation and trying things for weeks.

--------------
User picker i have made (asset field type customfield ID 11447, this is where i choose the user):

Filter scope (AQL): objectType = "Laptops"

Filter issue scope (AQL): None

Allow search filtering by these attributes: Assigned

Object attributes to display on issue view: Assigned

Field can store multiple objects: No

Display a default object when this field appears in a customer portal: No
------------

The asset field that should show only devices assigned to the user:

Filter scope (AQL): objectType="Laptops"

Filter issue scope (AQL): "Assigned" = ${customfield_11447.label}

Allow search filtering by these attributes: Assigned, Model, Serial Number, Created, Ownership Type

Object attributes to display on issue view: Model, Assigned, Serial Number, Created, Ownership Type

Field can store multiple objects: No

Display a default object when this field appears in a customer portal: No

Christian Radwanski_ay0n6l · Answer

bump

Christian Radwanski_ay0n6l · Answer

You can't have a standard user picker, the custom field must of the type "asset".

"The AQL query contains one or more placeholder custom field IDs that are invalid or not Assets object fields."

The laptops must have an assigned user which does not make much sense to create a new object type. The problem will persist, what is weird that using reporter.label does work but customfield.label does not.

Rudy Holtkamp_hg9rkw · Answer

Hi @Christian Radwanski ,

Quick question: Is this correct?

User picker i have made (asset field type customfield ID 11447, this is where i choose the user):
Filter scope (AQL): objectType = "Laptops"

Shouldn't you have an object 'User', or maybe better, create a User picker field (single select) which contains all JSM customers and use that for the filter issue scoping of the Laptop asset field?