Hi,
User wants to have the data for last ‘N’ hours. N should be prompted and it can be say 4 h or 27hrs etc. So we need to take care of time and date.
How to design object /condition for this purpose?
ravik (BOB member since 2004-06-02)
Hi,
User wants to have the data for last ‘N’ hours. N should be prompted and it can be say 4 h or 27hrs etc. So we need to take care of time and date.
How to design object /condition for this purpose?
ravik (BOB member since 2004-06-02)
You could build a predefined condition
I don’t know what database you are using , so i’ll base it on Oracle
date_time_column between sysdate-(@prompt(‘Hours’,‘N’,mono,free)/24) and sysdate
good luck
richmona (BOB member since 2003-04-15)
Hi,
Our DB is Oracle 9.
There are seperate columns/objects for Date and time.
ravik (BOB member since 2004-06-02)
Ravi,
You might check the date field in database. Generally oracle stores time along with the date in columns is defined as date data type, and if that is not the case then, look for the another column which has both date and time together( if not then im afraid is not a well designed data model).
And you can do a work around if they are in different columns, create a new objects as
then use in the condition which richmona suggested.
Hope this helps.
Let us know if u get it.
Faas (BOB member since 2004-02-24)