That did the trick, thanks Kevin and Matt
MarcAnthony Barrette Sr. Technical Support Manager e. [email protected] e. [email protected] m. 415.350.1143 On Mon, Jun 8, 2009 at 5:10 PM, Kevin Falcone <[email protected]>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: [email protected] > > > > > > 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: [email protected] > > > 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: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
