Skip to main content

Updating Reports for 'is_hold' - Kiến thức cơ bản / Developer & Reporting / Creating Reports - Deskpro Support

Updating Reports for 'is_hold'

Authors list

If you have reports that reference is_hold specifically, they must be updated to use the status instead following the change to Pending Status:

     WHERE tickets.is_hold = 1
     WHERE tickets.status = 'pending'

Any time you reference awaiting_agent, you may want to also include pending to maintain the same results as before. (Of course, it might actually be that the proper behaviour you want is not-on-hold tickets but you just didn't think to exclude them before.)

 WHERE tickets.status IN ('awaiting_agent', 'pending')

Hữu ích Unhelpful

32 of 75 people found this page helpful

Thêm nhận xét

Please log in or register to submit a comment.

Need a password reminder?