What is the TicketSQL to select all tickets with requestor "nobody in particular” ?
I can’t get that list from the Search GUI either
thanks
al;
What is the TicketSQL to select all tickets with requestor "nobody in particular” ?
I can’t get that list from the Search GUI either
thanks
al;
Use ‘nobody’ vs. ‘nobody in particular’ as your search criteria.On Fri, Mar 13, 2015 at 4:02 PM, Al Joslin allen.joslin@gmail.com wrote:
What is the TicketSQL to select all tickets with requestor "nobody in
particular” ?I can’t get that list from the Search GUI either
thanks
al;
no, that doesn’t work
I was able to get something by selecting requestor email not like ‘@‘> On Mar 13, 2015, at 4:33 PM, Trev trevor@onepost.net wrote:
Use ‘nobody’ vs. ‘nobody in particular’ as your search criteria.
On Fri, Mar 13, 2015 at 4:02 PM, Al Joslin <allen.joslin@gmail.com mailto:allen.joslin@gmail.com> wrote:
What is the TicketSQL to select all tickets with requestor "nobody in particular” ?I can’t get that list from the Search GUI either
thanks
al;
Our “Nobody” user is ID #6 so I’d use that in the TicketSQL query as:
“Requestor.id = 6”
You can find out what your “Nobody” user’s ID is (probably the same as ours):
Landon Stewart : lstewart@iweb.com
Lead Specialist, Abuse and Security Management
Spécialiste principal, gestion des abus et sécurité
http://iweb.com : +1 (888) 909-4932> On Mar 13, 2015, at 1:02 PM, Al Joslin allen.joslin@gmail.com wrote:
What is the TicketSQL to select all tickets with requestor "nobody in particular” ?
I can’t get that list from the Search GUI either
thanks
al;
signature.asc (203 Bytes)