Hello People,
I need help with an sql procedure. I am trying to make the procedure accept multiple entries in a list view, which it will in turn post. The script I have can only cater for a single entry per parameter in an item view, and list view.
Any help as regards this will be appreciated.
Find attached the sample script.
The Guarantor, and DirectorsInfo are the places where I want the script to accept multiple values in a list view.
Best answer by kimh
View originalWithout knowing too much about how the data is to be consumed, is it possible to use a STRING_AGG to list the comments in a string such as:
@DirectorsInfo nvarchar(100) = (Select STRING_AGG([Comments], ',') from [K2].[SmartBoxData].[FOS_Corp_BoardofDirectorsOwnershipStructure_SMO] where HeaderID = @HeaderId),
That should return the JSON value as "DirectorsInfo":"Comment 1,Comment 2,Comment 3" in the output. There are potentially several ways to solve this depending on how you need the data to display in your output.
Be careful here - I'm fairly confident that you are not allowed to add your own stored procedures to the K2 database, or to call into the K2 database directly as this will leave you in an unsupported state.
Cheers
Thanks to everyone I found my way around the script, and I am good now.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
