[Data Grid] Display Boolean Value as Y/N

Forge Component
(26)
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


Example:

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

Solution

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. 

Solution