[Resolved] Show fileds of many one to many relationship with a comom fild to a view

[Author]

Posts

[kostasO]

Tell us what you are trying to do?
I have three post types:
a) Customer b)job, c) Invoice
I have two three one to many relationship a) Customer-Job(one to many) b) Job-payment (one-many) client-payment(one-many)

i want to create a view (or more that of one if needed) that will have a clients summary report
a) Customer 's Jobs
b) Customer 's payments

my Customer is my current logged in user. I am auto creating a new wp user each time a new Customer is being saved and the common field of the wp user and and custom post type Customer is the email

So i want to create a view that says
sow All the Jobs where current loged in user's emai = Customer's cutom post type Usermail field

but i cannot find a way to do it in views

[Luo Yang]

Hello,

I assume we are talking about this case:
Three post types:
- Customer (with a custom email field "my-email")
- job
- Invoice

If it is, you can try with a nested view, for example:
1) parent post view:
- Query Customer posts
- Filter by :
Select items with field:
my-email is a string equal to VIEW_PARAM(myemail)
- In view's loop, display below child post view

2) child post view:
- Query job posts
- Filter by :
the post type relationship between "Customer" and "Job"
- In view's loop, display "Job" post information

3) Create a WordPress page, in the page content, you can get current logged-in user's email with shortcode:
[wpv-user field='user_email']
And pass it to parent post view as shortcode attribute, for example:
[wpv-view name="parent post view" myemail=" [wpv-user field='user_email']"]

More help:
https://toolset.com/documentation/user-guides/views/passing-arguments-to-views/
https://toolset.com/documentation/post-relationships/how-to-display-related-posts-with-toolset/#displaying-many-related-items
https://toolset.com/documentation/user-guides/views/views-shortcodes/#wpv-user

[kostasO]

It works.
Thank you