Re: [rt-users] SLA Extension - searching for tickets with SLA not set
Thanks! SLA IS NULL <- that worked. Following from this: I want to do a bulk update to set an SLA for these calls. However the bulk update page doesn't include any SLA fields. Any ideas how I would go about setting the SLA on these calls (other than manual, I have about 150 tickets that need this changed)? On Thu, 2 Feb 2017 at 06:28 Jeffrey Pilant wrote: > Chris McClement writes: > >I can't figure out how to search for a field (specifically, "SLA") that is > >unset: > > > >Tickets that are emailed to our helpdesk are inserted into a "Helpdesk" > >queue and from there an operator reviews the content and then assigns the > >ticket to the relevant queue. > > > >The "Helpdesk" queue does not have an SLA assigned to it, but the > >downstream queues do. What's been happening, though, is that tickets > >transferred from "Helpdesk" to "Queue1" (not it's real name) aren't > picking > >up the SLA default setting. Instead, the SLA field is unset. > > > >If I search for tickets with SLA = 'STANDARD' I get results showing > tickets > >that have that SLA value. > > > >If I search for tickets with SLA != 'STANDARD' I only get tickets that > have > >the SLA field set (URGENT or CRITICAL, for example). But I don't get the > >hundreds of tickets that don't have the SLA field set at all. > > > >Does anyone know the syntax to use to search for a field that is unset? > > On 9 Dec 2016, Matt Zagrabelny wrote: > >... you can search for > >tickets with empty CF values using the Advanced editing option of a > >Search: > > > >'CF.{bar}' is null > In reply to a question about searching CF.{bar} > > Maybe you can do something similar. > > /jeff > > > The information contained in this e-mail is for the exclusive use of the > intended recipient(s) and may be confidential, proprietary, and/or > legally privileged. Inadvertent disclosure of this message does not > constitute a waiver of any privilege. If you receive this message in > error, please do not directly or indirectly use, print, copy, forward, > or disclose any part of this message. Please also delete this e-mail > and all copies and notify the sender. Thank you. > >
Re: [rt-users] Search question: after a specific date
On Wed, Feb 1, 2017 at 11:24 AM, Barrett, Brian < brian_barr...@urmc.rochester.edu> wrote: > Dear RT, > > I have a question regarding the searching for “after” a specific date on 2 > consecutive months. The results for the current month include tickets from > the previous. See below > > When I do a search for > > Status = ‘resolved’ > > AND Owner = “user’ > > AND Resolved > ‘2016-12-31’ > > I get a specific total of 38 > > When I do a search for > > Status = ‘resolved’ > > AND Owner = “user’ > > AND Resolved > ‘201-01-31’ > Assuming this is 2017, not just 201 I get a specific total of 6 > > The 6 tickets showing for Feb are also in the report for Jan? Why? > Because you spcified > 2016-12-31, which encompasses everything up to today. Essentially, your two searches are identical, but one starts earlier than the other. You'd need to limit your date with something like Resolved < 2017-02-01 to eliminate anything past Jan 31. At least that's how I'm reading it; sorry if I'm mistaken. > I’m using RT v4.1.11 > > > -- Alex Hall Automatic Distributors, IT department ah...@autodist.com
Re: [rt-users] SLA Extension - searching for tickets with SLA not set
Chris McClement writes: >I can't figure out how to search for a field (specifically, "SLA") that is >unset: > >Tickets that are emailed to our helpdesk are inserted into a "Helpdesk" >queue and from there an operator reviews the content and then assigns the >ticket to the relevant queue. > >The "Helpdesk" queue does not have an SLA assigned to it, but the >downstream queues do. What's been happening, though, is that tickets >transferred from "Helpdesk" to "Queue1" (not it's real name) aren't picking >up the SLA default setting. Instead, the SLA field is unset. > >If I search for tickets with SLA = 'STANDARD' I get results showing tickets >that have that SLA value. > >If I search for tickets with SLA != 'STANDARD' I only get tickets that have >the SLA field set (URGENT or CRITICAL, for example). But I don't get the >hundreds of tickets that don't have the SLA field set at all. > >Does anyone know the syntax to use to search for a field that is unset? On 9 Dec 2016, Matt Zagrabelny wrote: >... you can search for >tickets with empty CF values using the Advanced editing option of a >Search: > >'CF.{bar}' is null In reply to a question about searching CF.{bar} Maybe you can do something similar. /jeff The information contained in this e-mail is for the exclusive use of the intended recipient(s) and may be confidential, proprietary, and/or legally privileged. Inadvertent disclosure of this message does not constitute a waiver of any privilege. If you receive this message in error, please do not directly or indirectly use, print, copy, forward, or disclose any part of this message. Please also delete this e-mail and all copies and notify the sender. Thank you.
Re: [rt-users] SLA Extension - searching for tickets with SLA not set
More detail if running on 4.4.1: SLA = '' # tickets where SLA was unset from a previous value SLA is NULL # never had an SLA set So this may be what you want: SLA is NULL OR SLA = '' On 2/1/17 12:06 PM, Jim Brandt wrote: What do you get if you search for SLA = '' ? On 1/31/17 10:55 PM, Chris McClement wrote: I can't figure out how to search for a field (specifically, "SLA") that is unset: Tickets that are emailed to our helpdesk are inserted into a "Helpdesk" queue and from there an operator reviews the content and then assigns the ticket to the relevant queue. The "Helpdesk" queue does not have an SLA assigned to it, but the downstream queues do. What's been happening, though, is that tickets transferred from "Helpdesk" to "Queue1" (not it's real name) aren't picking up the SLA default setting. Instead, the SLA field is unset. If I search for tickets with SLA = 'STANDARD' I get results showing tickets that have that SLA value. If I search for tickets with SLA != 'STANDARD' I only get tickets that have the SLA field set (URGENT or CRITICAL, for example). But I don't get the hundreds of tickets that don't have the SLA field set at all. Does anyone know the syntax to use to search for a field that is unset?
Re: [rt-users] SLA Extension - searching for tickets with SLA not set
What do you get if you search for SLA = '' ? On 1/31/17 10:55 PM, Chris McClement wrote: I can't figure out how to search for a field (specifically, "SLA") that is unset: Tickets that are emailed to our helpdesk are inserted into a "Helpdesk" queue and from there an operator reviews the content and then assigns the ticket to the relevant queue. The "Helpdesk" queue does not have an SLA assigned to it, but the downstream queues do. What's been happening, though, is that tickets transferred from "Helpdesk" to "Queue1" (not it's real name) aren't picking up the SLA default setting. Instead, the SLA field is unset. If I search for tickets with SLA = 'STANDARD' I get results showing tickets that have that SLA value. If I search for tickets with SLA != 'STANDARD' I only get tickets that have the SLA field set (URGENT or CRITICAL, for example). But I don't get the hundreds of tickets that don't have the SLA field set at all. Does anyone know the syntax to use to search for a field that is unset?
[rt-users] Search question: after a specific date
Dear RT, I have a question regarding the searching for "after" a specific date on 2 consecutive months. The results for the current month include tickets from the previous. See below When I do a search for Status = 'resolved' AND Owner = "user' AND Resolved > '2016-12-31' I get a specific total of 38 When I do a search for Status = 'resolved' AND Owner = "user' AND Resolved > '201-01-31' I get a specific total of 6 The 6 tickets showing for Feb are also in the report for Jan? Why? I'm using RT v4.1.11