Re: [rt-users] RT 3.8.2 - Query Builder - Dashboards
No problem, MarcAnthony. -- Cassandra Phillips-Sears cassan...@bestpractical.com Office Manager Best Practical Solutions, LLC http://www.bestpractical.com On Jun 9, 2009, at 2:15 PM 6/9/09, MarcAnthony Barrette wrote: very helpful indeed, thanks for digging up this old post MarcAnthony Barrette Sr. Technical Support Manager e. marcanthony.barre...@theportalgrp.com e. marcanthony_barre...@toyota.com m. 415.350.1143 On Tue, Jun 9, 2009 at 10:50 AM, Cassandra Phillips-Sears cassan...@bestpractical.com wrote: On Jun 8, 2009, at 5:51 PM 6/8/09, Matthew Seaman wrote: MarcAnthony Barrette wrote: snip Also I would like to build a dashboard for Tickets Due Today and ones for Tomorrow. W/o having to go and change the Due is before date each day can It auto popolate based upon today's day +1 ? You can use relative terms like 'today', 'tomorrow' or '3 days ago' in the time fields for date based searches. They're interpreted every time the search is run. That should be sufficient for you to build your dashboards. Hello, MarcAnthony. If you are trying to use relative search terms like Matthew described, there is a thread in the archives that might help you; take a look at the Relative Dates in Search thread here: http://lists.fsck.com/pipermail/rt-users/2009-February/thread.html -- Cassandra Phillips-Sears Office Manager Best Practical Solutions, LLC http://www.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 3.8.2 - Query Builder - Dashboards
That did the trick, thanks Kevin and Matt
MarcAnthony Barrette
Sr. Technical Support Manager
e. marcanthony.barre...@theportalgrp.com
e. marcanthony_barre...@toyota.com
m. 415.350.1143
On Mon, Jun 8, 2009 at 5:10 PM, Kevin Falcone falc...@bestpractical.comwrote:
On Jun 8, 2009, at 5:51 PM, Matthew Seaman wrote:
MarcAnthony Barrette wrote:
Hello
I am trying to create some intelligent dashboards using the query
builders
to save defined searches, based on CFields.
I seem to recall in an older version of RT that the CFields and
values drop
down would show up the only one i see is the CF.{SLA} drop down. I
know I
can use the Advanced tab to Build the query manually, however the
drop downs
are more intuitive for less SQL empowered users. Is there a way to
enable
the query Builder to enumerate active CF's and their values? to use
in the
Query Builder?
As far as I can tell, CFs need to be global if they are to appear in
the query
builder pull-downs.
Just select a Queue first.
RT needs to know which CFs to display (based on the queue) unless
they're global
-kevin
Also I would like to build a dashboard for Tickets Due Today and
ones for
Tomorrow. W/o having to go and change the Due is before date each
day can
It auto popolate based upon today's day +1 ?
You can use relative terms like 'today', 'tomorrow' or '3 days ago'
in the
time fields for date based searches. They're interpreted every time
the
search is run. That should be sufficient for you to build your
dashboards.
Cheers,
Matthew
--
Dr Matthew Seaman The Bunker, Ash Radar Station
PGP: 0x60AE908C on serversMarshborough Rd
Tel: +44 1304 814890 Sandwich
Fax: +44 1304 814899 Kent, CT13 0PL, UK
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 3.8.2 - Query Builder - Dashboards
On Jun 8, 2009, at 5:51 PM 6/8/09, Matthew Seaman wrote: MarcAnthony Barrette wrote: snip Also I would like to build a dashboard for Tickets Due Today and ones for Tomorrow. W/o having to go and change the Due is before date each day can It auto popolate based upon today's day +1 ? You can use relative terms like 'today', 'tomorrow' or '3 days ago' in the time fields for date based searches. They're interpreted every time the search is run. That should be sufficient for you to build your dashboards. Hello, MarcAnthony. If you are trying to use relative search terms like Matthew described, there is a thread in the archives that might help you; take a look at the Relative Dates in Search thread here: http://lists.fsck.com/pipermail/rt-users/2009-February/thread.html -- Cassandra Phillips-Sears Office Manager Best Practical Solutions, LLC http://www.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 3.8.2 - Query Builder - Dashboards
very helpful indeed, thanks for digging up this old post MarcAnthony Barrette Sr. Technical Support Manager e. marcanthony.barre...@theportalgrp.com e. marcanthony_barre...@toyota.com m. 415.350.1143 On Tue, Jun 9, 2009 at 10:50 AM, Cassandra Phillips-Sears cassan...@bestpractical.com wrote: On Jun 8, 2009, at 5:51 PM 6/8/09, Matthew Seaman wrote: MarcAnthony Barrette wrote: snip Also I would like to build a dashboard for Tickets Due Today and ones for Tomorrow. W/o having to go and change the Due is before date each day can It auto popolate based upon today's day +1 ? You can use relative terms like 'today', 'tomorrow' or '3 days ago' in the time fields for date based searches. They're interpreted every time the search is run. That should be sufficient for you to build your dashboards. Hello, MarcAnthony. If you are trying to use relative search terms like Matthew described, there is a thread in the archives that might help you; take a look at the Relative Dates in Search thread here: http://lists.fsck.com/pipermail/rt-users/2009-February/thread.html -- Cassandra Phillips-Sears Office Manager Best Practical Solutions, LLC http://www.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 3.8.2 - Query Builder - Dashboards
MarcAnthony Barrette wrote:
Hello
I am trying to create some intelligent dashboards using the query builders
to save defined searches, based on CFields.
I seem to recall in an older version of RT that the CFields and values drop
down would show up the only one i see is the CF.{SLA} drop down. I know I
can use the Advanced tab to Build the query manually, however the drop downs
are more intuitive for less SQL empowered users. Is there a way to enable
the query Builder to enumerate active CF's and their values? to use in the
Query Builder?
As far as I can tell, CFs need to be global if they are to appear in the query
builder pull-downs.
Also I would like to build a dashboard for Tickets Due Today and ones for
Tomorrow. W/o having to go and change the Due is before date each day can
It auto popolate based upon today's day +1 ?
You can use relative terms like 'today', 'tomorrow' or '3 days ago' in the
time fields for date based searches. They're interpreted every time the
search is run. That should be sufficient for you to build your dashboards.
Cheers,
Matthew
--
Dr Matthew Seaman The Bunker, Ash Radar Station
PGP: 0x60AE908C on serversMarshborough Rd
Tel: +44 1304 814890 Sandwich
Fax: +44 1304 814899 Kent, CT13 0PL, UK
signature.asc
Description: OpenPGP digital signature
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 3.8.2 - Query Builder - Dashboards
On Jun 8, 2009, at 5:51 PM, Matthew Seaman wrote:
MarcAnthony Barrette wrote:
Hello
I am trying to create some intelligent dashboards using the query
builders
to save defined searches, based on CFields.
I seem to recall in an older version of RT that the CFields and
values drop
down would show up the only one i see is the CF.{SLA} drop down. I
know I
can use the Advanced tab to Build the query manually, however the
drop downs
are more intuitive for less SQL empowered users. Is there a way to
enable
the query Builder to enumerate active CF's and their values? to use
in the
Query Builder?
As far as I can tell, CFs need to be global if they are to appear in
the query
builder pull-downs.
Just select a Queue first.
RT needs to know which CFs to display (based on the queue) unless
they're global
-kevin
Also I would like to build a dashboard for Tickets Due Today and
ones for
Tomorrow. W/o having to go and change the Due is before date each
day can
It auto popolate based upon today's day +1 ?
You can use relative terms like 'today', 'tomorrow' or '3 days ago'
in the
time fields for date based searches. They're interpreted every time
the
search is run. That should be sufficient for you to build your
dashboards.
Cheers,
Matthew
--
Dr Matthew Seaman The Bunker, Ash Radar Station
PGP: 0x60AE908C on serversMarshborough Rd
Tel: +44 1304 814890 Sandwich
Fax: +44 1304 814899 Kent, CT13 0PL, UK
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
