Welcome, Guest Login

Support Center

Sort the feed from a Cloud Collection

Last Updated: Sep 08, 2016 05:52PM EDT
You can sort the order of the record in the XML feed generated from a Cloud Collection.

The benefit of ordering the XML feed is to display the content in that specific order in your app.

IMPORTANT: The order of the content you see on the screen is usually different than the order it is displayed in the app.
That's because the app has the ability to sort the content. It depends on how the app was built.
If the app doesn't sort the content and display it in the order it is received from the data feed then this sort function let you sort the way you need it.

  To sort the feed created from the Cloud Collection simply click on the "Sort by.." icon when you are in your Cloud Collection view.


 

Select one or more columns to control the sort order.

The order columns are listed will determine their priority for sorting records. The higher in the list, the higher the priority. If no columns are selected, the assigned record ID will be used to sort. When done defining your sort order click on "Save" to update your changes.

Using the same column twice may produce inconsistent results!


 

 

Here is a method to sort the exported XML feed from your Cloud Collection. 


To sort cloud collection data (assuming you have data that contains, let's say a 'Foo', 'Bar' and 'Wibble' column), add the following to the data's URL:
 
 
The ?_sort=Foo:D,Bar:A,Wibble:D above will sort the data by the (string) values in the Foo column in descending order, then by the values in the Bar column in ascending order and finally by the values in the Wibble column in Descending order.
 
You can specify one or more column sort descriptors (separated by commas in the URL).

Custom Filters

You can specify custom filters for your cloud collection using the _filter parameter. These filters allow for more advanced filtering, such a filtering by a partial match on a column, or filtering by comparing numeric values.

To filter cloud collection data (assuming you have data that contains, let's say a 'Foo', 'Bar' and 'Wibble' column), add the following to the data's URL:

http://builder.eachscape.local:3000/data/collections/10.xml?_filter=Foo:co:search%20term~and~(Bar:gt:2.5~or~Wibble:le:5)


The ?_filter=Foo:co:search%20term~and~(Bar:gt:2.5~or~Wibble:le:5) will return records with "search term" in the Foo column, and either a number in the Bar column greater than 2.5 or a number in the Wibble column less than or equal to 5.

Following are the available operators:
- eq: Equal
- ne: Not equal
- co: Contains
- nc: Does not contain
- lt: Less than
- le: Less than or equal to
- gt: Greater than
- ge: Greater than or equal to

Help us improve! Rate this article:

Yes I found this article helpful

Ask a Question   

support@eachscape.com
http://assets1.desk.com/
false
eachscape
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete