Thank you very much, Chairman. It's a pleasure and honor to be here together with my colleague Jonathan Taylor, the vice president, who is responsible, among other things, for the business in Ireland, and I can say very successfully, so that completes my speech. Thank you very much. I'm also very happy to be here. Tati is here, an old colleague from the bank. Ten years ago, he left Luxembourg, has not come back since, which is a big mistake, and I hope this will today be the beginning of the correction of that mistake. It's wonderful to be here and to share some thoughts with you on the recent positive developments in the European economy and the role we, the European Union Bank, can play to make it robust. I've been a frequent visitor to Ireland in my current capacity, but also in my old one, former one. Now reassuring of our growing engagement to finance long-term investments, and I have witnessed the incredible change through which this country has been going in the past. Ireland has faced significant challenges, but also has made valiant efforts to overcome them, bringing to a positive economic turnaround the country. This was confirmed and recognized when exiting from the international bailout program, and that was definitely not an easy task. Ireland also hosted a very successful EU presidency during the first semester of 2013, when important decisions were taken to generate jobs, create stability, and boost growth. The return to the international bond markets is a remarkable success for the country, but also for Europe, in tackling its fiscal and banking crises. And it is a very great encouragement for other countries who still have this decisive step ahead. In the same period, the EU Bank was called by its shareholders, the EU Member States, by the way, not the Commission, it's the Member States of the European Union who are our bosses. To increase its lending to support these efforts across all countries, but with focus on, let's say, burning issues. I will mention our engagement shortly. I'd like to take this opportunity to reflect in our debate later on the importance of looking forward. And the need to prepare Europe to compete at a global scale in the years to come. Ireland has key strengths that can act as a model for reform elsewhere in the European Union. However, the feeble signs of recovery we are witnessing, although encouraging, need to be strengthened. And we have to work together and solidify them. There are still too many gaps not only in Ireland, but across Europe that continue to hinder growth. The Irish government has asked the EIB to continue the proactive approach and address these problems together. The Bank brings not only cross-sectorial and financial expertise, but also widespread experience. Let me say a few words on the engagement in Ireland. To better understand the unique role and perspectives of the European Investment Bank, please allow me to first say a few words, however, who we are. And what we do here in Ireland and across Europe. Because probably the European Investment Bank is still the biggest remaining undetected treasure of the European integration process. That place is completely unknown. And Ireland has improved a lot over the last couple of years. But in my own country, the Bank for instance is rather unknown. If I tell people that we are as big as the German promotional bank, the KFW, which might serve a little bit as a model for a similar setup here in Ireland one day. If I tell people in my own country that the European Investment Bank is two and a half the size of the World Bank, World Bank Group, they simply don't know that. They are not aware that politicians on the European level have an instrument in their hand that can be used in order to promote the objectives of the Union and the objectives of the European Councils. And this is coming more and more to the fore. Many people have heard about specific examples of our recent engagement across Ireland, but few know about our broad involvement and unique features. The bank was created by the Treaty of Rome in 1957 as Europe's long-term lending institution. As I said, we are directly owned by the 28 member states, including Ireland and other world's largest multilateral borrower and lending institution. Last year we provided more than 75 billion euro for investment in key infrastructure, innovation and SMBs, with 90% of this being in Europe. 90% is a decision of the Board of Governors, which is practically the board of the finance ministers and looks pretty much like an ecofin meeting. The AIB borrows funds on capital markets and passes on the benefit of our AAA rating for long-term investment in a range of projects, public and private, with a balance of priority sectors agreed by our shareholders and reflecting EU priorities. The EU Bank is not a new player supporting Irish infrastructure. It has been active in Ireland since its accession to the European Economic Community in 1973. Since then, the Bank has provided nearly 13 billion euro for 403 projects across the country. Historic projects like Money Point, Power Station come to my mind, but also more recently investment in education and infrastructure are well known. 105 new and upgraded schools, Terminal 2, the bus is here, the East-West Interconnector, an investment at Trinity, UCD and Limerick universities. Over the last five years, AIB lending has provided more than 3 billion euro of support for crucial investment in Irish infrastructure and support for small companies. Especially during 2013, the EU Bank stepped up its lending activity in Ireland by more than a third and provided 680 million euro in long-term, low-cost loans to support key infrastructure and private sector investment across the country. This represented a 35% increase from 2012 and reflects our broader engagement across key sectors. Innovation, schools, entire education, energy, transport, telecommunications and not least small businesses in Ireland. We recognize the difference in the economic challenges and the investment priorities of the various parts of Europe. The economic cycles are far from being perfectly integrated. We also see that lessons can be shared to prevent past mistakes and save generations. Returning to Ireland's strengths, please allow me to make a few observations. Competitiveness remains a challenge across Europe and Ireland has clear assets that can act as a benchmark for others. Simply speaking, Ireland benefits from economic attributes that other countries in Europe would be keen to have and here I'm thinking of an open and dynamic economy that benefits from global trade, an established presence of foreign investors in growth sectors and a competitive service sector. Despite the negative implications of the financial crisis, Ireland has proudly regained its standing as an extremely pro-business environment that has just been recognized by Forbes as the best country to do business in worldwide. English is spoken worldwide, although we all contribute to ruin that language, in particular in countries like mine. And the Irish diaspora provides a ready-made business network around the world. Your highly educated workforce, corporate tax rate, investor protection and personal freedoms all score highly on global rankings. Therefore, it is not surprising why Ireland is placed particularly well on the global scales of business friendliness, let alone the global perception of the friendliness of Irish people which I witnessed in the pub here last night. Ireland has also shown true strength during recent challenging times. As I already mentioned, Ireland fully implemented the EU-IMF Economic Adjustment Program and last December successfully left the program being the first and so far the only program country to exit. Despite tough reforms, pay cuts, salary levies and depressed house prices, the solidarity and support of your people made it possible, proving that a quick although painful medicine can be very effective. Looking ahead, business confidence is slowly improving, employment is expanding and GDP growth projections are positive. There is a shared feeling across Europe as well as here in Ireland that we must not repeat past mistakes. This is why we are witnessing stronger financial requirements and calls for banking regulation, trying to set the scene for greater economic diversity, further integration and reduced reliance on the single sector. These are just a couple of examples high on the agenda of the ecofin and in the broader debate in the context of the imminent European elections. The current political and economic discussions reflect a clear need for economic stability after turbulent years and desire to address the feeling of uncertainty that remains, especially but not only in the periphery countries of the European Union. For this endeavour to be successful, all economic and political players need to work closely and create the institutional setting and mobilize financial resources to best unlock sustainable growth. Enabling sustainable economic growth requires targeted investment, let's call it smart investment, that will continually improve productivity. And there we have my main concern presently. Overall investment in many parts of Europe remains well below pre-crisis level. In many fields economic growth can only take place once there has been an acceptance of the existence of chronic under-investment in three key areas. One, skills. Essential for economic growth, skills need to be reinforced in the years ahead through improved education and training. Two, companies, both corporates and SMEs need to continually innovate to exploit new opportunities and keep ahead of the global competition. And three, infrastructure that influences the broader business environment must contribute to economic and social needs. All these require investment and a long-term focus on where Europe sees itself a generation ahead. I will address each of them in turn. Ireland is recognized worldwide for its dynamic, ambitious and high-quality workforce. Companies that are world leaders in highly specialized sectors choose Ireland precisely because skills necessary for the latest technology, pharmaceutical or medical manufacturing or research operation can be found. The Eubank recognizes the need to support investment in education and vocational training at all levels. In recent years we have supported the Irish government's significant investment in schools, working with the Department of Education and Skills to provide additional school places and improve education facilities across the country. I already mentioned that some 105 schools benefited from nearly 400 million Euro of EIB support in the last three years. By the way, this was a fascinating product we brought to the markets and which we developed together. I say it is so simple to say look at the only part of Europe that is really growing in population because of the birth rate. Look at the educational needs that go along with that. Look at the sometimes dismal situation of the school buildings around the country, not only this country but also here. And then look at the need to get people employed in SMEs around the country, on the countryside. So what is better than simply saying okay, let's refurbish a couple of hundred schools here with local craftsmen with a lump sum loan from the European bank to Ireland in order to accomplish that, that brings you an improvement in the educational situation as well as an improvement of the employment situation in the villages and in small towns across the country, not just in the capital. It's a wonderful project. At the university level we have finance campus development projects and investment in improved teaching and research facilities at University College in Dublin, Trinity and most recently in December, Limerick University. I must say that the University of Limerick has an ambitious development plan, 224 million Euro, which we support with a loan of 100 million. This is the best way to ensure that future generation of students will benefit from choice and opportunity and will be brought up with highest available technology for research and development, student support and teaching, sports and other facilities. The Irish government identified education as a priority sector in the government spending plan until 2015. This firm commitment sets the benchmark for other countries in Europe and the U-Bank sense ready to offer all necessary support. Later this year we expect to announce a significant new engagement, some probably 110 million Euro to support investment by the Dublin Institute of Technology and urban redevelopment very close to here at Grange Gorman. But let's be clear. The figures for research development and education in Europe or innovation in the broader sense are completely insufficient. We have a situation that in the international comparison for the last 10 years, the average share of GDP that goes into educational research and development is something like 1.9% in the European average it is something like 2.9% in the United States and 3.3% in Korea and Japan. Over a period of 10 years that has an impact and if we believe that we can remain the world number one technology provider from machinery to pharmaceuticals, from biochemicals to electronics where we have lost the battle anyway then we are making a very, very big mistake. So what we are doing here is just a small contribution but research, development, education in Europe must be given a huge boost in the next couple of years otherwise our children cannot live on the assumption that it can be taken for granted that their living standards will be better than the kids in ASEAN or other countries. Long-term unemployment for an entire generation of young Europeans is a threat to the ideals on which Europe was founded and there is no simple solution to sometimes a structural problem. Here in Ireland, youth unemployment reaches nearly 29% and this does not reflect the thousands of young people who have sought their fortunes abroad. Clearly, leaving the country does not solve the problem in substance. The IB started financing programs to ensure vocational training is just as needed as high-end research skills. Furthermore, financing small companies who create most of the jobs for the young people are a key priority for the EIB and we have ensured that intermediary Irish banks pass the funding benefit to the final beneficiary. Across Europe, the losses of jobs for young people could be observed at 85% in SMEs and only 15% in the public sector or in big companies. Therefore, it makes particularly sense to concentrate on SMEs also when it comes to the fight against youth unemployment. I mentioned several times the importance of selective investment or smart investment in infrastructure and we have recognized the clear focus of the Irish national infrastructure stimulus plan to increase both growth and employment. No country in Europe can afford waste to waste limited public resources on projects that, although creating jobs during construction, fail to provide real long-term benefits. Ireland has prioritized very well spending both during and after the economic adjustment program and it is clearly a success story. With its counter-cyclical role, the European Investment Bank was more than ever present in these times but there is still plenty of work to be done. Key sectors remain priority to ensure future growth. One, investment in schools to cater for demographic change and improve dated and worn facilities has been the focus and will remain to be so. Second, the water sector under investment in dated pipes and water treatment facilities as well as unexpected frozen pipes three years ago has required immediate investment. Introducing water charges for the first time is probably never a very popular policy however improvements are already being seen. The EIB will continue to support long-term investment in the water sector in Ireland. In the light of recent climate adversities we also stand ready to provide immediate support to repair key water infrastructure damages after the recent floods and heavy rains. Only two or three days after the worst floods this winter we were in contact with the T-shock and by the way also with the Prime Minister of the United Kingdom in order to offer our help. We have experience in that, we did the same thing last year along the Danube River when in Germany in Austria and Slovakia, Hungary the flood damages completely took over. In the transport sector as you know a handful of bottlenecks hinder road links across the country and tram connections here in Dublin. I met a taxi driver last night when I was driven from the airport into town and we had to go some construction place because there was something being done for Lewis and asked him what are they doing here. He said well they are doing what they should have done ten years ago. How can you build up such a system without connecting the two parts? And he said well that's why I'm here. So later this afternoon Minister Varadkar and I will formally announce new EIB support for the cross city link of Lewis to link Dublin's existing but separate light rail lines. I'm also pleased to confirm that we expect PPP funding for the N17 road project later this month. This will hopefully remove the last set of traffic lights between Balfast and Cork. Across Europe electricity transmission and distribution networks require upgrading. We need to continue linking the wind farms and to unlock economies of scale to improve interconnections between national networks. We are a little bit worried about that. Probably you won't find any wind park in the Baltic Sea or the North Sea or the eastern part of the North Atlantic which has not been financed by the European investment bank but sometimes I'm wondering where are the power lines that connect these places to the place of electricity consumption in the industrial heartland of Europe. This is still going to be a huge challenge ahead. I'll end two phases. Both challenges and opportunities in the energy sector investment by both the public and private sector and in many cases backed by EIB has helped ensure that private and business consumers will continue to access affordable energy and not face power cuts. Well, ladies and gentlemen, the need for concerted action and reform is clear across Europe, here in Ireland. Legitimate caution is gradually being replaced by optimism and the future is promising. However, challenges remain and the EU Bank will continue to provide its support to make this recovery optimally funded and robust. I'm looking forward to your comments and questions, your ideas, hoping to trigger also suggestions on where our support would be mostly needed if looking at the future aspiration of Europe. Ladies and gentlemen, we have always been drowning in crisis management over the last seven to ten years. It is time to do the last steps to finally leave the crisis behind us and then look into the future because whether we sometimes are aware of it or not, there is a life after the crisis. Thank you very much.


