Hey ,
Is it possible to update a constant with a array value using update constant smart service ?
If yes ,then how ?
Thanks ,
Bisheswar
Discussion posts and replies are publicly visible
The "New Value" parameter is a list type. Did you try to pass a list like {1, 2, 3}?
What you cannot do, is to change the constant from a non-list to a list type.
what I am doing like ,I am uploading a excel sheet where I have 2 column name and value .And after fetching data from excel , I stored the names in one variable and values in another variable .i am using update constant service as MNI on the basis of values stored variable .
How can i achieve in this scenario ?
Please help me understand why you update a constant multiple times?
We need more details. Any code snippets or screenshots?
I am using that constant in a interface for showing helptext for any field in the interface. If the business wants to show different text in future the business only have to upload the excel with new value and the interface will show the updated helptext .
bisheswar01 , you don't need to run update constant smart service multiple times here.
For your scenario you can have a constant of array type and use the same in the smart service.
If you are extracting multiple values from excel, just push those (pv where you have all the values) into NEW value and the smart service should update as needed.
It's Unclear what you are saying , Are you trying to Update multiple constants at single go, Based on names ? .
I have an alternate Approach for your use case , Maintain all the tooltips in Separate table and give admin (Site Admin) option to download whole or required bunch in Excel format and let him do the updates on downloaded file and Use WriteExcelToDB(I'm not sure about update command , give it a try)