Question Re: CAP annotation @Common.valuelistwithfixedvalues with... in Technology Q&A

CAP annotation @Common.valuelistwithfixedvalues with Flexible Programming Model not working

abranjan — Thu, 31 Aug 2023 12:43:45 GMT

Hi Everyone,

I am creating a CAP application with Filter Bar and Smart table control using Flexible programming model and cds annotations.

Goal: Based on the selection of one drop down value I want to restrict few values of another drop down from Filter Bar. (I want if-else sort of conditional flexibility on the value selection from 1st drop down -- so that other drop down values can be manipulated) -- Using Annotations

Flexible Programming Model: I have tried out FPM with CAP cds annotations. I specifically wanted this below feature to work out for me:

4) Context-Dependent Value Help - https://sapui5.hana.ondemand.com/test-resources/sap/fe/core/fpmExplorer/index.html#/advancedFeatures/guidanceValueHelp

but when I put context and conditions like SAP has maintained here in above guide. I am not able to make it work.

Is there any suggested way to approach this??
Or if anyone knows how to properly use context and conditions with CAP cds annotations?

It would be a great help!!

Thanks in advance!!
Abhijeet

Re: CAP annotation @Common.valuelistwithfixedvalues with Flexible Programming Model not working

Ivan-Mirisola — Fri, 01 Sep 2023 18:13:25 GMT

Hi abhishek.ranjan5,

Could you please share what you have done so far w.r.t. Context-Dependent Value Help?

It would help us in order to determine what is wrong with the project.

If you could also share a prototype on github, maybe we could even propose changes on the code so it works as you expect.

Best regards,
Ivan

Re: CAP annotation @Common.valuelistwithfixedvalues with...

Subramaniyam — Mon, 26 Feb 2024 12:31:27 GMT

Hi @abranjan ,

I could'nt find the solution through annotations, but via different route.

You will have to cache the selected value from the drop down locally in the runtime and use it as filter in the following manner.

srv.on('READ','Myentity',async req=>{ if(req.query.SELECT !== undefined){ const condtionLiteral =`DropDownFieldName='SelectedDropDownFieldValue'` //instantiate the cxn parser object const parser= cds.parse; // parse cxn : resultant => {xpr:[ {ref:['DropDownFieldName']}, '=', {val:'SelectedDropDownFieldValue'} ]} const cxnObject = parser.expr(condtionLiteral); const cxnArray = [...cxnObject.xpr]; req.query.SELECT.where = cxnArray; } const data = await srv.run(req.query); return data })

Please also have a look at this documentation of CXN - CXN-Expression Notation .Let me know if this works for you.

Thank you

Regards

Subramaniyam N