We were sent more Oraka Yu-Gi-Oh cards. What's up guys? We're gonna be opening up more Oraka Yu-Gi-Oh cards sent to us by orakashop.com. There's also a free giveaway by them for a Blue Eyes White Dragon and an Exodia Head Oraka. All you have to do is check out the link in the description for those and I'm gonna show you guys some of the stuff they sent us. We're also gonna be opening up a couple of Megatons. This will probably be our last Megaton opening, unless you guys really want to see another one, because we will have done a ton of them. But first, I do have a quick announcement. Next weekend, we will be opening every single 2007 tin. So we've opened 2002, 3, 4, 5, 6. It's time for 2007. This is the last year where they just had the standard 6 tin set up. So this is kind of the last every tin opening, unless we just do like the other ones that don't have 6 tins, but we have plasma vise. Rainbow Dragon. Volcanic Doomfire, not Doomfire Dragon. We've got Elemental Hero Grand Neons. I think I said Rainbow... Here's Rainbow Dragon. That was Sapphire Pegasus. So I'm sure a lot of you guys were triggered by that, but sorry about that. And we've got Destiny Hero Plasma. So inside we have, let's see, Horses of the Breaker, Strike of Neos, Cyber Dark Impact, Power of the Dualist, and Elemental Energy. So a decent array of packs. We'll be opening every single one of these tins in one video next weekend. It's gonna be pretty awesome, so keep your eye out for that. All right, let's get into the opus. So I'm gonna open up these Megatons, get the packs ready, and then we'll get straight into those orcas. Okay, so let's get into the orcas. We have the Quantity Discounts, 20% off for two cards, 30% off for three cards. So there's some in here. I'm not sure what order we're supposed to go in. Oh, wow. So Black Luster Soldier, Tune Black Luster Soldier. We're not gonna go through these all at once. There's three stacks. So let's do like one stack, a couple packs, second stack, you know, that kind of order. All right, let's see what these things have in store. Tune Black Luster Soldier. Let me know in the comments your favorite orca you see in the video, because there's usually some really awesome ones. And we will also do a giveaway in this video for some of the orca cards as well. We got the Tune Black Luster Soldier. We got the Dark Magician Girl. That looks pretty nice. Got that secret rare name. Dark Magician. Check this guy out, The Ultimate Wizard in terms of attack and defense. You can get all of these, I believe, on orcashop.com. So go check those out if you're interested. By the way, orcas are fake cards. They're not actual real cards you can play in a duel and like a real tournament, but they're very cool like alternate artworks they've made. Like this is not a real artwork, but they've made it. It's really cool. Oh, that looks incredible. Wow, that's awesome. I love that. Harpief Perfumer. So this is a real card. It's a proxy. So this one says proxy on it, which it's sort of the same thing as an orca.  So like if you didn't have the card, you could use the proxy. Harpist, okay. These are stuff to use in your deck until you get the real copy or whatever, or just if you want to test out the deck. Harpy Channeler. These are really nice. They look really cool. Harpy Lady. That's a really cool card. That looks awesome. Ooh, the Summon Skull and Jinzo. Oh my gosh, the anime cards. So they look like they do in the show where they have, you know, just the massive attack and defense, the level stars, the attribute, all that stuff. Do you like Summon Skull or Jinzo better? Let me know in the comments. Man, that's a tough decision. For the anime card, I think I like Summon Skull more. It just looks so iconic like this. Jinzo looks incredible as well. Oh, the Toon Black Rose. That is awesome. Oh my goodness. That is crazy. That looks so cool. Okay, that's some pretty awesome stuff. Okay, let's go into a couple Mega Tin Packs. Let's see if we can get that Crossout Designator. I only got two in my NRK, so I'm going to check that out if you haven't seen it yet. But I really like a third. And also, I need another Triple Tack. It's talents as well. So let's see if we can pull some of those. And yeah, so there's 18 cards per pack in here, which is a ton. So we're just going to grind through those real quick. Got the Tracktrip. Trap Tricks, Olimaris. Ice Dragon's Prison. We didn't pull the set of our whole case. I can't speak. This is a good, a very good Secret Rear. Burning Draw, okay. And oh, Titanclad. I was literally thinking all night last night, how do you pronounce this card? Is it Titanclad? Titanclad? Titanicclad? Let me know in the comments. I think it's Titanclad. Am I right? I don't know. Okay. And the rest of the pack, Linker Bell. That's a cute card. All right, next pack. I didn't really feel too good when I was recording the case opening. So I didn't really get to like... I just felt like I didn't get to observe the cards as much. I just didn't feel so... I didn't feel great.  So I feel a little better today. So I feel like we can have a little bit more fun with this set, Roland. We got the Rastabon. Tribugade Revolt. I think we got this a couple of times. Ooh, Gearsuit. That's a pretty good one. And a Researcher. Not bad. Not bad. We got the Union Driver. Rookie for hire and Linkburst. I was just trying not to cough the entire time during that video. I cut like a million times. The editing was annoying. That was just like... Let's open up these. All right, we've got the Archosaur. This is the card that's in the Megaton. So this is perfect. All right, let's check this guy out. We've got an Archosaur. This looks beautiful with the little dots. They're all very shiny. I like that. Looks really good. Chamber Dragon Maid. I know a lot of you guys like this one. All right, we've got the Ash Blossom. Special a Dragon of the Ice Barrier. That looks incredible. I really like this. That looks so good. Get a Diviner of the Herald. That's a cool card. We've got a Skystriker Field Center. Skystriker Ace Rose. Another Rose. Okay. Oh my goodness. I look like I'm in Ratatouille. I feel like I'm in Ratatouille or Wallace and Grumman or something. Let's look at it. If this card is normal special summon, you can add one petite moth from your deck to your hand. How am I supposed to be normal summon? I've got a million stars. 3,400 attack. I'm beefy though. Okay. This is a card right here. Now this is an Epic card. My set number is Ruxen-EN002. That's incredible. Oh, and a play set of Pecaneo Moth with Ruxen. Small but deadly creatures. Better off avoided. 4,000 attack. This guy's a stud. Check. Okay. This is the thumbnail. This is the thumbnail. This is incredible. This is so funny. I didn't know these were in there. They did not tell me. Look how off-center. Is this on purpose? Did you make me off-center on purpose? I feel like this is on purpose. No, and I have print lines too. Check it out. Print lines and OC. I know you guys did that on purpose. This is amazing. I love this so much. This is awesome. We're keeping this card for sure. Okay. We got to open the packs. That was unexpected for sure. I was not expecting that. That's good. I love that. That is such a cool card. That makes me happy. All right. Infernoble Knight. We got the Mutually Affair Destruction. I can't wait to post that on Instagram. We got to wait for the video to come out. Battle Survivor. Dark Lord. Arc Rebellion. We'll pull this a few times. Heavy Forward. All right. Come on. Heroic Seed. We've got a lot of this guy. Like four, I think now. AI Contact. Ooh, a talent. Yes. That's my third copy. Okay. Let's go. This card is so good. Guys, I read it for the first time last night. I'm not going to lie. The card is amazing. It's so good. I mean, it makes sense why it's so expensive now. Oh, yeah. And the rest of this pack, I've seen... Oh, that's a good common reprint. I kind of want to save the anime cards for last. Let's just go with the four packs in a row. It shouldn't take too long because there's a... There's not many... Well, there's a lot, but there's only four packs. You know, so it shouldn't take long. Warning Point. Noctivision Dry. That's a good reprint, too. Adamantipator Signs. Okay. I think it's like a dollar. Ooh, Fallen of All Bows is actually really good. It is a very good Ultra. And a Crossout. Yes. I got these from the locals. $30 tins. And I decided to open like a couple of them. And we got the Crossout. Nice. And the Fallen of All Bows. And the Ice Dragon's Prison. And the Talons. Okay. It's two different tins, but still, that's really... This card's up at $130 at the time of recording this, but it's only stores that can sell in TCG right now. So I bet it goes down tonight, which will be Friday for everyone. I think you're seeing this Saturday. So it'll probably be down from $130, but anyway, $130 is insane. That's just crazy. That's a great pull. That's the third one I need. So I now have a playset. Anything else I get I can sell. I don't want to sell the playset just in case.  Maybe I'll want the three, you know. So I want to hang on till I'm not going to have to pay $400 for a playset. Wow, this is some really good two tins. That's for sure. And I don't know if you guys have heard about the arrow with no Ultras. Thank goodness this is happening for me, but it's scary. I hope that that gets resolved for everyone because that would be an absolute bummer to buy a tin. If you guys haven't heard, have no Ultra Rare. So the Ultra Rare is where you get the Nobleman, or not the one, the Crossout Designator, the Triple Tactics Talons, the Zeus. All that stuff is Ultra Rare.  Ooh, your eye, Lord of Searing Flames. I'm a fan of these. I know a lot of people are not, but it's really cool. Norval, that's not a bad card. And Salvation. I like these New Dark Magician and Blue-Eyes cards. The Trap card for Blue-Eyes seems pretty good. It's like the Dark Magician card. I think it's Eternal Soul or whatever. Yeah, okay. This is going well. We got a Ruxen 34 back there. Gave us some luck. Crossout Designator. All right, let's get to the goods here. Melty of the Forest. Thunderhand. Dogmatic of Punishment. It's not a bad card. And... Now, I was like, did we get another one? Hot Eyes Revolution. Okay. I don't think either of those are very good, but we had amazing 210, so I can't complain. All right, final piece of the video. I don't think we're supposed to start with the red eyes. They usually do it where... I think you start with the back. We're about to find out. I already spoiled the red eyes. Sorry, guys. Here we go. Mirror Force. Okay, so they're not all hollow. These feel very interesting. They're very... They're kind of floppy. Mirror Force. Mirror Force. Should we duel with these guys? Duel with anime cards? That'd be kind of lit. That'd be fun. Is this a... Is this a different card than Trap Hole? Like, what is this? Bottomless? I don't know. I don't know what that is. Spike Hole? Oh, this is the... What is this card called? Nutrient Z. Yeah, Nutrient Z. I think you gain 4k, but if it goes away, you lose more than that or something. Or maybe you gain 2k if it goes away, you lose 4 or something like that. All right, we got a Metal Morph. That's a cool trap card. Okay, so far we've known all about one. Oh, the magical arm shield. Yeah, TP-8 Ultra Rare. Kunai with Chain. What is this? There we go. We know that one for sure. Grave Robber. All right, these are awesome. A Gamble? Is it Gamble? I think it's Gamble. Oh, the Fairy Box. You want to pay for that? That's a classic progression series meme. Drop-off? That's an annoying card.  There's a trap hole, so I wonder what that spiky trap is. I almost said spiky hole, but you know, that sounds a little odd. Ooh, we've got a Heart of Sanctity. There we go. Heart of Sanctity. Draw six cards from your deck. Pot of Greed. What does it do? I don't know. It could do anything. Monster Reborn. That's a good one. Very cool. Can use that in our deck. Polymerization. The anime art, but not the original English art. Oh, another one, just in case. You know, you need F3 in your deck. Oh, I thought we might have F3. Block Attack. It's a classic in the LOB format. Shield and Sword or Sword and Shield? I think it's Shield and Sword, and then Sword and Shield is the Pokemon in the games. Very confusing. Scapegoat. Okay, good for our go decks. Salamandra. Joey Wheeler. Let's see what Joey's got. And he's got the, uh, ooh, question. That's what it is. I was questioning myself. What is it? Lightning Blade. Legendary Soul. Oh, we ruined it. Foolish Burial, the original art. That's the Lost Art version. And Giant Trunade, aka, Hey Trunade, now. Okay. Silent Doom. Is this Silent Doom? It's very simple, Silent Doom. Oh, roulette wheel. Oh, this is the classic anime card. Do we ever even get this card in English? I don't know. Oh. Uh, Warrior Returning Alive? Is it Warrior Returning Alive? I can't remember. Oh, what is this? I can't remember. It's Gear Freed turning into the Sword Master. Is that what that is? I can't remember what that card is. All right, we missed one. Alligator Sword. We got the, uh, the mixture of Baby Dragon and the Alligator Sword. Alligator, oh no, so it's not Alligator Sword. It's Alligator Baby Alligator Sword. I don't remember. I don't remember what it's called. Thousand Dragon. We got Joey Wheeler in the house. The Legendary Fisherman, okay. The Sword Hunter. Rocket Warrior. Why did I forget that for a second? Panther Warrior. Oh, a high boost tonight, okay. There's a, there's a lot of cards in here. Goblin Attack Force. That's a good one. Gear Freed, the Iron Knight. Joey, so many Joey cards. Marauding Captain, okay. I had to think about that one for a second. The Red-Eyes Black Metal Dragon. Insect Queen. My Insect Queen. The Fiber Jar, okay. Ooh, the, uh, Blue Flame Swordsman. The Ephemed Mega Cyber. Gear Freed, the Sword Master. Battle Warrior. That's what he's called. I was like, what is this guy called? It's something very simple. Baby, Baby Dragon. Axe, Axe, Axe Raider? Axe Raider, not Warrior. Little Wingard, I remember him. Guilty of the D90s, a fusion, but in the anime, he's just regular. Flame Swordsman, also a fusion, but he just shows us a regular monster in the anime. Alligator. Is it Alligator, like Warrior or something? I can't remember what that guy's called. Soldzman of Langsta, that's a classic. There's the Alligator Swore, there it is. Ooh, we're getting to the Hollows. The Skull Dice, so there's like Joey's deck. Graceful Dice, this might actually be Joey's deck. Actually, I don't know what I think about it. This is definitely Joey's deck. Guilford the Lightning. Time Wizard. We got two more cards. We know the top ones, so this is the last reveal. Jinzo. So we got two Jinzos. We got a Jinzo and a Summon Skull at the beginning. And then we got Red Eyes, Black Dragons. That's pretty cool. We got a whole Joey deck. I didn't even realize that's what this was at the beginning. All right, so that's super cool. A ton of awesome orcas and proxies and stuff like that. And then of course, Ruxen 34, you'll love to see it. I look hilarious. I love this. It's so funny. If you guys enjoyed the video, make sure to like it. Subscribe. We're on our way to 100K. We're getting very close. Next weekend, all the 2007 tents. We're doing a lot of other crazy stuff between now and then and after and all that stuff. Before we leave this episode, I gotta thank you. Before we leave this episode, I gotta shout out my ultimate supporters on Patreon and YouTube. We have TCG trusted cards, Toe and Fosho, Stanley, Mike Nantz, and Mimic Gekko. Thank you guys for supporting the channel. And that's it for this video. I will see you guys later. Peace. I will jam.


