You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Description:
I have a fairly complex query I'm trying to port to DBFlow semantics. The biggest hurdle I've had is trying to figure out the syntax for a query piece that looks essentially like this:
SELECT Message.X, Message.Y, Message.Z, CASE WHEN CAST(Conversation.Bookmark AS LONG) <= 0 THEN false ELSE true END isBookmarkAvailable
I can get part way there with the syntax IProperty foo = Method.cast(Conversation_Table.Bookmark).as(SQLiteType.INTEGER); but I cannot do a comparison "<= 0" on the IProperty.
The text was updated successfully, but these errors were encountered:
ISSUE_TEMPLATE
DBFlow Version: 3.1.1
Bug or Feature Request:
Description:
I have a fairly complex query I'm trying to port to DBFlow semantics. The biggest hurdle I've had is trying to figure out the syntax for a query piece that looks essentially like this:
SELECT Message.X, Message.Y, Message.Z, CASE WHEN CAST(Conversation.Bookmark AS LONG) <= 0 THEN false ELSE true END isBookmarkAvailable
I can get part way there with the syntax
IProperty foo = Method.cast(Conversation_Table.Bookmark).as(SQLiteType.INTEGER);
but I cannot do a comparison "<= 0" on the IProperty.The text was updated successfully, but these errors were encountered: