Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
7 replies
Subscribers
7 subscribers
Views
2324 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
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?)
OriginalPostID-219721
OriginalPostID-219721
Discussion posts and replies are publicly visible
Parents
0
mikej117
over 7 years ago
Hi @mohamedb, I'm ok with calculating the difference between dates, what I was asking about was how to represent these values in the database.
I see that MySQL has a Time data type, but I'm unconvinced that the Appian Time data type is the correct mapping for the CDT.
Just wondering if other people have used this data type for this purpose.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
mikej117
over 7 years ago
Hi @mohamedb, I'm ok with calculating the difference between dates, what I was asking about was how to represent these values in the database.
I see that MySQL has a Time data type, but I'm unconvinced that the Appian Time data type is the correct mapping for the CDT.
Just wondering if other people have used this data type for this purpose.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data