Scouting for small grain insects in the wintertime is what I want to talk a little bit about. It's a couple of different insects that we are concerned about. We're concerned because of the aphids primarily because they are spreading a bad disease called Burley-Ellidwar virus. And we're also concerned about Hessian fly because it is a chronic pest and can be a problem. Now these insects, while they are different groups and belong to different taxonomic groups and are not closely related and damage the plants in different ways, they're very similar to the point that they have multiple generations per year. And the warmer it is the faster they grow. So in years with the warm winter, we could have extra generations of aphids. We could have an extra generation of the Hessian fly. So they're similar from the standpoint that they are active whenever the weather warms up enough. So later on this week we go, we're scheduled to be in the 70s, so we can easily have these insects developing there. I think they're in lower thresholds with probably around 50 degrees or something. So anytime the temperatures above that, they could be growing. So again here's a picture of Burley- Ellidwar virus. That's why we're very concerned about our aphids. We have a lot of information about managing Burley-Ellidwar virus. Austin and I and several others put together this publication. You can get this off the www.asis.edu and read more about Burley-Ellidwar virus. I'm not going to go into the details right now. I do want to point out that when we're out looking for aphids, aphids can look a little bit different sometimes because they do have wings on occasion. You can see all of these that have come in here have their wings on them, but they're also fully functioning adult aphids that don't have wings. And here are some pictures of some of those. So the bird cherry-oad aphid is the primary vector we believe for Burley-Ellidwar virus in our region and rice-root aphid can also bring in Burley-Ellidwar virus. Other aphids also can occur, but you're looking at these little little sacks of goo basically and you can tell they're aphids because they have these little most of them have these little tailpipes sticking out the back end relatively long antennae and so they're usually kind of like clustered in herds because the mother when she gives birth to her life young she may sort of stay in the same place with her babies so you often kind of see them if there's more than one aphid you may kind of see them in almost like a little herd of cows and they're sucking insects. Their aphids are sometimes hard to scout for because they hang out on the undersides of the leaves or they're feeding down at the bases of the stem in cold weather they move down to the base of the plant and they may be actually down below ground and when wheat is small it's a long way down to get to that wheat so it is sometimes hard to scout for because you've got to kind of crawl along and try to see the aphids. So therefore we basically try to predict the risk about having barely illidwar virus from the work that we've done in previous years because it's often you know not economical to scout the small grains as often as you would need to technically to try to figure out what was happening with the aphid populations. So we know that the earlier that wheat is infected the greater the yield loss we're going to have from barely illidwar and it's corresponding to say serial illidwar virus. So we're worried about this thing mainly through the end of February first part of March. Beyond that there's no point in putting out an insecticide and trying to control the aphids for to protect your yield from barely illidwar virus. Generally we're worried about controlling those aphids early. So historically we can make a few general recommendations but of course this year when we everybody planted late directed things sort of go out the window but generally our recommendations are if you're going to be planting small grains during the recommended planting date for grains a seed treatment or a foliar spray 30 days after planting is going to be what pays off more often than not in North Alabama. In South Alabama it's generally that late winter spray late January early February either with or without fertilizer seems to be when it's most likely to pay off and with all of our late planted wheat that's going to be the time to be applying the spray for growing the illidwar virus if you if you have the money to sort of put on the spray. Central Alabama is and when we're planting normally and late October early November it's got it could have time and be warm enough for the substantial development in the fall as well as in the winter so sometimes the optimum situation for Central Alabama may be to spray twice and we really may not be able to afford that but spring either either 30 days after planting or as the aphids are picking up and starting developing the in the late winter either one was better than not spraying at all but what too might be optimal. So again with this late planting that we're looking at this year where most everybody got there got their plants in late we'd say that probably the we would recommend putting on a spray in late January or early February. Barley illidwarf is one of our biggest would you say Austin sort of unrecognized disease problem that we have. Yeah the symptoms are not real clear cause that's the problem. Right. And we, you know, Odes and Barley it will jump out at you. Right. It's really hard to tell. So you could be having yield loss not knowing it and by the time you see the symptoms it's already spread so this is why it's a tough thing and so normally I don't tell people put on sprays just on a routine basis if anybody who knows me will know that but this is one of the exceptions that I think that everybody if you're going for high production we ought to be putting on one spray for a Barley illidwarf virus and that we sort of hedge our bets based on historical data when the best time to put that spray on is. Having said that if you can go out and look for wheat at in the wintertime you may find that you've got an unexpected number of aphids even though you did have already sprayed. Our thresholds are generally if you're out looking if before the weed has started to elongate if you've got six aphids or more per square foot per row foot or once the stem's starting elongating if you're finding two aphids for stem. Now if you're going to go out and scout for aphids you want to go out when the weather is nice and that's for several reasons. The insects tend to be hiding hunkered down when it's cold and you're going to be cranky or at least I am when I go out and try to look scout for aphids it's 40 degrees and I'm freezing to death. I'm not going to do a good job crawling on the ground counting those aphids and you aren't either. So what you really want to do is pick a nice day you know above 60 degrees the insects will have crawled up if they're going to bite the middle of the day and that would be the time if you're going to go out and look for aphids that would be the time to do it. Now we have a new kid on the block which is called syphomatis the common name we're hoping to be is going to be the hedgehog grain aphid because this little aphid has got little spines all over it. Here's mama here and these are all her babies you see these little herd of they kind of occur in herds. Generally the babies are kind of amber colored the mother is more blackish colored and if you look at them with a hand lens or a microscope you'll see that they are they do have these hairs all over them. This is a new aphid we know it's curing throughout central Alabama we don't know with what kind of role it's going to have in terms of making her early yellow dwarf problem worse so if anybody's out looking at their wheat and they happen to see the sapid please let me know or one of your extension agents let them know about the sapid. So the other thing I want to talk about is that now's a good time to go out and just look at your wheat and assess the general health of the wheat. You want to be out and looking to see and hopefully we're not going to have problems with Hessian fly. Hessian fly like aphids the earlier you plant the more likely you're going to have a problem with this multi-generational insect but it can occur on any different kind of planting date. What you want to be looking for is you just want to start looking for plants that just don't look right. So I want to point out that so it's sort of your normal wheat it looks like the here's one here's the sick plant right here. Can you see how this leaf the base of the the middle part of this leaf blade here on this plant is not even above the ground here so it looks like the leaf blade is sticking right out of the ground. That's just it's just not growing right when you go out and you look at a field that's infested with Hessian fly that's going to be probably be your first assessment is this field just doesn't look right. Here's some more here's a close up you can see how these leaf blades look like they're trying to come out of the ground to kind of bunch together and they're kind of a blue-green kind of dull greasy color here's a nice clean happy plant over here with the leaves coming out and we see the leaf sheath comes out here and then the leaf blade sticks out I think those are the terms. Here's another one can you see that wide blue leaf blade there kind of a thin stand again wide blue leaf blade coming right out of the ground that's assigned that that plant stunted and not growing right. Chances are the problem it's going to be Hessian fly although Leicester Ford star four can also have this look so this is what you want to have you want to have your you know your plants leaf sheaths coming out of the ground and kind of but here here the leaf blades are coming right there at ground level just doesn't look right here's another one here's another one here. Here's Rudy Yates out there in a field that was heavily infested with Hessian fly one of the problems that you can get when it attacks early is it can kill the plants outright especially it's a cold step they finish them off with their kind of lingering on and weakened for Hessian fly so this is a field that was badly damaged very thin stand. This is what the Hessian fly looks like if you start looking you're going to be pulling your leaf sheath away from the base of the plant and start looking for the larvae which are these little white things with a green line going through them or these are the pupil stage right here. Here's another example was kind of showing you here are the larvae here are the here are the pupae that where we pulled the leaf sheath away and there they were there was a bunch of them so how these got down here is that the adult Hessian fly lays her eggs on the leaf blade and then that little maggot hatches it hatches out and crawls slowly down and then down behind the leaf sheath and goes down as far as it can go so before joining your courage it's going to go right down to the base of the plant as far as it can go behind that leaf sheath once the plant starts to joint and this little maggot is crawling its way down and gets stuck at the joint so as later in the season the Hessian fly infestation and where you'd be looking for Hessian fly will change just because it that you know they the infestation proceeds further up the plant and as the plant grows so here it's just you know here's the point we just doesn't look right in the back here's a resistant variety here that's growing nicely and here's a variety here that's badly infested with Hessian fly and you can see that there are very few heads out there here's some real life examples out there and in some fields unfortunately we had a bad epidemic somewhere around 2009 2010 most of these pictures are from that time again this week just doesn't look right lots of dead tillers that's another sign later on the thin sparse stand and the dead tillers are signs of Hessian fly stunted plants we doesn't supposed to be this thin or this short it was just a bad Hessian fly year this is what the adult looks like it looks like a lot of other flies so if we have them in a pheromone trap that's with it was something attracting the adult flies and we have just a few flies on that trap we can kind of pick out what they look like little beaded antennae here and long legs like a mosquito one thing is that when they when they bleed they bleed red and I'm pointing this out because it was this is a sad little fly that was trying to get off this sticky trap and it tore its foot off and it bled this little red female it's blood but red that's just a sign I want everybody to try to remember their red color anyway those adults come out they lay the eggs on the leaves the eggs up hatch little baggots go down to the bottom of the plant the problem is is that when we're trying to control Hessian fly they are protected in the plant for most of their life so it's really hard to spray them with a foliar insecticide all we can do is try to get the adults when they're out flying around and laying eggs the eggs or the little maggots as they are hatching from the egg and crawling down the rest of that plate to go behind the leaf sheet so we have relatively right nearer window if we had tried to spray for Hessian fly rescue may be possible but we're best going to be controlling Hessian fly by decisions that are made before planting and I'm just going to go through these briefly it's a long list all of these are just designed to reduce your problems avoid continuous planting of wheat in the same field because the puppy over summer in the field so if you come right back in the next fall they're going to say thank you I'm here and ready and thank you for putting wheat back in my field so like the Hessian fly resistant variety control the volunteer wheat which can be allowing the flies to build up early in the fall like in September don't plant your wheat before the recommended planting date if you're going to use grazing try to plant rye oats or a Hessian fly resistant wheat because generally all these grazing things are planted early that can allow the Hessian flies to build up early and then fly into the great wheat produce for grain as an entomologist I love flowering to vary the wheat debris especially right after harvest lots of people can't do that but if you can that kind of varies those those puppy don't use the susceptible week for wildlife planning I think this is pretty huge because wildlife plantings are put in early and what can happen is that the you can build up your Hessian flies early that picture of Rudy Yates out there in that wheat field that wheat is out in an area where there's lots of little wildlife plots scattered around that build up the Hessian fly that's sort of a chronic hotspot if you're going to grow a susceptible week consider using a high rate of an insecticide seed treatment or spraying the foliar insecticide at the two leaf stage to try to control that early early infestation which is the most devastating those are some of the IBM recommendations we have but if you get to the point at this time of year you go out in your field and you say this week just doesn't look right well then start trying to think about how many of these stillers don't look right start pulling leaves back and looking for the flies and if you've got a thin stand or if you've got more than 20% of your tillers that are infested with the Hessian fly your yield potential is seriously compromised for that field because we're not only talking about what's already happened but the fact that there can be another generation of the Hessian fly coming along so that nitrogen application may not pay off so the decision might just be to think about just saying I'm not going to harvest this field so or I'm not going to put the nitrogen application on I'm going to save my inputs and just harvest it for hay or something so that's one thing to think about is is at this time of year is am I am I so badly invested that it's not worth going on now it may be possible and so we've had some luck here and this data from North Carolina years ago that you might be able to rescue a field if you go out at this time of year and you find you've got some maggots or you've got some few feet in the field and it's you know 5-10% or even 20 but you really think that this field's got potential in terms of being a good stand and you're willing to go out a couple times a week while during this stage right now or you know and keep an eye on the development of the Hessian flies so they don't always they're not always all in the same stage but they are sort of pretty much clustered so when you go out you're probably going to find there either like late-stage maggots or their pupae now you're going to want to spray the pyrethroid insecticide when these adults are starting to emerge how do you know when the adults are starting to emerge when they look like every other little fly out there in the field well what you can do is you can you can squeeze the pupae so you see these brown things here if you squeeze this and it's mostly white it means that it's close to being in the stage this larval stage this is the stage where it transformed from the larval to the adult but if you squeeze this pupae and it's pink you remember how I showed you that picture of that hessian fly adult on the trap with a little bleeding the little pink hema lymph when you're squeezing these pupae and they're starting to be pink that's a sign they're getting closer to the adult stage and they're more likely to be they're about to be coming out that's the time when the pupae are faked is kind of start looking for some eggs on the plant to what you maybe want to see a few of the eggs or what you just start seeing that these pupae are turning pink a little wait a few days and then that would be a good time to put on this rescue pyrethroid spray if you're going to try to do that in the field here's a picture of the eggs they're kind of hard to see they kind of glisten they're about 130 second of an inch long takes about three to five days for them to hatch so you see if you start seeing them seeing some eggs there on the field on the leaves I think if you spray that residue of the insecticide is going to be on there and as season larvae you're making their way down they're going to be impacted by that so that's if you're going to try to do a rescue spray for your hessian fly so there's a lot of information about this if you go to www.asis.edu or you go to alabama crops.com just search on hessian fly and what you're going to be looking for we have a fact sheet on the hessian fly and we also have a time the information sheet on how to scout for the hessian fly in the winter time there will be some more information for you so here's a fact sheet that I was talking about that you can find and anybody have any questions one of the things you mentioned egg food plots and wheat would be better if we encourage people to grow oats or would maybe probably be a better choice rather as an early I think so yes rather plain wheat yeah I think so as far as as fashion fly especially in these areas or spots where there just seems to be a chronic hotspot for it would that might make burley elendor for us that's the only problem but they're sort of a host for all the small grains are a host for burley elendor yeah so I think it may not matter they got a plan earlier yeah I don't like seed wheat planted early for yeah particularly for hessian fly they go out with a I would think a susceptible variety and have a large buildup yeah on September planted wheat and then as you said before then you have wheat fields in the general vicinity you're just flooding that will fly that even if they're resistant you're you're pushing yeah you're putting pressure on that resistance that's right so it's all a numbers game with hessian fly it's just that you know how much pressure are we going to have and one thing that Brenda Ortiz found out working with some historical data from David Button was that there are certain years that are going to be more conducive to having problems with hessian fly so the La Nina phase of El Nino where we're going to get that warmer drier winter it's going to be favorable and also what was very critical is if there's some rain going on in the in the early fall and from anywhere from late August to early October there's rain during that time and the biological reason for that is because if you get rain at that time it's a signal for those hessian flies that were over summering in that pupil stage for those adults to emerge and come out and start the generation so those are sort of two times we know so if you're thinking if you want to know when the greatest risk is going to be it's going to be in those La Nina years when we have a little bit of rain this year we had didn't have rain during that period so that's one thing that sort of led to a probably a lower infestation and the lower risk for hessian fly this year even though we're technically I think we're in the La Nina phase so it's going to be sort of warmer and drier you wouldn't know it from how much rain we've had in the last week or so


