/build/static/layout/Breadcrumb_cap_w.png

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:
Posted by: chucksteel 6 years ago
Red Belt
0

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 6 years ago
    • Can you post a screenshot of the configuration? - chucksteel 6 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 6 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