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

[Diaulas Castro]

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?

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