Hello, This might have some simpler answer but I am not sure how to g

tapans over 9 years ago

Hello,

This might have some simpler answer but I am not sure how to get the maximum out of array of dates.

I have my dates (with time) stored in DB in this format : "2015-12-23 09:10:27"
Aim is to get data of latest date in appian.

Appreciate suggestions!

Thanks!

Discussion posts and replies are publicly visible

0 ankitb0003 over 9 years ago

have you tried with max in a!queryEntity() function.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 tapans over 9 years ago

I have my query entity fetches data for given KeyDepartment and sorted by date. So for every Keydepartment there are several results from which I need the result with latest date for each department.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 ankitb0003 over 9 years ago

You can create Database "View" to generate the required result with multiple condition and query to display it in Appian.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 tapans over 9 years ago

Thanks Ankit. I have managed it with other way around.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 leslies331 over 8 years ago

max(<ri!date>)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 tapans over 8 years ago

Thanks Leslie. It could be an alternative.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel