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

Comments

  • You need to create a custom rule that would query the asset table to update the ticket. Do you have experience with MySQL?
  • 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
  • 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.
    • 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
      • 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.
  • awesome thanks!!!
Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity

Share