1 00:00:00,390 --> 00:00:07,530 In this video, we are going to read data which you can command from Amazon Dynamic DB table using this 2 00:00:07,650 --> 00:00:08,670 measurement console. 3 00:00:08,820 --> 00:00:11,340 So please open the console. 4 00:00:11,790 --> 00:00:13,580 Go to Dynamo DB tables. 5 00:00:13,590 --> 00:00:14,970 Open the order table. 6 00:00:15,000 --> 00:00:18,580 Click the explore table items and come this page. 7 00:00:18,600 --> 00:00:24,090 So now we can perform some operations on this order table because we have inserted two items in the 8 00:00:24,090 --> 00:00:24,930 last video. 9 00:00:24,960 --> 00:00:29,380 Now we can perform scan and query operations for these two items. 10 00:00:29,400 --> 00:00:35,640 So as you can see that if you click the scan button and click the run button. 11 00:00:37,560 --> 00:00:41,700 We can return all items we perform scan operation. 12 00:00:41,700 --> 00:00:46,320 So you can basically say, give me everything from the table. 13 00:00:46,320 --> 00:00:51,030 So we can also provide filter operations with scan command. 14 00:00:51,060 --> 00:00:56,780 You can see in here, if you expand these filters, you can apply some filter attributes. 15 00:00:56,790 --> 00:01:05,760 For example, we can say that attribute name is order, date and type string and we can use that greater 16 00:01:05,790 --> 00:01:09,750 than operation and we can specify in here. 17 00:01:09,780 --> 00:01:12,530 Let me copy this line and paste in here. 18 00:01:12,540 --> 00:01:18,450 So if we say that, please get me the greater than this order, right? 19 00:01:18,540 --> 00:01:19,610 Run this command. 20 00:01:19,620 --> 00:01:22,830 So as you can see that there is no item with that place. 21 00:01:22,830 --> 00:01:29,880 So if we select the different value, if you run this command this time, you can see that we can run 22 00:01:29,880 --> 00:01:37,490 the greater than condition over the order date column and also we can add additional operations. 23 00:01:37,500 --> 00:01:44,580 For example, let me run again and the filter which is the status column and we can perform that. 24 00:01:44,580 --> 00:01:48,170 Please get me the status with the value of the delivery. 25 00:01:48,180 --> 00:01:54,450 So click the run and see that the item returned for the status of the delivery items. 26 00:01:54,570 --> 00:02:01,920 So see that we have executed this scan operation with the greater than filter expressions and you can 27 00:02:01,920 --> 00:02:08,970 see that all conditions in here, there is a lots of condition equal to not equal to less than or equal 28 00:02:08,970 --> 00:02:11,100 to, greater than, equal to and so on. 29 00:02:12,120 --> 00:02:18,780 So everything that you seen in here is an attribute name type condition and the value. 30 00:02:18,870 --> 00:02:26,700 All these things can be done with the programmatically that we can also do it using the Ac-dc package 31 00:02:26,700 --> 00:02:28,010 in the upcoming videos. 32 00:02:28,020 --> 00:02:36,300 So it is good to know that A.B exposing all these APIs like scan command and query command, that we 33 00:02:36,300 --> 00:02:39,510 can provide the filter expressions with all these values. 34 00:02:39,510 --> 00:02:47,560 So we can call all these dynamic DB APIs, both from the A management console, a double Excel dynamo, 35 00:02:47,580 --> 00:02:49,320 the SDK and API. 36 00:02:49,350 --> 00:02:52,500 Also, we can do all these operations with programmatically. 37 00:02:52,530 --> 00:02:58,260 We will develop these scan and query command operations when developing our microservice lambda functions 38 00:02:58,260 --> 00:03:00,480 with using the SDK package. 39 00:03:00,600 --> 00:03:07,080 That's why I would like to show these pages in order to be familiar when developing our scan and query 40 00:03:07,080 --> 00:03:12,330 operations with the filter expressions, we will do all these operations with programmatically. 41 00:03:12,360 --> 00:03:18,090 So we have created the filter expression and pass the filter expression to the scan command and run 42 00:03:18,090 --> 00:03:23,850 this command and see filter value from this scan command, including the filter expression. 43 00:03:23,850 --> 00:03:28,770 So Dynamo DB take our scan command with the filter expression and return back to the result.