Page 1 of 1

how to sort on DB array column?

Posted: Sat Jan 04, 2014 5:20 pm
by Kartik A

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 - Image


how to sort on DB array column?

Posted: Sat Jan 04, 2014 6:36 pm
by maxkatz

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


how to sort on DB array column?

Posted: Sat Jan 04, 2014 7:50 pm
by Kartik A

yes


how to sort on DB array column?

Posted: Sat Jan 04, 2014 9:41 pm
by Kartik A

Any update Max?


how to sort on DB array column?

Posted: Sun Jan 05, 2014 5:53 am
by maxkatz

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


how to sort on DB array column?

Posted: Sun Jan 05, 2014 5:40 pm
by Kartik A

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.


how to sort on DB array column?

Posted: Mon Jan 06, 2014 3:06 am
by Illya Stepanov

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?