Hi,
Is there a way to count the number of associated entities using CDS? Let's say I'd like to display the number of books written by a particular author:
entity Books { key ID : Integer; title : localized String; author : Association to Authors; } entity Authors { key ID : Integer; name : String; books : Association to many Books on books.author = $self; @Core.Computed numberOfBooks : Integer; }
I tried something like count(books) as numberOfBooks but it's not supported :-)
Cheers,
Pierre