[Data Grid] Display Boolean Value as Y/N

Forge Component
(31)
Published on 6 Nov (7 days ago) by OutSystems R&D
31 votes
Published on 6 Nov (7 days ago) 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