When I use a 'Does not contain' option in a grouped filter, fields where the value is NULL do not match the filter. This is because in mySQL, "NOT LIKE" on a NULL value returns NULL, not TRUE.

I've patched the views string handler to accommodate for this by including an "OR IS NULL" on the op_not operator function.

This may have been handled elsewhere - it seems obvious - and there may be a better way of handling it, but my search found nothing. My apologies if I've duplicated an issue.

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

andyrandom created an issue. See original summary.

DamienMcKenna’s picture

Status: Active » Needs review

Oh, that's an interesting bug. Good catch. Lets see what the testbot says.

Status: Needs review » Needs work

The last submitted patch, op_not.patch, failed testing. View results

joseph.olstad’s picture

rerolled the original patch, same code except rerolled for head.

Status: Needs review » Needs work

The last submitted patch, 4: op_not-2867891-4.patch, failed testing. View results
- codesniffer_fixes.patch Interdiff of automated coding standards fixes only.