Query Time Lapse

mfauzi

Hi all, I need to put a list of transaction and the lapse time between transaction datetime to current datetime.
I have tried to use duration fields and use query to display the time alpse but it does not work.
I really appreciate if anyone can show the rope on how to achieve this.

regards

mfauzi

Bump, I searched the forun and still cannot get any clue on how to do this.
Really need the here pls

mfauzi

Maybe I do not clarify my self properly here.

In traditional way it is easy for me to do this with sql. example below

select ( sysdate - object.live_time ) as lapse from object. This will display the current lapse time on the query.

In Awareim where do I put this , is it query ( how? I cannot fiind the way ) or in the business rule, ( I have tried that, but no output )

regards

hpl123

Mfauzi,
Sorry, I for one don´t fully understand what you´re trying to do. Can you elaborate some more?

Don´t know if this will help but if you´re trying to compare the time lapsed between stable data "transactions" i.e. BO A is saved at timestamp x and BO B is saved and timestamp y then you can use 2 timestamp attributes and use a duration attribute with rules to determine the difference. Again don´t know what you´re trying to do.

Rennur

You might have to develop this using business rules and AwareIM DATE & TIME functions.
I think only the 'AGE' function is available out-of-the-box. Returns the full year difference between the provided date and the current date .

Config Tool > Help > Aware IM Help > search for function:

Take a look at Moment.js. It may be of help to get you started:
Reference:
#Format (functions) and #Time From Now (range)

momentjs.com/docs/#/displaying/format/

Cheers

mfauzi

What I really want to achieve is this:
I have a order transaction with the order date. I want to display the outstanding order say orderno, order date, and lapse between order date and the current time in minutes.
Example query output:
Order No Order Date Lapse(Min)
12345678 2014/05/19 13.10 30
12458795 2013/05/18 13.10 1470

The lapse is between order date to current time.
If the user open the query 30 minute later, the lapse will be 60, 1500 minutes respectively.

Rennur

Have you tried using the duration attributes to store the calculated duration value?

mfauzi

Yes I have tried to use duraiton type, but I cannot find where to put the lapse formula. The formula is dynamic , I tried to put at default value but it gives error.
I've tried to use businss rule, but it also not working.

mfauzi

This is easier in direct sql such as :

select ( sysdate - order.live_time ) as lapse from order, but in Awareim I cannot find the way.

mfauzi

Maybe support can provide some insight on how to achive this

mfauzi

Bump any help to point to correct steps required here pls