CAP CDS-Rest like operator missing

[sdebaerd]

Hi

We use CAP, which calls a custom CDS, when using a filter condition like startswith, this get's translated to an object like:

[
  { ref: [ 'Column' ] },
  'like',
  { func: 'concat', args: [ { val: 'VAL' }, "'%'" ] }
]

Then a dump occurs with the following error message:

[2020-07-03T15:27:13.365Z | ERROR | 1810204]: Feature not supported: Method .func of fluent API
[2020-07-03T15:27:13.366Z | ERROR | 1810204]: Error stacktrace: Error: Feature not supported: Method .func of fluent API     at nodeapplocation\node_modules\@sap\cds-runtime\lib\cds-rest\cqnToQuery\index.js:21:15     at Array.forEach (<anonymous>)     at compile (nodeapplocation\node_modules\@sap\cds-runtime\lib\cds-rest\cqnToQuery\index.js:16:31)     at nodeapplocation\node_modules\@sap\cds-runtime\lib\cds-rest\cqnToQuery\index.js:35:23     at Array.map 
(<anonymous>)     at compileNextExpression (nodeapplocation\node_modules\@sap\cds-runtime\lib\cds-rest\cqnToQuery\index.js:35:11)     at nodeapplocation\node_modules\@sap\cds-runtime\lib\cds-rest\cqnToQuery\index.js:19:9     at Array.forEach (<anonymous>)     at compile (nodeapplocation\node_modules\@sap\cds-runtime\lib\cds-rest\cqnToQuery\index.js:16:31)     at nodeapplocation\node_modules\@sap\cds-runtime\lib\cds-rest\cqnToQuery\index.js:35:23

Also trying to parse, the following command throws different errors, in this set up.

select column from table where column like 'VAL%'

However when running a CAP application, that calls genuine objects residing in a HDB Container, the like works fine.
To me there seems some functionality missing in the cds-rest library, to support like as an operator.

[OlenaT]

Hi Steven,

are you consuming an OData or a Rest service?

Best regards,

Olena

[jhodel18]

Hi Steven,

Do not respond by using the "Answer" section. Responding by commenting ("comment" button) here in the question section.

[sdebaerd]

Hi Olena

I'm consuming a oData service.

Package.json

"dependencies": {
    "@sap/audit-logging": "^3.1.0",
    "@sap/cds": "^3",
    "@sap/cds-odata-v2-adapter-proxy": "^1.4.33",
    "@sap/xsenv": "^3.0.0",
    "@sap/xssec": "^2.2.5",
    "express": "^4",
    "passport": "^0.4.1"
  }

"cds": {
    "requires": {
      "uaa": {
        "kind": "xsuaa"
      },
      "ServiceName": {
        "kind": "odata",
        "model": "srv\\external\\ServiceName",
        "credentials": {
          "destination": "SERVICENAME"
        }
      }

I'm using a CQL command to call the oData service

[OlenaT]

Hi Steven,

Thank you for the quick response. This is a known limitation on our side, we are planing to support it, but currently there is no timeline on when it will be implemented.

Best regards,

Olena

[sdebaerd]

Thanks for the feedback, Olena!

[RavindraBiradar]

like operator resolved for cds file ?

[gadirov]

Hi Steven,

see my blogpost in here:

https://answers.sap.com/questions/13320866/sap-cap-external-service-filter-startswithendswith.html

SO, basically there is the possibility to modify query.SELECT.where properties. I will post my solution soon.

BR
Rufat