CAP Expand query does not function

cbsmerveguel — Fri, 31 May 2024 12:49:51 GMT

Hi all,

We have 2 entitysets from onpremise backend that we want to do an expand to. Basically entityset1 ("InspectionLotChars") should be expanded to its navigation association ("CharacteristicCatalogSet"). I have used below syntax to do it.

But it does return an empty array although CharacteristicCatalogSet has data in it for that specific entityset InpectionLotChars.

const characteristicCatalogQuery = SELECT.from('InspectionLotChars', a => { a.CharacteristicCatalogSet(`*`) (b => { b`.*` }) }).where({ INSPLOT: '123456789', INSPOPER: '0010', INSPCHAR: '0020' });

During debug from JS (since same statement also called from UI5 for another app):

this.getView().getModel().read("/InspectionLotChars(INSPLOT='" + found.INSPLOT + "',INSPOPER='" + found.INSPOPER + "',INSPCHAR='" + found.INSPCHAR + "')/CharacteristicCatalogSet");

We realized the call from JS is interpreted into CQN as below:

let characteristicCatalogQuery2 = SELECT.from({ ref: [ { id: 'CustomerReportService.InspectionLotChars', where: [ { ref: ['INSPLOT'] }, '=', { val: '123456789' }, 'and', { ref: ['INSPOPER'] }, '=', { val: '0010' }, 'and', { ref: ['INSPCHAR'] }, '=', { val: '0020' } ] }, 'CharacteristicCatalogSet' ] });

And interestingly if we use this CQN directly in the CAP service, we can get the result set as well.

Would anyone have a comment why the first Select statement does not work and secondly how to convert the second one into a CQL style SELECT statement.

Appreciate for any helpful comment.

Best,

Merve

Re: CAP Expand query does not function

gregorw — Fri, 31 May 2024 15:16:45 GMT

Have you tried to add an await?

Re: CAP Expand query does not function

cbsmerveguel — Fri, 31 May 2024 15:32:57 GMT

entered this message by mistake, cant delete it. please ignore.

Re: CAP Expand query does not function

cbsmerveguel — Fri, 31 May 2024 15:31:14 GMT

@gregorw I double checked the await command after your reply. I already use await during the request handling, but it ends with an empty array nevertheless. const characteristicCatalogSetResult = await this.tx(request).run(characteristicCatalogQuery); I tried to add the await on the query preparation (Select statement), but in that case ended with an error.

Question Re: CAP Expand query does not function in Technology Q&A

CAP Expand query does not function

Re: CAP Expand query does not function

Re: CAP Expand query does not function

Re: CAP Expand query does not function