自定义报表表查询布尔列

Question

我是Kentico的新手，到目前为止我真的很喜欢开发！我已经用尽了所有的搜索努力，我想我会联系社区。我正在使用Kentico中内置的报告创建一个自定义报告（确切地说是表）。我有一个自定义查询：

Select FirstName as [First Name], LastName as [Last Name], Email, Phone, StreetAddress as [Street Address], City, State, Country, Zip, Email, Phone, PaymentDate as [Payment Date], TransactionID as [Transaction ID], PaymentStatus as [Payment Status]
from TableName E
WHERE E.ID = 1 AND E.PaymentStatus = False
ORDER BY E.ItemCreatedWhen ASC

我发现的问题是，PaymentStatus显示为"复选框-未检查或已检查"，而不是True或False。在实际的表格和数据中，它显示True/False。有办法解决这个问题吗？谢谢你的帮助！

Answer 1

我得到了相同的复选框，您可以通过将布尔（位）字段包装在CASE中来获得文本值。您的报表表查询将如下所示；

SELECT FirstName as [First Name], LastName as [Last Name], Email, Phone, StreetAddress as [Street Address], City, State, Country, Zip, Email, Phone, PaymentDate as [Payment Date], TransactionID as [Transaction ID], 
CASE WHEN PaymentStatus = 0 THEN 'False' 
    ELSE 'True' 
END as [Payment Status]
FROM    TableName E
WHERE   E.ID = 1
        AND E.PaymentStatus = False
ORDER BY E.ItemCreatedWhen ASC