List of updated tickets

How do I get the list of tickets, as a cronjob report, that has been
updated or created since last hour?

Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu

Try next tSQL: "LastUpdated > ‘-1 hour’ ".On 3/4/07, Asif Iqbal vadud3@gmail.com wrote:

How do I get the list of tickets, as a cronjob report, that has been
updated or created since last hour?


Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

Try next tSQL: "LastUpdated > ‘-1 hour’ ".

Excellent!

Is there a way to get it using any RT tool?

How do I get the list of tickets, as a cronjob report, that has been
updated or created since last hour?


Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


Best regards, Ruslan.

Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu

Try next tSQL: "LastUpdated > ‘-1 hour’ ".

Excellent!

Is there a way to get it using any RT tool?
As far as I know all RT tools should support it, you can use it in
WebUI, CLI, crontool and all other tools that allows you to define
search condition using “ticket sql”.
If you’re talking about custom code, then RT::tickets::FromSQL method
takes “ticket sql” as input and applies conditions in the string to
the collection.

How do I get the list of tickets, as a cronjob report, that has been
updated or created since last hour?


Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


Best regards, Ruslan.


Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu

Best regards, Ruslan.