[rt-devel] Reporting Stats and a bug in date display in RT

Blue Lang blue at calico.gator.net
Mon May 15 12:11:00 EDT 2000


On Mon, 15 May 2000, Rouillard, John wrote:

>   getvals  -format "%{ticket_number} %{created_date} %{resolved_date}"
> 	-state=resolved -resolved_date > 05/01/00 -resolved_date < 05/15/00
> 

with all due respect, if you're smart enough to write a shell script, you
can learn enough SQL to do queries in about 15 minutes. it's not in any
way a difficult language.

in the long run, knowing enough sql to get around is almost requisite for
anyone working with (modern) databases, i think.

-- 
        Blue Lang                              Unix Systems Admin
        QSP, Inc., 3200 Atlantic Ave, Ste 100, Raleigh, NC, 27604
        Home: 919 835 1540  Work: 919 875 6994  Fax: 919 872 4015







More information about the Rt-devel mailing list