A Views tutorial for version 6.x at http://views-help.doc.logrus.com/help/views/example-users-by-role mentions changing the view base table when creating the view by changing the type field to User. I'm trying to make a member list as well with the following SQL:

SELECT
    l.field_last_value AS Last,
    f.field_first_value AS First
FROM
    field_revision_field_last l INNER JOIN field_revision_field_first f
ON f.entity_id=l.entity_id
ORDER BY Last;

I can not find this type parameter in this version of Views. Some online sources describe various complex hooks to specify a base table other than "node" for a specific view. What is the best way to produce the attched SQL statement? I asked in the main support board and nobody responded.

Thanks,
Kevin

Comments

dawehner’s picture

dawehner
Primary language German
commented
Status: Active » Fixed

You probably want to look at http://drupal.org/project/views_field

beakerboy’s picture

beakerboy
Primary language English
Location Kentucky
commented

What if I choose to add field to the User table instead of using Profile2, or just want to use the username field in the default User table. How does someone change the base table from node to "User" in Views 7.x. I fail to see a "type" parameter that is referenced in the Views 6.x tutorial above, in this version of Views.

Thanks for any help,
Kevin

dawehner’s picture

dawehner
Primary language German
commented

you can still select in on the wizard. It's called "show"

Status: Fixed » Closed (fixed)

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