Hi, I want to calculate (not show) number of requests created 'yesterday', run by an al anyytime based on the ars-field 'Created'. Possible to use sql ..? (I know ars-dates and Oracle is a bit complicated). Is there another (fast) way than the sql-method? If sql can be used ..

For example, if the date is 2006-03-12 I want to get number of requests created > 2006-03-11 and < 2006-03-12

L ars Pettersson
Vattenfall Business Services Nordic AB
Action Request System Engineer (Tabasco)
S-461 88 Trollhättan
Sweden

Phone +46 520 888 35 Mobil +46 70 608 99 95
e-mail: lars.j.pettersson@vattenfall.com


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

Why not use a set fields action using the create date in the qualification?
If you set a temp field to the request id from the first returned entry then
the user won't get any messages and the $LASTCOUNT$ variable will be the
count that you want.

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of lars.j.pettersson@VATTENFALL.COM
Sent: 02 January 2006 21:02
To: arslist@ARSLIST.ORG
Subject: Q: Yesterday and sql ..

Hi, I want to calculate (not show) number of requests created 'yesterday',
run by an al anyytime based on the ars-field 'Created'. Possible to use sql
..? (I know ars-dates and Oracle is a bit complicated). Is there another
(fast) way than the sql-method? If sql can be used ..

For example, if the date is 2006-03-12 I want to get number of requests
created > 2006-03-11 and < 2006-03-12

L ars Pettersson
Vattenfall Business Services Nordic AB
Action Request System Engineer (Tabasco)
S-461 88 Trollhättan
Sweden

Phone +46 520 888 35 Mobil +46 70 608 99 95
e-mail: lars.j.pettersson@vattenfall.com



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)