[rt-users] RT 3.8.2 - Query Builder - Dashboards

[MarcAnthony Barrette]

That did the trick, thanks Kevin and Matt


MarcAnthony Barrette
Sr. Technical Support Manager
e. MarcAnthony.Barrette at ThePortalGrp.com
e. MarcAnthony_Barrette at Toyota.com
m. 415.350.1143


On Mon, Jun 8, 2009 at 5:10 PM, Kevin Falcone <falcone at bestpractical.com>wrote:

>
> 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 servers            Marshborough 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: sales at 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: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090609/01a43aa6/attachment.htm>