|« PreviousNext »|
|Did this page help you? Yes | No | Tell us about it...|
In this section, you will use the Amazon DynamoDB console to try an example query against the Reply table. The query finds forum replies posted in the last 15 days for the "Amazon DynamoDB Thread 1" thread in the "Amazon DynamoDB" forum.
To query a table
Open the Amazon DynamoDB console at https://console.aws.amazon.com/dynamodb/home.
If you have not already signed in, you will see the Sign In dialog before you see the console.
In the Tables pane, select the Reply table and click Explore Table.
In the Browse Items tab, click Query.
The console shows data entry fields for you to specify the hash and range primary key values, Hash Key and Range Key. It also shows drop-down list boxes for you to select comparison operators.
A Query operation is only valid for tables that have a hash and range type primary key. If you explore a table with a hash type primary key, the console will display Get instead of Query.
Specify the Hash Key and Range Key values and select comparison operators as shown in the following screen shot. For the Range Key (ReplyDateTime), enter a date 15 days earlier than today's date.
Note that the Range Key (ReplyDateTime) value shown is only for illustration. The date value you will use depends on when you uploaded the sample data.
The Browse Items tab shows the query result.