Why can't I query a Boolean column?
Question
Why is it not possible to query a column of the Boolean type?
datamartQuery.select("Distributor", "distributor")
Distributor
is a Boolean and when I run the query then it returns null
and the following warning:
Invalid datamart query: [distributor] Projection invalid for rollup: Distributor
Is there any workaround for that?
Answer
The solution is to disable the rollup. You can do it by passing false
in the second parameter to DatamartContext.newQuery(Table table, boolean rollup)
.
, multiple selections available,
Related content
Why is it not possible to query Integer column?
Why is it not possible to query Integer column?
Read with this
Why is SUM not working on Datamart query
Why is SUM not working on Datamart query
Read with this
Datamart Query Expressions
Datamart Query Expressions
Read with this
Definition (QueryAPI)
Definition (QueryAPI)
More like this
Can I query a Data Source directly?
Can I query a Data Source directly?
More like this
Roadmap (QueryAPI)
Roadmap (QueryAPI)
More like this
Found an issue in documentation? Write to us.