I'm trying to create a view (views2) to find users that don't have an expiration date against a given role?

The SQL created includes this:

LEFT JOIN role_expire_5 role_expire_5 ON users.uid = role_expire_5.uid

which is mandating the existence of an expiry date.

How can I get the filter to do what I want?

Comments

bdziewierz’s picture

bdziewierz commented
Category: support » feature
Status: Active » Needs work

At the moment the module doesn't support functionality you've described. You can only filter for an entry in db table and not for a lack of entry. That's obviously an oversight from my end. I will add what you require to next minor version that should be released over Easter.

bdziewierz’s picture

bdziewierz commented
Status: Needs work » Active
kemitix’s picture

kemitix commented

Thanks, I look forward to it.

bdziewierz’s picture

bdziewierz commented

Sorry for delay. Still working on it.

daniel.marston’s picture

daniel.marston commented

How is this coming along?

bdziewierz’s picture

bdziewierz commented

Integrating Amitabu's rewrite with rest of the new code (including code to resolve this issue) now. So hopefully all will be commited soon.

kirie’s picture

kirie commented

Bump :) Any progress?

rcodina’s picture

rcodina
Primary language Catalan
Location Barcelona
commented
Issue summary: View changes
Status: Active » Closed (won't fix)

Drupal 6 version is unsupported!