download free 30 days trial version buy simpledb explorer
Documentation   Download   Purchase   Support   FAQs   Forum   ScreenShots & Demos       

How to sort Amazon SimpleDB records by item identifier (item name)?

Sort by Attribute or Amazon Simple DB Item Name [1] feature in SDB Explorer helps you to sort the item rows according to the selected attribute and order type (Ascending / Descending) in the table.

To sort by item name, you can run the query as " Select * from <domain-name> where itemName() is not null order by itemName() " .

Follow the steps below to sort records by Attribute:

  1. Run SDB Explorer as usual.
  2. Select domain and right click on it.
  3. Choose Explore domain option from pop up list.
  4. All the items of selected domain display in GRID, just below the Query Textbox.
  5. Select an Attribute from drop down list provided at the top bar of items grid.
  6. Check the Order-Asc check box to sort records in ascending order and un-check the same check box to sort records in descending order.
  7. Click on Sort by Button.
  8. Now your SimpleDB records in table will be sorted according to the selected attribute and order type.

  1. ˆ Amazon Simple DB Item Name : Amazon SimpleDB provides a unique identifier for each row or Item which is know as Sdb-Item-Name.
     

Related Topics :