[Resolved] View to select an associated user

[Author]

Posts

[Kelly]

Hi! In my site there are two different user types I'm building pages for. Athletes and Trainers.

Athletes have a Trainer associated. I've added a usermeta field to the athletes called "trainer_id" which has the ID of the assigned trainer.

I was intending to create a view which displayed the trainer for the current logged in user, but I can't work out how as it seemed like the relationships work the wrong way.

I.e. creating a view which selects trainers, and query limited to the trainer_ id... but this is the trainer_id of the trainer, NOT the athlete!

do I need to create a view for athletes, limit the query to the logged in user id, and then do some sort of look up in the loop instead?

[Luo Yang]

Hello,

You can use Types shortcode to get current logged-in user's field value, for example:
[types usermeta='trainer_id' current_user='true'][/types]

Then pass it to below user view as shortcode attribute:
- Query trainers users
- Filter by:
Select users with id set by the View shortcode attribute "users" and with role "(trainers)"

Display above post view like this:
[wpv-view name="view-name" users="[types usermeta='trainer_id' current_user='true'][/types]"]

[Kelly]

Yep! That worked.