Skip to Content
1
Nov 24, 2021 at 03:47 PM

SELECT on views with join and/or union is not supported

252 Views

Hello CAP Community,

I'm in the upgrade process from CDS 5.4 (Release August 2021) to CDS 5.6 (Release November 2021). That worked fine until I've made a request to an action that does a SELECT on a View that contains a JOIN. In 5.4 that worked just fine. Now with 5.6.4 it fails. This is the error log:

Error: SELECT on views with join and/or union is not supported
    at module.exports (/node_modules/@sap/cds/libx/_runtime/common/error/index.js:6:24)
    at _checkForForbiddenViews (/node_modules/@sap/cds/libx/_runtime/common/utils/resolveView.js:486:13)
    at _getTransitionData (/node_modules/@sap/cds/libx/_runtime/common/utils/resolveView.js:502:32)
    at getTransition (/node_modules/@sap/cds/libx/_runtime/common/utils/resolveView.js:545:50)
    at /node_modules/@sap/cds/libx/_runtime/common/utils/resolveView.js:567:16
    at Array.map (<anonymous>)
    at _entityTransitionsForTarget (/node_modules/@sap/cds/libx/_runtime/common/utils/resolveView.js:560:19)
    at _newQuery (/node_modules/@sap/cds/libx/_runtime/common/utils/resolveView.js:598:23)
    at resolveView (/node_modules/@sap/cds/libx/_runtime/common/utils/resolveView.js:616:20)
    at ApplicationService.handle (/node_modules/@sap/cds/libx/_runtime/cds-services/services/Service.js:131:17) {

The function that is called there is called _checkForForbiddenView.

Looking forward for your input how we can resolve this issue. I've checked the changelogs but I haven't found any indication in this direction.

CU
Gregor