Hi this is Troy again, who is talking now about how can query being useful you can make a lot of queries New York for example, you can make query for the common news material or items and the list will be updated. Two, you can make query for unapproved we are too full of this abroad if you are and they and they get approved with approval of them. Number three, make queries of current p O's to to see the status of web Oh, it is finished and you can receive it. You can receive Zen's items or materials. Number four, you can make query for tomorrow's work. Or you can make query for this hedgehog How can we do this?

We will we will see in the next slides. For the items in an inventory, you can open inventory and they both have items separated by comma. In this example, we we bought the cartridge, the cartridge, the ink cartridge of the color, a color printer. And the woods is a number of items, number of each encourage cartridge. severity by Komal exists. If we run, you get this screen, the severity item of the ink cartridge and the balance of Zim this valance updated if you open the query, it would be less or more or more than you show him you see here Make multi use the queries if needed for each group of items and to see directly in once at once the current balance of Zim number two if you will need to see the VRS of this items, you can both items separated by comma and the item field here is the VR.

You can save the query by suitable name for all users for for yourself. Then it is the result represent the number of prs request contains this items. You can make the same invoices in Gordo's but also this items and see which which to our status, closed on the incentive FF means items were received the wiser warehouse if you wanted to make a query for tomorrow's work you have no code does Advanced Search both the smaller day target start both target start and target start finish for Christmas 170 it will give you the tomatoes or list and we'll repeat it and updated this every every day. You will you repeat this every day. He was there as well been said anything here. And it does start at the start from to the same date of tomorrow.

He wants to do this every day too good to get update. I'm just kidding. No, you will learn you have to do this. Automatically you write this SQL statement I attached with a video. That's the coolest statement you you don't need to write it and the both it and we're close from here. You voted here and this will give you the tomorrow work updating every every day.

If you want this each work, essentially if you if you work eight six strugglin it will be for the start system date plus one to start two plus seven. This is one week. If you want or to week to week, it will be system D plus 13. And also this SQL statement attached with the video Send you for any questions. You can contact me at crude oil@gmail.com or this is my cell phone bye