I have a requirement to report on the amount of time used for an end-to-end proc

mikej117 over 7 years ago

I have a requirement to report on the amount of time used for an end-to-end process flow. There are some complexities within the process flow that may cause ad-hoc extensions to the time allowance for that flow, so I am looking at creating a database table to record the initial time allowance, time used up already (for completed tasks within the process flow) and additional time allowances. The resultant data is to be displayed on reporting dashboards.
My question is around the best way to represent those positive and negative amounts of time. I see that there is a Time data type in Appian, but is that used to represent an amount of time, or the time of day? (Can it be negative?)

Discussion posts and replies are publicly visible

Parents

0 mohammedz
A Score Level 2
over 7 years ago

@mikej

We made a difference between the two timings and that difference has been converted to day : hr : mins : secs format and inserted into DB.

It's like use difference between the time and that results you can pass it into day()
hour() minute() seconds() and create your own format

Created a VIEW and by using database functions we added to all the approvals time of one particular order and that is been queried for report and it is shown. This seems to be quite accurate time calculated for each orders
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 mohammedz
A Score Level 2
over 7 years ago

@mikej

We made a difference between the two timings and that difference has been converted to day : hr : mins : secs format and inserted into DB.

It's like use difference between the time and that results you can pass it into day()
hour() minute() seconds() and create your own format

Created a VIEW and by using database functions we added to all the approvals time of one particular order and that is been queried for report and it is shown. This seems to be quite accurate time calculated for each orders
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data