I thought I did this before but can't remember what I did.  How do you map a custom a custom ticket field to individual assets?

Basically I set up all our buildings as assets.  On the ticket layout field, I have custom field 1 and I want to insert those assets into the field, so when the user goes to fill out a ticket, they can choose their building.  I wanted to do it this way instead of writing out each building's name.  I swear I thought I had done with before but I can't remember how or what I did.

1 Comment   [ - ] Hide Comment


  • Find the asset type ID by going into Assets -> Asset Types and clicking on the asset type. The URL should end with ID=X

    In the help desk queue, under the section called "Custom fields" define the desired field to be field type "single select" or "multiple select".

    Set the select list of values as the query with the word "query:" written at the front so that the K1000 appliance knows to get the results. Replace X with the asset type ID you found in the first step.

Please log in to comment

Answer this question or Comment on this question for clarity


There is a default example built into the queue, if you go to the queue and then customize fields and layouts and scroll down to the custom field section. Click the small blue question mark next to the heading, in there you will see the example:

query: select distinct(LOCATION) from USER

If you have the location fields pulled in from your AD, they will then be shown in the dropdown, otherwise you will need to use the solution as in the comments from tshupp
Answered 10/07/2015 by: Hobbsy
Red Belt

  • FYI. With the new version of K1000 (7.0.121306) this query no longer works due to the reorganization of the Location asset. Use this instead: QUERY: SELECT ASSET.NAME FROM ASSET WHERE ASSET_TYPE_ID=1 ORDER BY ASSET.NAME ASC
    • Which is kind of ironic as it is still the example displayed within the queue configuration. Nice testing Quest!!
Please log in to comment