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

tapans over 10 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 ankitb703441
Certified Lead Developer
over 10 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 10 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 ankitb703441
Certified Lead Developer
over 10 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 10 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 10 years ago

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

Sign in to reply

Verify Answer

Cancel
0 tapans over 10 years ago

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

Sign in to reply

Verify Answer

Cancel