1 of 1 people found this helpful
You may want to put the command(s)
for setting the session environment
into the Initial SQL dialog of your MySQL connection:
Thanks for the input. That worked for getting the initial setting in but doesn't solve the problem of truncating at 1024.
I think they have something hardcoded in the interpretation before passing the SQL code.
I created a test using the standard connections, and then used the convert to custom sql option.
I note that this creates the following code
SUBSTRING(`maydata`.`Task Resolution`, 1, 1024) AS `Task Resolution`
This seems to be what is happening to my custom code, even though i simply use in the select,
Looks like it is (hardcoded).
for some reason the varchar didn't work with tableau 10.5 + my sql 5.5.
I manage to add to the select,
CAST(REPLACE(cm.project_comment,',','') AS CHAR(4096)) As `Comments`,
LEFT JOIN (SELECT
GROUP_CONCAT( date_format(updated_at,'%Y-%m-%d') , ': ', note ORDER BY created_at DESC SEPARATOR '\n' ) as project_comment,
FROM comment_details cm
GROUP BY cm.work_request_id) cm ON b.`RFC ID` = cm.work_request_id
if i change to varchar, it gives an error. but at least it get the bulk of the comments in now.
I"m glad that help.