Method:Classic General Q&A

Re: Grid SQL Override for YesNo

Method_Inderdeep — Tue, 21 Oct 2014 15:13:05 GMT

I am glad that your issue is resolved and thanks for sharing the resolution.

-Inder

Re: Grid SQL Override for YesNo

robert.cowart — Tue, 21 Oct 2014 15:06:13 GMT

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.

Re: Grid SQL Override for YesNo

Method_Inderdeep — Tue, 21 Oct 2014 14:11:21 GMT

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

Grid SQL Override for YesNo

robert.cowart — Mon, 20 Oct 2014 18:19:46 GMT

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.