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

[Kevin Falcone]

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