Edit DataSet View fields

These limit the range of rows that can be displayed. For example, if you have 25 rows and want to display data from only rows 10 to 15, set Lower Row Limit to 10 and Upper Row Limit to 15.

However this feature has two bugs:

When creating or editing a dataset, rows are numbered begin at 1, however when adding a dataset to a region, in Edit DataSet View, it seems row numbers begin at 0. (e.g. to display data from row 3 to 6, it's necessary to specify Lower Row Limit 2 and Upper Row Limit 5)

and

Specifying 0 in Lower Row Limit causes all rows to be displayed, regardless of the value in Upper Row Limit.

Order refers to the data sort order in the dataset view.

To sort ascending (A to Z) specify the column name you want to sort on. e.g. if the column name is "dish", simply write: dish

To sort descending, (Z to A) specify the column name you want to sort on, followed by DESC, like this: dish DESC

Note: all data is stored as a string and the sort order is alphabetical. I.e. an ascending sort of prices (e.g. in a wine list) 40, 60, 80, 100 would result in this output: 100, 40, 60, 80 (because "1" comes before "4"). To remedy this, prefix the narrower prices with spaces so that they contain the same number of characters as the widest price. i.e. "40","60","80" become " 40", " 60", " 80". Note: "100" being the widest, needs to remain "100".

Many thanks, that answers my question. To me this is just 1 bug - numbering from a 0 start is not unusual. I assume the 'bug' relating to specifying 0 as the Lower Row Limit is known by the developers and will be fixed in due course.

I've tested this and adding 'DESC' to the field does not work. For instance specifying field name 'Date' works fine, specifying 'DATE DESC' does not return any rows.

Isn't it upper/lower case sensitive?

Try this: Date DESC

Makes no difference - Date DESC or DATE DESC - neither works for me. Dropping the DESC on either options works fine.

All data is stored as a string and the sort order is alphabetical. Thus, to have dates sorted properly, they need to be in the format:
 yyyy-mm-dd

Note: "-" could be another character such as "/", but must be consistent for all entries.

I understand sort orders, the question is why DESC doesn't work. Whatever the value in the field I would expect DESC to reverse the natural order (i.e. a b c would become c b a, 1 2 3 would become 3 2 1 etc)

Sorry, I don't know why it doesn't work for you. (It works on my setup.)

my unsorted data in column: Date
2013-01-01
2013-12-31
2012-01-01
2012-12-31
2014-01-01

what I see for Order: Date
2012-01-01
2012-12-31
2013-01-01
2013-12-31
2014-01-01

what I see for Order: Date DESC
2014-01-01
2013-12-31
2013-01-01
2012-12-31
2012-01-01

I've tested more and t does work. Not sure how I saw it didn't before, must clean my glasses :-). That's good. It would also be good to know all the other parameters that can be used in this field. I've an outstanding query about what can go in the Filter field, as I want to know how to limit the number of records shown.