hi read this:

https://www.sqlshack.com/understanding-sql-server-case-statement/

and don't forget to put single quote if it is a text.

Hi @Seheon,

Can you provide an SQL statement here about what you are trying it? SO we can find where you have written wrong. 

Hi Seheon Oh, 

You can achieve the same result with separate conditions and a union clause, something like this 

SELECT TOP (17) [ENTEAM].[ID] [ID], [ENTEAM].[NAME] [NAME], 1 [SHAREBOOL], [ENSHAREPOINT].[ID] [SHAREPOINTID]

FROM ([OSDEV1].dbo.[OSSYS_GROUP_T20] [ENTEAM]

    FULL JOIN [OSDEV1].dbo.[OSUSR_4MS_SHAREPOINT] [ENSHAREPOINT] ON ([ENTEAM].[ID] = [ENSHAREPOINT].[TEAMID])) 

WHERE (([ENSHAREPOINT].[TYPE] = N'SkillUp')

    AND ([ENSHAREPOINT].[SKILLUPPLANID] IS NULL))

AND [ENSHAREPOINT].[ID] IS NOT NULL

GROUP BY 1, [ENTEAM].[ID], [ENSHAREPOINT].[ID], [ENTEAM].[NAME]

UNION 

SELECT TOP (17) [ENTEAM].[ID] [ID], [ENTEAM].[NAME] [NAME], 0 [SHAREBOOL], [ENSHAREPOINT].[ID] [SHAREPOINTID]

FROM ([OSDEV1].dbo.[OSSYS_GROUP_T20] [ENTEAM]

    FULL JOIN [OSDEV1].dbo.[OSUSR_4MS_SHAREPOINT] [ENSHAREPOINT] ON ([ENTEAM].[ID] = [ENSHAREPOINT].[TEAMID])) 

WHERE (([ENSHAREPOINT].[TYPE] = N'SkillUp')

    AND ([ENSHAREPOINT].[SKILLUPPLANID] IS NULL))

AND [ENSHAREPOINT].[ID] IS NULL

GROUP BY 0, [ENTEAM].[ID], [ENSHAREPOINT].[ID], [ENTEAM].[NAME]

Hope that it helps you 

Hi Seheon,

This is an aggregate query you cannot change that, you need to share the aggregate and the filter conditions that you are using.

Otherwise convert aggregate into SQL. 

https://success.outsystems.com/documentation/11/developing_an_application/use_data/query_data/sql_queries/

Best to share the OML. That will be helpful

Thanks

Hi i think this forum question is too fat, the topic goes wildly not in a single minded problem. So it is better to open another question, not to surrogate this one.

regards