Role Expiration Time Views field & Role ID relationship act as filter [#856628]

When creating a table of site users, adding the "Role Expiration Time" field limits the results to ONLY those users with a set role expiration time.

This happens
- whether it's a Node view type or User view type
- whether "Hide if empty" is checked or not
- whether I use the "Role expiration Role ID" relationship or not
- even though there are no filters in the view

Am I missing something, or is this odd behavior? I have many Views tables that contain fields with empty values, and they don't get filtered by the field.

Role Expire 6.x-1.x-dev
Views 6.x-3.x-dev

Comments

Comment #1

keva commented 19 July 2010 at 14:45

More issues:
When the "Role expiration Role ID" relationship is added - even if not checked as "required" OR added to any field - it filters to just those users with a set role expiration time.

Comment #2

stewsnooze

he / him

commented 19 July 2010 at 14:40

Title:

Role Expiration Time field in Views acts as filter

» Role Expiration Time Views field & Role ID relationship act as filter

@keva In an uncommited local copy I have rewritten part of the views API code in role_expire so that users can create views with role_expire as the base table. Perhaps this will help. I'll commit soon.

Comment #3

keva commented 19 July 2010 at 16:03

thanks for the fast response! I'll test it when it's ready.

Comment #4

teliseo commented 4 November 2010 at 21:50

Status:

Active

» Needs review

See patch in #924976: Administration Report on Expiry Dates for a solution.

Comment #5

sharplesa commented 26 November 2011 at 00:41

I included teliseo's patch in a major all-inclusive patch at http://drupal.org/node/649256#comment-5291110. Please install that patch, test, and report here how it works. Will commit patch by Christmas 2011 if it's satisfactory.