/build/static/layout/Breadcrumb_cap_w.png

Can assets in a ticket field be pulled from a PC name or user in another field?

I would like to select a PC and have the location and other information pre populate in the ticket, im not sure how to accomplish this


4 Comments   [ + ] Show comments
  • You need to create a custom rule that would query the asset table to update the ticket. Do you have experience with MySQL? - chucksteel 8 years ago
  • Limited expereience, im using this code, but i dont get the results im looking for when i change the submitter

    query: select NAME from ASSET A JOIN HD_TICKET T on (A.OWNER_ID = T.SUBMITTER_ID) where A.OWNER_ID=T.SUBMITTER_ID - agrossman 8 years ago
  • The data will not populate from a ticket rule until the ticket is saved, presuming the ticket rule is configured for "on ticket save".

    If you are trying to define a custom field as a query, that will not work as the query will not have access to the required parameters at run time. - grayematter 8 years ago
    • I didnt create a rule, this is in the ticket layout in the customization of the queue. I use this in certain fields to only show or buildings:
      query: SELECT ASSET.NAME AS ASSET_NAME FROM ASSET_DATA_1 LEFT JOIN ASSET ON ASSET_DATA_1.ID = ASSET.ASSET_DATA_ID AND ASSET.ASSET_TYPE_ID=1 WHERE (ASSET.NAME like 'Building%') ORDER BY ASSET_NAME - agrossman 8 years ago
      • Those queries will work as the result set is not dependent on other data in the ticket. However, to have the data dependent on or populated by other elements, you will need a ticket rule. There are plenty of questions on this type of manipulation. Do a search here on "ticket rule populate field" and you should get a good smattering of samples. - grayematter 8 years ago
  • awesome thanks!!! - agrossman 8 years ago

Answers (0)

Be the first to answer this question

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