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.
Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answer Chosen by the Author

0
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.
Answered 06/03/2015 by: chucksteel
Red Belt

  • Hi Chucksteel,

    Thanks for the query but when i put the query in the Servicedesk "Custom Fields" it shows my query.
    • Can you post a screenshot of the configuration?
      • This content is currently hidden from public view.
        Reason: Removed by member request
        For more information, visit our FAQ's.
      • now its working perfectly. Initially i did not put the word "query" that is the mistake. thanks a lot for your help.
Please log in to comment

Answers

Answer this question or Comment on this question for clarity