[rt-users] RES: Monthly reports with REST (timeout)

Diaulas Castro diaulas.castro at intersolution.inf.br
Wed Oct 31 11:36:48 EDT 2012

Just a bet, but try to use "-t ticket" on search.

-----Mensagem original-----
De: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] Em nome de Ignacio Vazquez
Enviada em: quarta-feira, 31 de outubro de 2012 09:26
Para: rt-users at lists.bestpractical.com
Assunto: [rt-users] Monthly reports with REST (timeout)

Hi all,
I've been generating monthly reports with a crontab script that includes a line like this:
/opt/rt3/bin/rt list "created >= '2012-04-01' AND status != 'rejected'
AND Queue = 'whatever' AND (owner = 'user1' OR owner = 'user2')" | grep -v "No matching results." | wc -l As you can see, I'm only interested in the total number of tickets.
I've find out that with a large number of possible results, I get a timeout so 0 tickets are returned.

However, using the web search, because of the paginated displays, the search is much faster and also the web shows how many items are in the whole list with a line "Found: xxx tickets".

My intention is still using an automated way to obtain the numbers.
I've been reading the REST documentation and there is no way to query only for totals.

Any ideas?

We're hiring! http://bestpractical.com/jobs

More information about the rt-users mailing list