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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello Jayshamone ,
Can you please provide the sample data after removing the sensitive data?
What is the use of cross join here?

  • Jayshamone's avatar
    Jayshamone
    Helper I
    5 years ago

    Thanks for your quick response.

    Without the crossjoin, I gett all the transactions in the selected timeframe.

    Here are some sample data for one voucher code: