Skip to Content
1
Aug 16, 2023 at 06:26 AM

How to use the "as select from"-Variant in service.cds with CAP CDL

187 Views

I want to create a non-persistence entity, who join two persistence entities. I try to bind the "toQuestions"-path to a sap.m.Table

But i got the following Error: Entity "Service.Questions" is annotated with "@cds.persistence.skip" and cannot be served generically.

How can I implement such an entity?

entity Processes                   as projection on db.Processes{
*,
toQuestions : Association to many Questions on $self.ID = toQuestions.process
};
entity Entries as projection on db.Entries{
*,
toQuestions : Association to many Questions on $self.ID = toQuestions.entry
}; @cds.persistence.skip
entity Questions as select from QuestionInputs as qi join QuestionConfigs as qc on qi.toQuestionConfig.ID = qc.ID {
qi.toEntry.ID as entry,
qc.toProcess.ID as process,
};