cancel
Showing results for 
Search instead for 
Did you mean: 

[CAP] [CDS] Association on Parameterized View is not supported

chathia
Explorer
0 Kudos
896

Dear all,

We are trying to implement the Association on Parameterized Views. However, got a error messages:

[ERROR] srv\cat-service.cds:24:5-59: "association.CV_D_TEST_CDS_ASSOC.ID_1": Associations are not allowed in entities with parameters
[ERROR] srv\cat-service.cds:24:5-59: "association.CV_D_TEST_CDS_ASSOC.ID_1": Associations cannot point to entities with parameters

For the error messages, it is clear that this scenario is not supported.

However, I see a link for the above scenario in CAP documentation. However, the link does not show any details.

https://cap.cloud.sap/docs/cds/cdl#associations-with-default-filters

https://cap.cloud.sap/docs/cds/cdl#associations-to-parameterized-views

Is this an upcoming feature? or documentation issue?

Your feedback is appreciated.

Thanks & Regards,

Chathia.

Accepted Solutions (1)

Accepted Solutions (1)

Hello Chathia,

these features are currently in "concept" phase.

Regards,
Tim

chathia
Explorer
0 Kudos

Thanks for the response!!

chgeo
Advisor
Advisor

And these 'concept' links will be removed in the next documentation update, to avoid confusion.

Answers (1)

Answers (1)

There are restrictions in HANA SQL with views having associations, the above signalled being the most prominent one.

The discussion is to not making use of the HANA SQL association feature at all, but instead do the association-to-join translation ourselves in the compiler (as we do for Sqlite anyway – but there, no view parameters are possible at all).