Re: [rt-users] SLA Extension - searching for tickets with SLA not set

[Chris McClement]

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] SLA Extension - searching for tickets with SLA not set

[Jeffrey Pilant]

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

[Jim Brandt]

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

[Jim Brandt]

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] SLA Extension - searching for tickets with SLA not set

[Chris McClement]

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?