By c-c-m on

Hello,

I am using a custom content type called "course" which as a user-reference field called "teacher" and now I'd like to create a list of teachers (this is a list which filters all users whith a certain role) which would display, amongst other fields, the list of courses that each user is teaching. I guess I'd need something like these modules (node referrer, backreference or Corresponding Node References) but applied to user references instead of node references. Is there something like that? I performed a search but all user reference modules are focused to referals from one site to another, not from one node to a user.

Are there any other ways to achieve that?

Thank you

⋅ Categories: Drupal 6.x

Comments

theabacus’s picture

theabacus commented

You want to get a list of nodes based on the User Reference field, right?

You can use the field argument in Views to do it. If you add an argument you will see the User Reference in the list...

Hopefully, that is what you are looking for.

c-c-m’s picture

c-c-m commented

Yes and no...

If I only wanted that I could do what you say very wisely, but I want to create a table with a user list, providing one cell containing the avatar, another for name + bio and the last one containing a list of courses. I think this cannot be done with arguments, or if it's possible I don't know how to do it :(

tngcas’s picture

tngcas commented

I have the same issue. I need a view showing all artists that have a video (each video has one user-reference field). I need to be able to reverse-relate the users with videos tagged with their name.

Any ideas?

le_petit_basil’s picture

le_petit_basil commented

This might be a somewhat ill-advised, hack approach, but you could customfield, to define a php field, then extract the uid from each row, and programmaticly invoke another view that lists a teachers courses, accepts the uid as an argument for the user reference.

I'm sure that there would be major performance hits, but, if you turn on caching, for the views, and also use boost, or varnish, it would be acceptable.