I would like to create simple orders list with chosen payment method.
Problem: If customer goes through checkout process at once (without returning from checkout review and changing payment method) there would be only one payment method for an order, which is ok.
However, if customer returns from checkout page and changes payment method and then completes checkout - the order has 2 payment methods attached to it.
Now, inside view I can add relationship to Commerce Order: Payment Transaction, which causes duplicates. So I choose Commerce Order: Representative payment transaction, which gives me only one payment method (Now I can use payment method field). Inside relationship I can select representative sort criteria - in my case it would be transaction id (descending). However, sorting does not seem to work. The view always outputs the first payment method chosen when creating the order.
Is anything wrong with the view or is it better option to delete the unused payment transactions?
Question: what is the recommended way of keeping only one (last) payment method.