Question Re: Adding association as input parameter for custom acti... in Technology Q&A

Adding association as input parameter for custom action in CAP

David21 — Mon, 30 Sep 2024 20:37:59 GMT

Hello everyone,

I'm using CAP(Node.js) with odata(v4) & fiori elements. I am creating a custom add button so that user can add multiple values from valuehelp to draft rather than using the create button which allows you to create only one entry at a time. As we know that you can't use associations as an input parameter of custom actions, So I have been using a workaround for it. Create a type in cds service file with a field that has type array of string i.e type customType{someField : array of String}, Use this field as an input parameter i.e. action someAction( someField: customType : someField), And then assigning a valueHelp to this field through annotations.

This works fine if the associated entity has only one key. But if the associated entity has two key fields i.e. composite key, there doesn't seem to be a way to store both the keys from the valueHelp. Any ideas on how to achive this ?

I used the following blog to implement this work around (6. Action with Value Help Input) :

https://community.sap.com/t5/technology-blogs-by-sap/cap-with-fiori-elements-actions-on-list-report-object-page-using/ba-p/13572833

Re: Adding association as input parameter for custom action in CAP

MattBrightman — Tue, 01 Oct 2024 01:55:18 GMT

Are you sure this is correct?

As we know that you can't use associations as an input parameter of custom actions,

Taking a look at one of my projects, https://github.com/MertSAP/AppTemplater/blob/main/srv/apptemplater-service.cds, I have done something like this in the past:

entity ServiceRole as projection on my.ServiceRole actions { action fillEntities(@( title:'Auth Type', Common:{ ValueListWithFixedValues: true, ValueList : { Label : '{i18n>ServiceAuth}', CollectionPath: 'AuthorisationType', Parameters : [{ $Type : 'Common.ValueListParameterInOut', ValueListProperty: 'AuthorisationType', LocalDataProperty: AuthorisationType }] } } ) AuthorisationType : String(30)); }; entity ServiceAuth as projection on my.ServiceAuth; entity AssociationType as projection on my.AssociationType;

Re: Adding association as input parameter for custom acti...

David21 — Tue, 01 Oct 2024 10:36:22 GMT

I think essentially it's doing the same thing that my approach does. You have assigned the action a valuehelp and storing the data in a string field

AuthorisationType : String(30)

And then in the JS file you are creating a draft for that entity with the inputed data. But if you assign the action's input type a field that is an association field i.e.

someAction(inp : someEntity : associationFeildOfThatEntity)

Or any variation of this it will give you an error. The issue is that if the associated entity i.e. the entity in the Collection path of the value help has a composite key then that means that every single column has values that are repeating, And if the user tries to select multiple values , it will only let you select those that have different values in the field

ValueListProperty

Thus ignoring some of the values .