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
