[Resolved] how to filter view by post-id of related post

[Author]

Posts

[Amin]

I have a post type called Agency. I have another post type called Candidate. I've created a relationship where one Agency can have many Candidates.

Each Agency can also have many "managers", so I've stored the Agency post-id into a usermeta field (agency-post-id) of each "manager" user.

I've created a view that lists all Candidates but I want to filter the results based on the agency that the candidate is related to.

How can I filter the view so that it uses the usermeta field (agency-post-id)?

The end result should be that if a user (manager) belonging to a certain agency visits this page, they should see all the Candidates that are related to his agency.

[Luo Yang]

Hello,

How do you setup the usermeta field (agency-post-id)? With Toolset Types plugin?
If it is, you can try these:
1) Setup a post view: "view-name"
- Query agency posts
- Filter by:
Include only posts with IDs set by the View shortcode attribute "ids" eg. [wpv-view name="view-name" ids="1"]
https://toolset.com/documentation/user-guides/views/filtering-views-query-by-post-id/
- In view's loop, display agency post infomation + related "Candidate" posts:
https://toolset.com/documentation/post-relationships/how-to-display-related-posts-with-toolset/#displaying-many-related-items

2) You can get the usermeta field (agency-post-id) value using Types shortcode, for example:
[types usermeta="agency-post-id" user_current="true"][/types]
https://toolset.com/documentation/customizing-sites-using-php/functions/

Then pass above shortcode as Views attribute to get the related agency posts:
For example: [wpv-view name='view-name' ids='[types usermeta="agency-post-id" user_current="true"][/types]']
https://toolset.com/documentation/user-guides/views/passing-arguments-to-views/#controlling-the-filter-with-shortcode-attributes

[Amin]

My issue is resolved now. Thank you!