Toptube Video Search Engine



Title:Back to basics: OData - the Open Data Protocol - Part 4 - All things $filter
Duration:01:00:45
Viewed:3,722
Published:17-06-2022
Source:Youtube

Join us for more on OData, where we look in detail at the $filter system query option. So much to learn! Everyone welcome, especially beginners, and no question is too simple! Topics: OData, Northwind, CAP, Cloud Application Programming Model, TripPin, ASP.NET Links: Our shared repo https://github.com/SAP-samples/odata-basics-handsonsapdev CAP support for OData https://cap.cloud.sap/docs/advanced/odata OData 4.0 spec on URL conventions http://docs.oasis-open.org/odata/odata/v4.0/odata-v4.0-part2-url-conventions.html Various $filter examples https://github.com/SAP-samples/odata-basics-handsonsapdev/blob/main/filter.md The 'slurp' script to follow server-side paging "nextLink" annotations https://github.com/SAP-samples/odata-basics-handsonsapdev/blob/main/bin/slurp Chapters: 00:00 Welcome and introduction 04:00 Showing our shared repo and briefly explaining the contents 05:22 Looking ahead to functions and actions (and the "function import" name) 09:12 Reminding ourselves of the simple CAP-based OData service in the repo 11:40 Examining the OData spec surrounding $filter and the common expression syntax 18:00 Understanding the component parts of an OData URL 20:20 A discussion about mass data transfer with OData and how to make things faster 23:40 Starting to look at the examples, beginning with those with logical operators 26:40 Going off piste and talking about server side paging (and, eventually, the slurp script) 29:30 Explaining how to specify a navigation property (not an expansion) in the resource path 31:37 Discovering enumeration types in OData and how they can be checked with 'has' 33:21 Using $count in the resource path in a filter expression 34:40 Specifying system query options within a $expand context 35:19 Looking at arithmetic operator examples 39:08 Turning to string function examples 40:36 A brief digression on ICAO vs IATA airport codes 42:09 Trying out a couple of date & time functions (and also a brief but exciting look at $apply) 44:17 An example of an arithmetic function (as opposed to the arithmetic operators) 45:30 Introducing lambda operators! 49:42 Explaining how an OData lambda function is defined & what the JS equivalent might be 51:50 Understanding the difference between the 'any' and 'all' lambda operators 53:20 Combining an $expand (with embedded $select) with a $filter using the 'all' operator on a navigation property of the resource in the path 54:44 Applying $filter to an expanded navigation property 56:22 Improving the previous query by adding a second $filter at the resource path level 58:15 A brief look at the curious but useful $it mechanism



SHARE TO YOUR FRIENDS


Download Server 1


DOWNLOAD MP4

Download Server 2


DOWNLOAD MP4

Alternative Download :