Hi all. This is a long shot, but I'd love to have one output element for contribution notes, that I can filter by campaign as usual, that will not output multiple rows, but that will concatenate all valid contribution notes into one column output. Does anyone know if this is even possible?
The use case is to pull info for the program book. The output set will return one row for each constituent (perfect!) until I add contribution notes to the output set. This creates tons of extra work for our sole development associate.
Trying to use STRING_AGG but it says built-in function is not defined or something.
Hazel,
I think Tessitura is still one version of SQL Server behind being able to use the STRING_AGG function. Years ago I found a group concatenation function online and installed it in our system. I have never actually tried using it in the set-up for an output element, but I do not see any reason why that could not work.
There is also always the XML method of translating into a group concatenated string. If you have someone on staff with SQL skills, I think how you would want to do that is to write a local view with the relevant data, which would then allow you to do the output set-up by just selecting your concatenated column. If no SQL skills on staff... while I feel like there must be some way to get it done, nothing else is coming to me at the moment.
John
Thanks for the input, John!
Our Systems Admin had saw those alternatives but thought they were too resource intensive. The search continues
As John mentions I've set up concatenation for strings using the STUFF function for XML path in a local view. Depending on the labour it saves it could be worth it.