Skip to Content (Press Enter)
2021-07-21 12-04-07
George.Qiao
206Views
2Comments
Solved
[OutSystems Data Grid Web] Display Boolean Value as Y/N
Question
DataGrid
Forge
outsystems-data-grid-web
Web icon
OutSystems Data Grid Web (O11)
Forge asset by OutSystems

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?

0
0
26 Aug 2019
Copy Link
2021-02-02 11-55-27
Tushar Panpaliya
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. 

See solution in context
3
0
26 Aug 2019
Copy Link
UserImage.jpg
Jack.Wong

Hi George, 

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


Example:

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

1
0
26 Aug 2019
Copy Link
2021-02-02 11-55-27
Tushar Panpaliya
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. 

3
0
26 Aug 2019
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.