Forum Discussion

Jayshamone's avatar
Jayshamone
Helper I
5 years ago
Solved

Multiple Payment Methods in one Transaction

Hello,   we want to give our customers an overview of what they have purchased using their individual voucher code. The basic setup would be this: There is a transactions table connected to a tra...
Need Help
  • Jayshamone's avatar
    Jayshamone
    5 years ago

    I found a solution which gets the correct results, but might be rather inefficent when handling large amount of data.

    Basically, you can use another table including all combinations of payment ID and transaction ID which you can use for filtering. Relate that to the transactions table and leave the rest as it is. This should grant you the correct results.

     

     

    Thanks for your help

    If you have any idea how to manage this more efficiently, I'd be thankful

Jayshamone's avatar
Jayshamone
Helper I
5 years ago

I found a solution which gets the correct results, but might be rather inefficent when handling large amount of data.

Basically, you can use another table including all combinations of payment ID and transaction ID which you can use for filtering. Relate that to the transactions table and leave the rest as it is. This should grant you the correct results.

 

 

Thanks for your help

If you have any idea how to manage this more efficiently, I'd be thankful