I have created a website in which I am providing complete information about the organization. For this, I am using a Wordpress post. In which I am putting information of only one organization in a post. For additional information on the organization, I am doing it with a WordPress posts custom meta key.
In the information of the organization, I am giving the founder, adviser, employee, office address etc.
In the information of the organization, I am putting the names of 1 to 4 founders and their LinkedIn link, 1 to 24 employees' names, and their LinkedIn links, And 1 to 12 names of advisor and their LinkedIn link. I am saving all these data in a post custom meta key. I am saving all these data in one-one post custom meta key.
For Founder (1 to 4) ie : founder_1_name, founder_1_linkedin, founder_2_name, founder_2_linkedin Similar to other...
For Team (1 to 24) ie : team_1_name, team_1_linkedin, team_2_name, team_2_linkedin, team_3_name, team_3_linkedin, team_4_name, team_4_linkedin Similar to other...
For Advisor (1 to 12) ie : advisor_1_name, advisor_1_linkedin, advisor_2_name, advisor_2_linkedin, advisor_3_name, advisor_3_linkedin Similar to other...
Now I have got the entire data of one organization in all posts saved.
What I Want: Now I want to display the list of those advisors and team member that are in more than one organization. I want to display all those posts in front of the list of all those Adviser names in which they also add.
And in front of the name of the team or advisor, the other organization's post link is visible, clicking on that page will open the Organization page.
I do not understand how to achieve this list. It took me a lot of time to write the whole question. So I hope that while appreciating my hard work you will help me find an answer to this question.
I tried to find the answer from my side, but when I realized that I have not found anyway, therefore I am seeking help in this forum.
If any of you can tell me the correct path, then please help me. I will be grateful to you.
Note: The Linkedin link is unique in this whole data. If we filter out the LinkedIn link data, then we could probably find the way. This is my thinking, if there is any other way please help us.
Again thanks to all those who have spent precious time in reading my questions.