how to sort on DB array column?

Sat Jan 04, 2014 5:20 pm

I know we could sort REST response by using sort but when I try to provide array column name it doesnt sort.

I have a array column(history) in a table and I want to sort based on createDt key of history array column.

"history":[
{
"fromId":"5516895196",
"createDt":"2013-12-04"
}

when I enter in REST Service -history.createDt the result is not sorted. Please advise?

sort -

Sat Jan 04, 2014 6:36 pm

Just to clarify, you are trying to sort based on a value inside an array?

Sat Jan 04, 2014 7:50 pm

Sat Jan 04, 2014 9:41 pm

Any update Max?

Sun Jan 05, 2014 5:53 am

I need to check whether sorting works with an array. It works fine when you specify a value directly (not from an array)?

Sun Jan 05, 2014 5:40 pm

Mark, please provide ETA by when I could have a resolution for this problem. This is slowing down my development and I have hard deadlines.

Mon Jan 06, 2014 3:06 am

Hello -- the sort is works for the array the way you define it in the request parameter (we've tested). Is the service testing returning some errors? Can you show the full response?