[Resolved] Create a "Pivot Table" View

[Author]

Posts

[Furlan]

Hi,

I have a new challenge.

Again, this is the basic structure of my site.
RESPONSIBLEs <---- ASSIGNATIONs----> TASKs

I am trying to display a View in a kind of "Pivot Table" or spreadsheet. The idea is to have in the rows of the spreadsheet the values corresponding to "Tasks" Post Type and in the columns "Responsibles" Post Type. The value in the intersection is ruled by an ASSIGNATION.

Any idea how could I achieve this view. is there any document referent to a similar request?

Thanks.

[Nigel]

Hi Juan Manuel

It will be possible to do this but require running so many View queries it will be very demanding in terms of resources, I'm not sure it is very sensible to even try.

You will need a View which loops over the Task posts (the rows).

For each row you will nest a View which loops over the Responsible posts (the columns).

Each nested iteration of this second View is effectively a cell in your table, but to get the value of the intermediate Assignation post you will need another View which has parent post filters for both Task and Responsible (the Task will have to be passed from the outer View with a shortcode attribute), and this View will have to be run for every cell.

So, if you had a 10 x 5 table as per your example, your Views would need to run 61 times, actually 62 because you would need a View to generate the column titles, and if your table grew in size the number of queries could significantly increase.

The outline of what is required is there if you want to try it...

[Furlan]

Hi Nigel,

Sounds crazy. I won't even try.
I am searching for alternative views, literally.

Thanks for your help.