[Data Grid] Display Boolean Value as Y/N

Forge Component
Published on 31 Jul by OutSystems R&D
26 votes
Published on 31 Jul by OutSystems R&D

Just wondering if I have the backend data in a SQL Server table as bit data type. How do I format the grid to show 0 as N and 1 as Y?

Hi George, 

You can use IF() in side the Expression, hope it can help you, thanks


If(GetDatabase.table.Ischecked = 1, "Y", "N")


As Jack suggested, the simplest option would be to use an IF statement. You can put it in the rest service itself while assigning the value so that it sends a Y or N instead of 0/1.