/build/static/layout/Breadcrumb_cap_w.png

Moving Ticket to new Queue and retaining field values

Not sure what I'm missing here.

I have 2 identical queues.  All categories, priorities, etc. are the same.

I have a rule to move a ticket from queue a, to queue b when a specific status is selected. 

The move works great however after the rule is ran:

·     When the submitter views the ticket the category, priority, impact, etc. all show up blank. 

·     When the owner views the ticket the first value (not the default) in each of the lists (category, priority, etc.) are show. 

·     When the owner saves the ticket the following changes are logged:

    • Changed ticket Category from "" to "General Technical::Unable to Proceed".
      Changed ticket Impact from "" to "Closing today".
      Changed ticket Priority from "" to "Medium".

What I want is all values other than the ones I'm updating in the script to remain the same.  What am I missing?  Here is the update script I'm running

update HD_TICKET
            SET HD_TICKET.HD_QUEUE_ID = 7,
                  HD_TICKET.OWNER_ID = (select USER.ID from USER where FULL_NAME =    CUSTOM_FIELD_VALUE3)
            where
            (HD_TICKET.ID in (<TICKET_IDS>))

 

 


0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: mds1981 10 years ago
Orange Belt
0
I was able to achieve what I wanted using custom fields and multiple rules.

Don't be a Stranger!

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

Sign up! or login

View more:

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