In the Advanced SQL Override of AssignedTo field of the grid in CaseList, I need to add a line that indicates a message if IsClosedBySelfService = 'Yes'. I tried adding + CASE WHEN viewCases.IsClosedBySelfService = 'Yes' THEN '<br /><b>Self Closed</b>' ELSE '' END but that causes the grid not to display at all. I get"Error Generating Grid ..." Whats the proper logical syntax to use YesNo columns in the SQL Override in a grid cell? Merely adding the IsClosedBySelfService column into the grid is not sufficient for what we need.
Hello Robert.Cowart,
I understand that by adding the column is not serving your purpose. Can you please provide me more detail on what are you trying to achieve here, that will help me to guide you in the right direction.
-Inder
I figured it out. To use a YesNo (binary) column in the Advanced SQL Override, you can use:
(CASE WHEN IsClosedBySelfService = 1 THEN 'true text, ' ELSE 'false text' END)
Issue resolved.... Thanks.
I am glad that your issue is resolved and thanks for sharing the resolution.