Setting default value for property on service level in CAP

[EMueller]

Dear community,

I have a question regarding SAP CAP development.

On service level, I'm adding a property to my entity as explained here: Adding computed fields

entity Models as select from db.Models {
     *,
     null as test: Boolean }

How can I set a default value for this new property?

In this case, I would like my property "test" to be true.

Thanks and best regards,

Elias

[johannesvogel · Accepted solution]

Did you try:

entity Models as select from db.Models {
     *,
     true as test: Boolean }

This should create the underlying database view with true as default. Or in which situations do you want the default applied?

[EMueller · Accepted solution]

Yes I tried that, however it still puts the value to null.

[johannesvogel · Accepted solution]

Which request do you send?

I have tried it using the Node.js runtime and a simple GET request to that entity and for me it works.

[EMueller · Accepted solution]

Ok, I removed the @cds.persistance.exists from my Entity and tried the same thing using mock data.

It worked!

It seems like the issue is due to the data fetching from a remote server.

Thanks for your help.

BR,

Elias

[johannesvogel · Accepted solution]

If you fetch the data from somewhere else you must set the computed value yourself in your custom handler 🙂