Andre

For fetching the ticket that ever changed to "High" priority, I'd suggest creating a trigger that adds a tag "changed_to_high".

The condition of the trigger would be simple "priority" > "changed to" > "high". This would work only for new transition though.