I'm having troubles setting up a View that displays a list of registrants (not registrations!) for a particular event. I don't know how to setup RELATIONSHIPS correctly?

(I have already created a view that displays all registrations for a particular event, but since the user can register more than once for a particular event, I'm getting a list with multiple users enteries (if user registered multiple times) which is not what I want.)

Any suggestions?

Comments

aaronott’s picture

aaronott commented

aucovic

The way I created it was the following.

* When creating a new view in the "Show" dropdown, select Registrations
* for the display format I chose Table (it just looks nicer I think)

I set my path as: node/%/registrations/attendees This allows me to set this as a tab for the event.
With the % in the path, I added Content: Nid

For the Relationships:
Registration: Registration to Node to tie the registration to the event
Registration: User So I can pull the username

Then add your fields.

This may not be the best way, but it works for me.

aucovic’s picture

aucovic commented

@aaronott, thx for your reply!

Actually I have created a view in the same way as you have, it works but... what if user registers multiple times for a single event? You will get user listed multiple times in the attendee list right? (It is beacuse you are pulling data from the registration entity table!) I do not want that. I want to see each user in a list, listed only once, regardless of how many times the user have registered for an event.

jenbrinn’s picture

jenbrinn commented

I have a similar problem. I can't get it to only show those signed up for that particular node--for some reason, it shows everyone signed up for everything.

Any advice?

jenbrinn’s picture

jenbrinn commented

Nevermind. I figured it out. :)

aucovic’s picture

aucovic commented

@jenbrinn Can you please explain how did you solve this problem? Thx!

Renee S’s picture

Renee S commented

I'm guessing a relationship or contextual filter?

onpointmedia’s picture

onpointmedia commented

Yes, by adding the contextual filter "(node from Registration) Content: Nid".
Before you have to add the relationship "Registration: Registration to Node"

john.oltman’s picture

john.oltman commented
Status: Active » Closed (outdated)