Does anyone know of a ready-made solution for emailing tickets search result
on a scheduled basis?
rt-crontool is a good solution if you want to do something (e.g. email) on
each individual ticket that matches search query.
But I’m looking for one email being sent which contains a list of all the
tickets that match the search query (and/or a chart of this).
Similar to capturing a snapshot of “RT at a glance” and sending it by email.
Example for usage: every night email the manager a list of all tickets that
were created in the past day and how they divide by current status.
Thanks,
Eynat
Hi
Example for usage: every night email the manager a list of all tickets that
were created in the past day and how they divide by current status.
Simple command line:
for s in open new resolved; do
echo “=== $s ===”; rt list -s “created = ‘today’ AND status = ‘$s’”;
done | mail …
LEGAL NOTICE
Unless expressly stated otherwise, information contained in this
message is confidential. If this message is not intended for you,
please inform postmaster@ccdc.cam.ac.uk and delete the message.
The Cambridge Crystallographic Data Centre is a company Limited
by Guarantee and a Registered Charity.
Registered in England No. 2155347 Registered Charity No. 800579
Registered office 12 Union Road, Cambridge CB2 1EZ.
Thanks - it does the job, but it has two drawbacks:
-
It produces very simple textual output. I would like to send a richer
HTML output similar to how search results appear in RT.
-
It is hard to customize. I would like to use a template mechanism for
easy customization that my occur later in time.
EynatFrom: Toby Darling [mailto:darling@ccdc.cam.ac.uk]
Sent: Wednesday, 06 February 2008 7:24 PM
To: Eynat Nir Mishor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Emailing tickets search result
Hi
Example for usage: every night email the manager a list of all tickets
that
were created in the past day and how they divide by current status.
Simple command line:
for s in open new resolved; do
echo “=== $s ===”; rt list -s “created = ‘today’ AND status = ‘$s’”;
done | mail …
LEGAL NOTICE
Unless expressly stated otherwise, information contained in this
message is confidential. If this message is not intended for you,
please inform postmaster@ccdc.cam.ac.uk and delete the message.
The Cambridge Crystallographic Data Centre is a company Limited
by Guarantee and a Registered Charity.
Registered in England No. 2155347 Registered Charity No. 800579
Registered office 12 Union Road, Cambridge CB2 1EZ.
Why don’t you just email a link to a search so that it runs when clicked?On 2/7/08, Eynat Nir Mishor eynatnir2@hotmail.com wrote:
Thanks - it does the job, but it has two drawbacks:
-
It produces very simple textual output. I would like to send a richer
HTML output similar to how search results appear in RT.
-
It is hard to customize. I would like to use a template mechanism for
easy customization that my occur later in time.
Eynat
-----Original Message-----
From: Toby Darling [mailto:darling@ccdc.cam.ac.uk]
Sent: Wednesday, 06 February 2008 7:24 PM
To: Eynat Nir Mishor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Emailing tickets search result
Hi
Example for usage: every night email the manager a list of all tickets
that
were created in the past day and how they divide by current status.
Simple command line:
for s in open new resolved; do
echo “=== $s ===”; rt list -s “created = ‘today’ AND status = ‘$s’”;
done | mail …
LEGAL NOTICE
Unless expressly stated otherwise, information contained in this
message is confidential. If this message is not intended for you,
please inform postmaster@ccdc.cam.ac.uk and delete the message.
The Cambridge Crystallographic Data Centre is a company Limited
by Guarantee and a Registered Charity.
Registered in England No. 2155347 Registered Charity No. 800579
Registered office 12 Union Road, Cambridge CB2 1EZ.
The rt-users Archives
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com
Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
That’s my fallback.
But I prefer a self-containing email rather than a link.
EynatFrom: Todd Chapman [mailto:todd@chaka.net]
Sent: Monday, 11 February 2008 5:12 AM
To: Eynat Nir Mishor
Cc: Toby Darling; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Emailing tickets search result
Why don’t you just email a link to a search so that it runs when clicked?
That’s my fallback.
But I prefer a self-containing email rather than a link.
We have something kind of cool along these lines that we’re working to
get opensourced. I’m hopeful that it will happen this week.
Hi Jesse,
Was this feature published?
Thanks, EynatFrom: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: Monday, 11 February 2008 12:27 PM
To: Eynat Nir Mishor
Cc: ‘Todd Chapman’; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Emailing tickets search result
That’s my fallback.
But I prefer a self-containing email rather than a link.
We have something kind of cool along these lines that we’re working to
get opensourced. I’m hopeful that it will happen this week.
Eynat
-----Original Message-----
From: Todd Chapman [mailto:todd@chaka.net]
Sent: Monday, 11 February 2008 5:12 AM
To: Eynat Nir Mishor
Cc: Toby Darling; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Emailing tickets search result
Why don’t you just email a link to a search so that it runs when clicked?
Thanks - it does the job, but it has two drawbacks:
-
It produces very simple textual output. I would like to send a
richer
HTML output similar to how search results appear in RT.
-
It is hard to customize. I would like to use a template mechanism
for
easy customization that my occur later in time.
Eynat
-----Original Message-----
From: Toby Darling [mailto:darling@ccdc.cam.ac.uk]
Sent: Wednesday, 06 February 2008 7:24 PM
To: Eynat Nir Mishor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Emailing tickets search result
Hi
Example for usage: every night email the manager a list of all tickets
that
were created in the past day and how they divide by current status.
Simple command line:
for s in open new resolved; do
echo “=== $s ===”; rt list -s “created = ‘today’ AND status = ‘$s’”;
done | mail …
LEGAL NOTICE
Unless expressly stated otherwise, information contained in this
message is confidential. If this message is not intended for you,
please inform postmaster@ccdc.cam.ac.uk and delete the message.
The Cambridge Crystallographic Data Centre is a company Limited
by Guarantee and a Registered Charity.
Registered in England No. 2155347 Registered Charity No. 800579
Registered office 12 Union Road, Cambridge CB2 1EZ.
The rt-users Archives
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com
Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
The rt-users Archives
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com
Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Not yet, nope.On Mar 5, 2008, at 2:46 AM, Eynat Nir Mishor wrote:
Hi Jesse,
Was this feature published?
Thanks, Eynat
-----Original Message-----
From: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: Monday, 11 February 2008 12:27 PM
To: Eynat Nir Mishor
Cc: ‘Todd Chapman’; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Emailing tickets search result
On Mon, Feb 11, 2008 at 11:05:00AM +0200, Eynat Nir Mishor wrote:
That’s my fallback.
But I prefer a self-containing email rather than a link.
We have something kind of cool along these lines that we’re working to
get opensourced. I’m hopeful that it will happen this week.
Eynat
-----Original Message-----
From: Todd Chapman [mailto:todd@chaka.net]
Sent: Monday, 11 February 2008 5:12 AM
To: Eynat Nir Mishor
Cc: Toby Darling; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Emailing tickets search result
Why don’t you just email a link to a search so that it runs when
clicked?
On 2/7/08, Eynat Nir Mishor eynatnir2@hotmail.com wrote:
Thanks - it does the job, but it has two drawbacks:
-
It produces very simple textual output. I would like to send a
richer
HTML output similar to how search results appear in RT.
-
It is hard to customize. I would like to use a template
mechanism
for
easy customization that my occur later in time.
Eynat
-----Original Message-----
From: Toby Darling [mailto:darling@ccdc.cam.ac.uk]
Sent: Wednesday, 06 February 2008 7:24 PM
To: Eynat Nir Mishor
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Emailing tickets search result
Hi
Example for usage: every night email the manager a list of all
tickets
that
were created in the past day and how they divide by current status.
Simple command line:
for s in open new resolved; do
echo “=== $s ===”; rt list -s “created = ‘today’ AND status =
‘$s’”;
done | mail …
LEGAL NOTICE
Unless expressly stated otherwise, information contained in this
message is confidential. If this message is not intended for you,
please inform postmaster@ccdc.cam.ac.uk and delete the message.
The Cambridge Crystallographic Data Centre is a company Limited
by Guarantee and a Registered Charity.
Registered in England No. 2155347 Registered Charity No. 800579
Registered office 12 Union Road, Cambridge CB2 1EZ.
The rt-users Archives
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com
Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
The rt-users Archives
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com
Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
–
PGP.sig (186 Bytes)