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
Without 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.
Without 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
