When all filters are in the alternatives group, the WHERE clause contains an empty set of parentheses, causing and SQL error. The attached patch removes the empty group that causes the error.

CommentFileSizeAuthor
#1 views_or-385086-1_HEAD.patch24.14 KBdarren oh
views_or_end_alternatives_handler.inc_.patch700 bytesdarren oh

Comments

darren oh’s picture

darren oh
Primary language English
Location Lakeland, Florida
commented
Status: Needs review » Needs work
StatusFileSize
new views_or-385086-1_HEAD.patch24.14 KB

Reorganized and cleaned up code, and started a COALESCE function for fields. COALESCE has some problems:

  • Labels for coalesced fields are not removed.
  • Users cannot set aliases for coalesced fields (could use label as alias).
  • The primary key gets added multiple times.
darren oh’s picture

darren oh
Primary language English
Location Lakeland, Florida
commented
Title: Error when all filters are in alternatives group » COALESCE for fields/Error when all filters are in alternatives group
darren oh’s picture

darren oh
Primary language English
Location Lakeland, Florida
commented
Title: COALESCE for fields/Error when all filters are in alternatives group » Error when all filters are in alternatives group
Status: Needs work » Fixed

Fixed in CVS commit 178070. The coalesce feature will be added separately.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.