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

[Matthew Seaman]

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.

> 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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 259 bytes
Desc: OpenPGP digital signature
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090608/c1dfc8ee/attachment.sig>