Hi I have an order list created in views with 2 fields: order ID and order payment method. Each order can have multiple payment methods (every payment method gets own incremented id when attached to order).
order id1 with payment id1 order id2 with payment id2 and payment id3 order id3 with payment id4
This causes duplicate rows in second case.
Problem: How can I show only orders with the last payment method attached to them?
One solution would be to create one view with order id argument, showing only one row and sorted by payment id descending. Then using views field view module and create another view with order list without duplicates.
Question: is there a more simple solution without creating second view? Thank you.