When filtering a view by a Profile checkbox (boolean) field, the query generated is not Postgresql compatible.

The problem is a type mismatch, becouse the query is something like WHERE profile_values_*.value = 0 or like WHERE profile_values_*.value <> 0, but in the database that field is a text field.

So the query must be WHERE profile_values_*.value = '0'

CommentFileSizeAuthor
#1 982472-fix.patch526 bytesdawehner

Comments

dawehner’s picture

dawehner
Primary language German
commented
Status: Active » Needs review
StatusFileSize
new 982472-fix.patch526 bytes

If you apply this patch and you clear the views cache at admin/build/views/tools, does this patch fix your issue?

Monty-2’s picture

Monty-2 commented

after applying the patch the query become WHERE profile_values_*.value = '', that is sintactically correct, but is searching for an empty string '' to be FALSE and not for '0'

Monty-2’s picture

Monty-2 commented
Status: Needs review » Active
dawehner’s picture

dawehner
Primary language German
commented
Status: Active » Needs work

Update status.

mustanggb’s picture

mustanggb commented
Issue summary: View changes
Status: Needs work » Closed (won't fix)