Hello, everyone. I'm Sanjay Gupta. I welcome you on Sanjay Gupta Tech School. So, today we have one more session on Salesforce Omni Studio. And this session will be based on data raptor scenarios. So, last week we did one session, which was also based on data raptor scenarios. And for this one also, we will be doing the same topic, but totally focusing on the scenario implementation. And for explaining all the concepts, all the scenarios with you, I have Abhishek with me. So, welcome Abhishek on the channel. So, as you all know, like last year Abhishek explained all the concepts along with few scenarios. But then we decided like this year, let's do all the sessions together where we will be just focusing on the scenario implementation. Right? So, that's why it is season two. And if you follow all these sessions, so you will get to know like how different scenarios you can implement with the help of data raptor IP, Omni script and Flexcard. Right? So, with this, like I pass it on to Abhishek so that he can let you know about himself. And then we'll start the session. Over to you Abhishek. Yeah, thank you Sanjay. So, hi everyone, myself Abhishek and I'm working as a Salesforce Velocity Developer in this community since five plus years. And I have done some certifications around Velocity or Omni Studio, which is first of all Omni Studio Developer. I have some industry specific certifications as well like one is industry CPQ and other is a health coding developer, which is from Velocity. And I have done some few certification on Salesforce core as well. So, that's about me. Okay, so that is impressive profile and like I can see a couple of updates from last year. And I hope this year also you will do a few more certifications. Yeah. Okay. And if you want to become part of a community where Salesforce freshers and experienced professionals are connected so you can scan this QR code. It is a QR code for telegram group which you can join. And if you want to provide some feedback or any reviews about the bootcamp so you can share your thoughts in the comment section of the video. So with this like let's jump on to the scenarios now. So we have three scenarios one by one like Abhishek will be implementing them so that you can understand how these can be done with the help of data adapter. Yeah, sure. So today again we're going to implement some scenarios from data extract only. So first scenario that we have into our picture today is where we will be fetching again account records, but we will be doing some sort of ascending descending and limit as well. I mean like the exact number how many records we want to fetch. And then we will fetch the records from data extract which are related to each other in various various ways. So we will be playing around account and contact object which is related to each other, but we will be playing some we will be having some. I will I will implement this scenario in various ways so that we will be able to identify identify how to work with related records and from different requirement how to implement those requirements. Let me jump on to the this is the. So I think for these scenarios you will be creating new data actors yet. So our first scenario is fetch ID account name and annual revenue right account name revenue of five account records and sort it into the ascending order. So we'll go to the data actors we're going to create a fresh data actor or data extract and name it as let's say. So I think we can add sort word so that it will become. Yeah, so simply we want to add the extract step and which will be account. Here we're going to say accounts to the result output json part. And here we're going to use our where clause. So we don't have any where clause or what we're going to do here. I will say where name is not equals to null. Okay. And now we were saying we want to fetch five records. So for that we have this limit limit functionality into the data actor where we can say give me only five records. And another thing that we want to that we want to do is we want to fetch it into the ascending order right. So we're going to click on the order by and in the order why we have to specify first of all from I mean like from which field you want to order by this. So we're going to say name and it should be in ascending order. So that would be ASC. The way we write into the into our SQL you're going to write it into the in the same manner. So what this extract data extract will do it will fetch the account records where name is not equals to blank. And we will be getting only five records and those five records will be into the ascending order with the name field. So if I go to output and let's say I'm going to fetch the name and if I click on preview click execute. Yeah. We need to check name whether it is having ID. Yeah. The first time that we that was that was getting extracted. Yeah. Maybe I think we can check through list view. It will be. Yeah. Okay. But can we do the. You know I think we cannot do this right. No. No problem. This is the account that is getting fetched and the account name is edge communication. So that is fine. Then why we are having the collect me for some other field. So let's say this is giving me the correct output. And what if we fetch ID also. Yeah. So IDs are different from name. Something wrong with this. Yeah. So I think for few records maybe ID is populated in place of some name because it is in sequence. If you see one GV RW six AD seven AD five. So I think this ID is. They are in the name field. That's why it is coming like this. Okay. So if I let's do let's do this thing. If I order by this one with the active field. And now if I click on execute. So now it is. Yeah. But now the data from active is not coming. Yeah. This is some data problem I think so but what we're going to do we're going to execute this query into the developer console. Actually active is not having some value. Yeah. Okay. So what we're going to do let's we will reverse this order. We're going to have in the descending order and if I click on execute. Now this is coming me. Yes. Right. Right. I mean when we were ordering it by the name in the name field we were getting the ID. So that that is the issue with the detector because it's working with the active. So we can we can skip that part but now we can see when we are ordering the all the records with the active field. It is giving me just values first and after that it will give me the no value because we have we are we have added order by with the descending order. Right. Yeah. I think that that should be it for this scenario. The second scenario is fetch ID account name and annual revenue of accounts where active is equals to yes and also fetch first name ID of contacts where email not equals to none. And another thing which is added to this question or scenario is both will be fetched in separate lists and there is a hint also that it should be it should be parent to child query. Yeah. So again for that what we're going to do is we're going to create a clone. I mean we're going to create a new data actor. Let's say clean to child. And we can say contact and we already have account and the where clause that we want is active should be yes and. Yeah. For the account only active and for the contact we have the email. So here we're going to say active should be equals to. Yes. And we don't need this. We can remove. And another is we want to also fetch contacts to contact and we're going to contact. So here we can do two things. There can be two scenarios. First one is contact can be independent from the account list. So let's say I'm fetching the records from accounts and I'm also fetching the records from contact. But I'm not defining any sort of relationship. But if we think in real scenario that will never be the case because if we are if you're trying to solve any problem or a business use case we will always. Fetch the records which are related to each other. Right. Right. So for that what we what I'm going to write is I'm going to say account ID. Is equals to whatever accounts we are fetching from the above. Account first of all data actor will fetch the account and then data actor will fetch the contacts but it will fetch only. Contacts which are related to the accounts which we are fetching in the step one. Yeah. Right. Okay. And according to according to the question we have to add one more where close where we are saying email is not. No. Same thing we're going to say email is not equals to. Plan condo. And in a question it was saying that we should be able to fetch the account and contact records into the separate list. Right. So I'm going to go to the accounts and we already have few mappings for account. But. We want into the separate list so I'm going to say I'm going to add account colon before all of them. So that it will create a list for them. So for account there will be separate mapping and for contact there will be separate so that once we'll be receiving the output so separate headers will be there. Right. So right now if you can see account we are having into the account array. Right. And now according to question we want to fetch the contacts into a separate list. So we're going to say account ID. And into the account contacts list. And let's say I want to fetch one more field from conduct which would be the last name. The last name. And now we can see in the output json path we have two array list. First is account second is context. And if I go to preview and click on execute. We are having the contacts separately and we are having the accounts separately. Right. Right. This is what we we meant by the separate list into the scenario. But again, like as as we have discussed that if we are fetching the contacts which are related to each other right. Then if I go to preview and if I see this output I don't know. I mean like if I want to make this data more useful then what should be the case let's say if. Okay. Let me go to this account. And we have them. So in this account I have three contacts right. And which one is coming. No I think it was parent to the child. Yeah. So this is the Dick cruise one. So this is the one right. If I'm added one more contact and if I add the email ID that contact will also will be coming. So let's say save it. And again if I go and click execute I'm going to receive three contacts and save number of accounts. But now if we see this Edna Frank and this list decrease is from the same account. Right. And I mean like if I want to make it this this data more useful. So what I would be wanting is that all the accounts of sorry all the contacts from the United Oil and Gas Singapore should come under this node only. Because right now we if we want to show this data into the lecture in some sort of LWC structure. We will we will have to add one more logic where we will be you know comparing the account ID and the contact ID if you want to show it into a structured way. So this data is obviously useful because we are only getting the contact which are related to the accounts. But it's it's it can be we can make it make this data more refined. So for this one we have we have the third scenario. Third scenario is saying that we will be doing the same thing but it should be into the same list. Okay. So for that one first of all what we can do is so basically what we will do is whatever data we are fetching into fetching for the contacts. We're going to make the same mapping for the output. So we will not we will not have the separate list for the contact. Okay. If I go here contact sorry account. So now what will happen whatever data that we are receiving it is coming under only the account node. Right. And now if I click preview and click execute you can see we have this account here. We have this account again. We have account information along with the contact and yeah together. Correct. So it depends like whatever number of contacts we are having so that many time. Yeah. Accounts are being displayed. Correct. But there is a problem here if you can see. So if I go to query result I am able to fetch five account records and I think sorry this is there and three contact records. This was this is query time. Sorry. So we have the five account records and three contact records. If I go to result it has created 15 account records. Okay. Five into three. Correct. So basically the output that we wanted that all the contact records which are related to United Oil and Gas should come under this one only. So right now what it did whatever whatever contact records we are fetching. So let's say this Edna Frank this Edna Frank is added with all the account records. So if you see we got the five account records Edna Frank is added with all the accounts as it is this this this and this. Yeah. It is one one contact is added five times. Correct. Correct. So this is not our desired output. So what data after trick that we can use it to use here is we're going to use this. So what is whatever is the result path for our account right. We're going to add it to the contact result part like this. So now what will. Okay. I'll just execute first and then I'll tell you what trick data after it for incorporating this one. Here we were saying with the account ID. Now what we have done we have changed the extract output part. So we have to change into the extract JSON path as well for the contacts right. Only for the contacts. Only for the contacts. Yeah. Last one. If I go click execute. If I go here. Paste my data. So here what we are what is happening. Just a second. With this as it is account new to we didn't have anything. For this one we don't have anything. But but for the United Oil and Gas Singapore. We had to two records. First is this one and second is the decrease. Or and the third one is the Edna Frank. Correct. And with this Abhishek as it is one we again don't have anything. So what it did. I mean like. Whatever account. Whatever I mean like the contact which is related to the account. It is added with that one only. It is not getting multiplied. So. For that one. Now what is happening. Let me tell you that. And for if you want to make it more refined here. What you can do is. Into the output JSON path. You can say contact. So it will be creating one node as well right. We'll do one more thing. Now if you see we were getting five account records. And in the result also we are having the only the five account records. And with this United Oil and Gas Singapore. There is another array has been created for the contact which is a sub array. And in this in that one we have three records. Three contact records that we are fetching. So if you see. The first result was not at all useful. The second record what the second format was useful. But it the account was getting repeated three times. But here what we are doing account is coming for only the one time and contacts are getting into the. Into this account node as a sub node. So this this is more useful. So. What data raptor is doing here data raptor is saying. Whenever whenever we have added this. Extract output JSON path into the contact. Extract output JSON path. So what will happen let's say first account is coming which is. For example let's say as it is account new too. Then instantly it will go to the second step. Previously what was happening it was extracting all the account records first. Then it was going to the contact records. But now data raptor can see that in the result JSON path of contact there is a dependency of account. So what it will do it will first execute all the first account record then it will go to the contact. And it will fetch all the contact records related to the first account. And it will this cycle will execute until the account records have been completed. In the output JSON path what we are I mean like left part is very understood. I mean like it is very simple where we are saying whatever result JSON path that we had for the account. It is accounts for the contacts it is accounts colon contacts. So this is simple but here one trick even two tricks that we do first we didn't edit this contact colon after the account. So what it did if we were fetching the let's say related to one account we are having three contacts. So JSON node was getting created three times for that account. But as soon as we added this contact list or contact array in between the account. Then what it did it didn't create the three objects instead it created only one object for the account and created another object for the contact which is an array. So this is this is how data wrapper plays with related records. Right and this this can be called as parent to child query. Yeah. And we will be we will be having one more example for this one only where we will fetch the record from child to parent. Okay. So primarily we will be applying on contact through that we will fetch the accounts. Yeah. Account information like which which is related to that particular contact. Correct. So what I mean like for understanding this example it might be possible that you have to watch this part again and again because this is a bit confusing but you will get to understand when you practice it. Let's jump on to the last one where we will be saying it should be from child to parent. So here we will replace it. What you want to do is you want to do this one only and when we are going from child to parent you don't need to query the account records or the parent records. Right. Through child only we will be able to fetch the parent information. So I'm going to delete this filter and in the output I don't want this. Yeah. I think an extract tab also we need to do minor modification. It is accounts colon context. So I think we can do this context. Right. Yep. And this one. So I don't want this and I don't want this and here also we will be making this change. Yeah. Contact. And remove this. Let's say first of all I'm going to get the last name only. Sorry. This is account ID. Right. Yeah. Account ID is fine. Okay. I'm going to say it account ID only. Remove this. Last name. And what we are doing is we are fetching two fields. First is account ID and second is last name. So this contact was not related to any account. So I mean like it didn't give the account ID and this one is related to the account. But I mean like if we think according to the data model, this account ID is a direct field on the contact. Let's say I want to fetch some some account field with the help of child to parent query. So what we're going to do is for that one, we're going to use our relationship name. So when we write the query, when we are we when we want to fetch the account data from the contact, we usually do select ID, comma, account dot name, account dot active. So here also. Till this part, it is fine. Contact call an account ID. But if you want to move to some parent record field, I'm going to use the relationship name. And after that, I'm going to add the dot operator. So you have to give some a bit attention here. Till this part, we were using the colon. But if you want to fetch the field from the parent record, you will we will be using the basic rule which applies to SQL queries with the dot operator. And here we're going to say, let's say I want to fetch the active field. The API name of the parent one. And you want to see context or the contact colon. This is up to you whatever name you want to be insecure. So active may be not having any value. So that's why. Yeah. So what we're going to do is let's put. Yeah. Instead active, you can use name. Oh, okay. Sure. Because of this one, this is context, not contact. Now here we go. So we have the account name with the child, child, child object records. Yeah, I think it is similar to SOQL and the child to parent SOQL. Correct. I mean, whenever we are, whenever we are using the custom objects. So that would be like relationship name underscore underscore R. Okay. We need to use. Yeah. So that's all for. I think today's session. Yeah. Yeah, I think you already covered all the scenarios and like this number two and number three are a bit confusing. So guys just was the recording once again. If you have any problem. So if you go through once again, you will be having better understanding. Okay. So I think we are good for today. So thank you Abhishek for sharing your knowledge. So I think we need one more session for data after. And then we will be jumping onto the IP. No, I think data after two more sessions, two more session would be, but let's figure it out. Okay. So maybe next week we can complete the data rector part. And then after that, in fact, we can pick IP flex card and omiscripts. Yeah. And guys, we are planning to do some end to end project also. So they are all, all the components. We will show you how you can relate and implement. Okay. Keep on watching the series so that you, you can do some hands on with Omni studio and this skill is very much demanding in the market. So if you want to upskill your CV, so just practice Omni studio and have it in your CV so that you can impress the interviewer. Okay. Thank you. Thank you guys for joining the session. Thank you Abhishek for sharing your knowledge. See you in the next session. Bye everyone.


So after those five propositions on your ballot, Proposition A3 for the Bonds, you will see starting with Proposition F, 13 proposed charter amendments. Charter is not generally a topic that is particularly interesting. I'll do my best to get through it quickly and informatively. So as Roger said, back on February 8th, Council adopted the elections ordinances, both the bond election and the charter election. Charter elections set for May 7th, excuse me, they're 13. Per state law they have to be lettered, so they're F through Q, they pick up right where the bond ones left off. There are total 13, the one you've probably heard about is the Mayor and Council pay, and then there are 12 technical amendments. All 13 are topics that had previously in 2016 been sent to a charter review task force and recommended for inclusion on the election. 12 of those 13 did not make the prior ballot, so they're being picked up now. So as I said, the one you've probably heard about already is the pay for the Mayor and Council. What is proposed is, I'm not going to read the entire ballot language, but I do encourage you to read it closely when you're voting, that what's proposed is for the Mayor's annual pay to be one half of the average for the base rate salary for department heads, so it's across the city, and then for all the other council members to be one half of the base rate salary for all of the assistant department heads. So currently we have fixed numbers in the charter for those salaries for the pay. Mayor is 29,000. The other council members are 25,000. The other large cities in Texas that have a manager council form of government, so Austin, Dallas, San Antonio, their pay rate ranges for their council members from 45,000 up to 83,000, and for their mayors from 61,000 up to 97 and a half thousand. So 29 and 25, obviously a little bit outside that scale. Rather than proposing a fixed number again, the suggestion was made to have an index to say let's make the salary tied to some other pay in the city so that we don't have to, as time goes on and salary rates change, we don't have to go back out to the voters again. When we go out to the voters to hold an election, if the city is the only one on the ballot, it's about $500,000 for the city to hold an election. So this was kind of a way to try to address the issue, keep it in line with city pay, but also not have it fixed in a dollar amount where it requires going out repeatedly as they become stale. So as I said, for the mayor, one half of the department head, for the other council members, one half of the assistant department head. So if this were adopted, then as the council adopts and reviews the budget for each year, they would actually set their salaries. But the actual base rate pay is for all of the department heads and assistant department heads in that coming year, and it would be one half of the average of those. It's an index, so it changes from day to day, because, for example, our Human Resources Department ran numbers on January 18. And based on those numbers, the salaries would have been the pay for the mayor would have been 99,653 and the pay for the city council members. Yes, 99,653 and for the other council members would have been 76,727. They ran those numbers again today, and as of the people who are in those positions today, mayor would be 99,967, so up a little bit, and the council members would be 74,520, so down a little bit. Again, it'll be a point in time calculation each year as the budget is adopted. So the other key point when you're looking at a charter amendment is to identify where there's a fiscal impact. This would obviously have a fiscal impact going from 29 and 25 to one half of the department and assistant director, respectively, for nine council members, assuming those numbers that I gave you originally are first run on the numbers on January 18. The total for the nine members, starting in FY23, all nine together would be $484,469. So that's the difference between the 25 and 29 versus one half of the numbers I quoted earlier. When fiscal year 24 rolls around, we will have 11 council members, so obviously that's two additional council members impacted. So that fiscal impact would be $58,923. And that's again with the illustrative numbers from January 18. So were there actually people in attendance here? I'm sure this is where a lot of questions would be. Hopefully we'll have some before the presentation is done. The remaining 12 amendments are all very technical. Again, these are all items. So it's items G through Q, I'm sorry, G through R. And they're all items again that were proposed by our Charter Election Review Committee back in 2016. So for Proposition G. Essentially what this would say is when we do our 10-year, every 10-year redistricting, we don't have to have a meets and bounds description. Now I will say this was recommended by the Charter Committee. The Charter doesn't explicitly say you have to have meets and bounds, but I guess out of an abundance of caution, the recommendation was we should say that we don't. If you think about it, when you're doing redistricting, saying this side of Riverside or this side of the river or this side of some other identifiable boundary is no more useful than saying meets and bounds, you know, 39 degrees north X minutes and seconds. So this would just say explicitly there's no meets and bounds required when we do redistricting. Proposition H is to address a kind of an odd little thing we have in our Charter. Currently some of the appointed officials, the city secretary, city manager, and city attorney all of the department heads have the right to request a hearing before the city council if they are terminated after their six-year probationary period. Now the reason I say it's a little odd is the department heads don't work for council. The Charter actually says that the council can't direct what happens. Those people work for the city manager and the Charter makes it illegal for council to direct what the people who report to our city manager do. So it's very odd they would hold a hearing but they would be in no position to grant relief. It's also a little odd because it doesn't specify time frame, doesn't say where you file, it doesn't say how soon after you've been terminated you would have to file. So it creates a lot of questions and in the time that I've been with the city almost 16 years now I believe two people have inquired about holding the hearing. I don't know that either one actually ended up with hearing. So this would eliminate that and say just repeal all those references to the hearing. Proposition I is to change the time period when individuals want to get something on the ballot and they file a petition, whether they want to have a referendum to add through adoption ordinance or to change the Charter or if they want to actually try to recall their council persons. The mechanism for doing that is you file a petition, city secretary has to review that petition. Currently they have 10 days to review that petition. When you're talking about potential let's say recall of a city-wide office that's thousands of signatures and 10 days in order to comply with that requirement would probably require hiring temporary staffing. So this would extend that time period for review of those petitions from 10 days to 25 days. This again was a recommendation of that Charter Review Committee. A number of the proposed Charter amendments relate to changing things where the Charter has not kept up with the current city practice. And this is one of those. So Proposition J would take out currently our Charter says that the finance department is to assess and collect our city taxes. Well as anyone who's paid their tax bill knows that you don't write your check to the city at 4th. You write your check to the Tarrant County Tax Assessor Collector. So this amendment would propose taking out that reference so it would not be listed as a duty of the finance department. And it would comply with our current practice which is that the county does it. Similarly keeping up with or updating to catch up with current practice. Proposition K would eliminate the reference that we have currently in our city Charter that says the city shall have a department of health. The city does still maintain some health functions. Our Code Compliance Department does restaurant inspections and some health functions for over a decade. Around the 2010 timeframe if I remember correctly the city and the county got together realized wait the county is doing health city is doing health. Maybe we should just have one of us do it not duplicate efforts. So since that time most of the public health duties have been handled by our county health department. So this would eliminate the reference that says the city is to must have a public health department. Not to say that we couldn't at some point in the future decide to have one. It's not a prohibition against having one. It's just saying we're not required to have one. And that again is just to kind of get catch up with our current practice. So Proposition L is relating to when the city sells pieces of public property. Currently the city Charter requires that notice to be published four times once a week every week in the city newspaper. Publish publication costs is not inexpensive and the newspaper doesn't reach in all honesty as many people as it used to. So the proposed Charter change again from the 2016 proposal would be have a single newspaper publication for people to read the paper. And then for those four weeks put that notice on the city's website and keep it up there for the whole period so that if people are interested in buying the property they would be aware that that was going on. And this only applies when you're selling property that's worth 125,000 or more. So another cleanup type change is Proposition M. Currently the city Charter says that the city shall impose an assessment for people for the abutting property owners if they come in and they do sidewalk and curb work in front of a house. Or in front of a building. City hasn't actually imposed those assessments for a number of years so this again would repeal that requirement. It would leave the discretion to have it. It would change it from a shall assess to a may assess. So if a time came when that made sense to do it could still be done. But it would not be a mandatory requirement as that has not actually been taking place. Some of the places where our Charter is proposed for amendment is just simply to try to make sure we're not conflicting with state law. This is one of those. Currently our Charter has a very specific date by which the tax assessor collector has to submit the tax roll to the city. Right now the date specified in our Charter matches state law but every two years the legislature meets in Austin and every two years they could change those things. So the proposed change here would be to simply say under our Charter whenever you have to submit under the state law that's the date by which you submit. So we don't end up in a situation where our state law and our Charter don't match. Public Service Corporation reports. So our Charter says that public service corporations have to file these reports annually with the city. Again this is a process that has not actually been employed for a number of years. To the extent this information you're looking for this information. It's readily available for most of these companies online either from the state utility public utility commission or from the companies themselves. And so rather than have the added requirement of having these folks file with our city secretary's office this would eliminate that entirely. Proposition P the city's official advertising contract currently under our city Charter under state law. We have to go out. We have to put certain notices again in the newspaper under state law. And those notices have to go to our official paper of record. The Charter requires the city to go out for bid and get to have a competition for a paper of record every single year. While the idea of a competition amongst papers is nice. The reality is there aren't a lot of papers to compete. And if you have to keep going out for bid there's a staff time associated with going out for bid having to renegotiate a new contract. So the recommendation here would be to simply say instead of every year contract. It could be a multi-year contract. It just allows at the discretion. So when it seems appropriate in the in the opinion of the city manager's office that we need to go back out. It's been a while we should go back out for bid we would but we would not be required to go every single year. So hopefully this would increase efficiency and save some money. Almost done. Stick with me. Proposition Q is related to annexation elections. Now this this provision it's interesting to read. It's clearly something that probably dates all the way back to the 1920 Charter. Some of the references are very archaic. So this amendment would strip out all of the archaic language. All of the references about the mayor calling an election which the mayor can't call an election directly anymore. And would simply say call an election in accordance with state law. And mark the ballot because right now it says you punch the ballot and we haven't punched ballots in probably a couple of decades. And then our final one are independent auditors. The city every year engages in independent auditor. They review. They do the what's the annual financial comprehensive report. I think I've got those letters out of order. And so they review the city's financials. They review the grant programs. And under our charter it currently has language that says the auditor must review the budget statements. When our former CFO came on board we looked at that and we were trying to figure out what that meant because there aren't this the provision of references doesn't actually include any statements per se. So we've been having the auditor review our budget adoption process rather than have tried to make up work to match something in the charter that we're unsure what it means anymore. And so the commission would revise it and simply say they would perform the normal audit that everyone understands to be part of your comprehensive annual audit and financial report. So it's 1313 amendments and 13 minutes I think. As Roger said we've got key election dates coming up we'll be doing these public meetings I think there's 10 or 11 of them scheduled today's first one they'll be going through at least April 25 possibly later. And so we've got a lot of information about the charter election, including the full text of the ordinance of the ordinance that called the election which has, you know, a lot of strike through version of the charter she can see exactly what would change is online, as is some more information, including the presentations that were made to city council and developing this. The last data register for vote for those who are not registered is April 7, which is a month before the election day. So early voting will be April 25 that will run through May 3 and then of course election itself will be Saturday the 7th. So there's additional information as I said on the website. If you have questions in the interim, you can reach out via the website there I believe going to be dedicated links with an email address you can submit your questions on the bonds or the charter on the city's webpage. So Michelle do we have any questions on the charter election. It's so interesting. All right, well thank you everyone for coming out. In addition to the meetings that are listed on the schedule and as Roger said there's a full list of meetings on the website. There's I believe also be a meeting in the box is that right Michelle are we doing that this year. Yeah, so there's information where if you have a neighborhood association meeting you can find online. Kind of just the basics of what Roger and I presented so y'all can go through it yourselves. And if you have a group that you would like folks to come to speak to probably not on the charter because it's not an interesting but if you have you'd like to have asked folks out to speak. You can also submit that to Michelle Guder communications director to get something set up so with that there are no questions and no one in the room is not city staff y'all have a good evening.