OAC Answers Prompt Passing Truncated String
Summary
Prompt is trimming values from a column and passing them, causing Dashboard failureContent
Has anyone else encountered an issue where values in a Dashboard prompt are truncated, which then causes the Dashboard to fail?
For example, in the column that the prompt is built from I have the value, "Provost & Vice Chancellor for Academic Affairs."
The prompt shows, "Provost & Vice Chancellor for Acad" which I thought was just a display adjustment for the drop-down;
however, after my dashboard kept failing, I reviewed the SQL log and it is actually passing the truncated value. The drop-down is dynamic and not a fixed pixel width. The shortened string also appears in graphs and legends if, for example, I select (All Column Values) and the Dashboard can successfully generate.
1