See the series post for an overview of all the episodes. Notes 00:00 A rather lengthy introduction and recap (sorry Patrice!). 09:30 Patrice reviews and re-explains the case ... when ... then ... else statement in the @assert annotation, noting that if neither of the conditions match then the expression evaluates to...

See the series post for an overview of all the episodes. Notes 00:00 Introductions. 05:00 A first look at expressions in the context of the new Declarative Constraints feature. 06:00 An overview of CDS and the languages within the CDS family (CDL & CSN, CQL & CQN and CXL & CXN). 07:05 A first look at the...

One of my goals this year is to learn more about the AWK programming language. I'm interested in not only the beauty of the language itself and the Unix history that surrounded it, but in how AWK shaped one of my favourite languages of all time, Perl. In some ways AWK and CAP are similar, in that there's beauty,...

As a Developer Advocate, I have the privilege of working with some amazing colleagues in that team, but also in the wider Developer and Community Relations organisation. For the size of the community, it's a small group, and the folks are working hard to keep the wheels on the bus and rolling in the right direction....

The traditional "shift left" strategy in software is about how we move testing, security considerations and quality assurance to an earlier stage in the architecture and development process. This strategy is a useful one which can be adapted to what we code, and where we code. Something that's always been the case...

👉 Jump to the latest video. In the run up to SAP TechEd 2025, the Developer Advocates put together a series of short videos on tech topics, in a "Did You Know" series. A bit like our collection of YouTube Shorts "Good To Know" series (on CAP Node.js and on ABAP Cloud), but in landscape mode with a bit more detail....

The result of modifying existing queries can be a little unexpected at first. For example, you might have a query object where you want to replace the WHERE clause before you execute it. Here's how not to do it, and then how to do it. Setup To illustrate, we can use my cdsnano script to set up a tiny project with a...

In Part 2 of our current Hands-on SAP Dev live stream series on CXL with Patrice Bender, Patrice took some time to give us a glimpse of the power that CQL and CXL offers. It was in the context of answering a question from one of the live stream viewers (thanks Stubbs!) in the previous part, and the answer revealed...

OData is a topic close to my heart. History I was around when RSS was growing up, and even contributed to the wider RSS community activities at the time. I was also around during the creation of Atom and the Atom Publishing Protocol (APP). I was around when Microsoft took Atom and APP and turned it into OData. I saw...

(Get to all the parts in this series via the series post.) At the end of the previous part in this series we added @capire/common to the host project use-capire, and without doing anything else -- no referencing of this reuse package's contents anywhere in our own CDS model -- we saw the explosion of sources in the...

In part 2 of the current Hands-on SAP Dev live stream mini-series on CXL, the core expression language in CDS, Patrice demonstrated how declarative constraints are actually realised, and it made me sit back and wonder. I thought I'd write a quick blog post summarising what he showed, as I think it's worth stopping...

(Get to all the parts in this series via the series post.) In the previous part we published @qmacro/common. Let's start out here by creating a new simple CAP Node.js project and bringing in that @qmacro/common package; not only will this show that we really do have a publicly available & shareable reuse package,...