Expected Boolean but received String

Expected Boolean but received String

  

Hi,

I have received an error: 

Column 'IsDisplayed' has an invalid type. Expected a 'Boolean' but received a 'String'.

On my excel sheet column IsDisplayed, the data is True or False.

What should i do to solve the error?? Put 1 or 0?

In the entity level, Outsystems uses 1 and 0 for boolean value. Just try it!

regards,

bb


Barong Bali wrote:

In the entity level, Outsystems uses 1 and 0 for boolean value. Just try it!

regards,

bb


I tried before but still same error. I import it from excel sheet. 


Solution

I tried in my cloud environment:

if the value is 0 / 1 it will be false. If the value true/false, it works exactly. Note do not put id column.

this is the output aggregate:

here is the entity:

and here is the the bootstrap action created:

regards,

bb


Solution

Hi Jace,

It seems you have a column in the Excel that is not a boolean (i.e. TRUE or FALSE), so the Platform cannot parse it.

@Barong: yes, in the database booleans are stored as 0 and 1, but you should never have to deal with that unless you are writing SQL. It definitely doesn't have impact with the Excel import.

Probably what Kilian stated. Also take into account that when you're using a localized version of Excel, the values for TRUE and FALSE can also differ. The Dutch version for example uses 'WAAR' and 'ONWAAR'.

In addition to the above remark by Lennart, using the string value equivalents of TRUE and FALSE (or WAAR and ONWAAR etc.) will not work. It must be an actual boolean in the Excel file.