Select Value link to Asset Type
Hi,
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.
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
chucksteel
8 years ago
Top Answer
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.
Comments:
-
Hi Chucksteel,
Thanks for the query but when i put the query in the Servicedesk "Custom Fields" it shows my query. - lalako88 8 years ago-
Can you post a screenshot of the configuration? - chucksteel 8 years ago
-
now its working perfectly. Initially i did not put the word "query" that is the mistake. thanks a lot for your help. - lalako88 8 years ago