MarcAnthony Barrette wrote:
HelloI 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 servers Marshborough 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: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
