Select Value link to Asset Type
I need some help. I'm trying to use "Select value" (Servicedesk-Custom Fields). I want to put the value from the Asset Type Department and map to servicedesk "Department" field.
Please log in to answer
Posted by: chucksteel 6 years ago
In order to use asset values in the service desk you need to create a query.
Set the custom service desk field to Single Select
For the Select Values field use the following:
query:select ASSET.NAME FROM ASSET WHERE ASSET_TYPE_ID = 2 ORDER BY ASSET.NAME ASC
This will select the assets from the table where the asset_type_id is 2, that is the ID for the Department asset on my KBox.
The service desk field will be populated with the results of the query when you view a ticket and you can select the appropriate value from the list.