andrew_50 Posted March 21, 2018 Share Posted March 21, 2018 I would like to change the default "," separator in a GROUP_CONCAT to something else. Studio complains mightily. I am using the correct syntax as it works in a straight SQL query, just not in Studio. I'm guessing it's not supported, but I'd like some clarification. Link to comment Share on other sites More sharing options...
dcdacd Posted May 21, 2020 Share Posted May 21, 2020 I've the same problem.Can you said me if you get any solution ?Thanks,. Link to comment Share on other sites More sharing options...
andrew_50 Posted May 21, 2020 Author Share Posted May 21, 2020 Not sure what I was doing wrong/differently, but group concat is now working for me.I think, but cannot be sure, that it was that Jasper requires use of double quotes, while stereotypially I use single quotes when writing SQLThis in a SELECT works...group_concat(rx.qr_code SEPARATOR " ") as caseCodes, Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now