Page Comparison

...

• The view in this example has a total of 67 variables (columns) and has limited the records returned to 20 by default. To limit the columns use the colLimit parameter parameter.

  Code Block
  title Select Query Column Subset
  http://{host}/rds/{collection}/{view}/select?colLimit=10

  Code Block
  title Info
  { records: [...], info: { colLimit: 10, colOffset: 0, colCount: 67, moreCols: true, format: "MTNA", includeMetadata: false, limit: 20, offset: 0, moreRows: true } }

• Paging forward and backwards through the columns can be achieved by adjusting the colOffset parameter parameter.

  Code Block
  title Columns 11-20
  http://{host}/rds/{collection}/{view}/select?colLimit=10&colOffset=10

  Code Block
  title Columns 21-30
  http://{host}/rds/{collection}/{view}/select?colLimit=10&colOffset=20

• When I hit the last group of ten 10 (columns 61-67) we will see is retrieved the "moreCols" property is now will be false, a quick and easy indication for any UI that there are no more columns. 

  Code Block
  http://{host}/rds/{collection}/{view}/select?colLimit=10&colOffset=60

  Code Block
  { records: [...], info: { colLimit: 10, colOffset: 60, colCount: 67, moreCols: false, format: "MTNA", includeMetadata: false, limit: 20, offset: 0, moreRows: true } }

Paginating Records

• If developers want to see the count of total records for they view, the count parameter can be used. 

  Code Block
  title Get Total Record Count
  http://{host}/rds/{collection}/{view}/select?count

  Code Block
  { records: [...], info: { colOffset: 0, colCount: 67, moreCols: false, format: "MTNA", includeMetadata: false, limit: 20, offset: 0, count: 662, moreRows: true } }

• Record limits can be adjusted using the limit paramter. 

  Code Block
  title Select 100 Records
  http://mhdo.mtna.us:8080/rds/catalog/test/NES1948/select?limit=100

• Records can be paginated using the offset parameter. 

  Code Block
  title Records 101-200
  http://mhdo.mtna.us:8080/rds/catalog/test/NES1948/select?limit=100&offset=100

  Code Block
  title Records 201-300
  http://mhdo.mtna.us:8080/rds/catalog/test/NES1948/select?limit=100&offset=200

  Code Block
  title Records 201-300
  http://mhdo.mtna.us:8080/rds/catalog/test/NES1948/select?limit=100&offset=100