I've created some custom post-types using the Pods framework, however the the solution to my question should be the same regardless of pods. My custom types are event
, team
, achievement
, achievementunlock
. Each team
and achievement
belongs to an event
, each team
has a number of users assigned, and each user can post an achievementunlock
and choose from a list of achievements
.
I'd like to create a page which displays an overview of which achievements have been "unlocked", i.e. a user has posted an achievementunlock post for.
Something like this
Event1Name
| Team1 |Team2
| Bob | Steve | Scott | Mary |
Achievement1Name | View | - | - | View |
Achievement2Name | - | View | - | View |
Achievement3Name | - | - | View | |
Total | 1 | 1 | 1 | 2 |
Team Total | 2 | 3 |
Event2Name
.....
I'd need to be able to iterate all objects and see their properties. I.e. An achievement
post is posted by Bob, I need to be able to also see which team
he belongs to, and which event
that team
belongs to, etc.
How can I fetch my objects which I can iterate over them with ease, and how do I setup such a page in wordpress? Thanks!