Linking together two different custom post types

  • Good afternoon.
    I hope someone can help with this, since it is very frustrating
    I want to create a page in which there is a dynamic table that when choosing a season, a league and a team automatically appear the players that correspond to that team. I created the queries to find the teams, the leagues, the teams and the players, but I need to be able to combine everything in a simple search, like sql “inner join”.
    There are some plugins that in theory help to create these relationships, but they don’t work, so I want to know if someone has already developed it
    Thank you. Regards.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Savvas

    (@savvasha)

    Hi @javiersinisgalli ,

    So actually you want to create Player Lists “on the fly”?

    An easy way to do it is to create a “master” Player List with default filtering options. Then you can create on the fly each Player List using the player_list shortcode like the following:
    `[player_list id=”master-plyaer-list-id” league=”league-id” season=”season-id” team=”team-id”]’. All the queries are already there ??

    Thanks,
    Savvas

    Thread Starter Javier Sinisgalli

    (@javiersinisgalli)

    Hello @savvasha

    Perfect, but in that case I should create a list for each team, because where you indicate, for example, the “team_id” I have to put the id of a team, correct if I am wrong or I might have misunderstood, thank you very much

    Plugin Contributor Savvas

    (@savvasha)

    Well you can create three drop-down lists. One for league, one for season and one for team. When you select all three values then using an Ajax function you can call the shortcode with the values of league_id, season_id and team_id.

    That’s the general idea anyway ??

    Thanks,
    Savvas

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Linking together two different custom post types’ is closed to new replies.