Skip to Content (Press Enter)
UserImage.jpg
Wai Ling Wong
16Views
3Comments
Solved
Update a record based on 2 identifiers
Question
Aggregate
Reactive
Application Type
Reactive

I'm trying to create a balance table of customers' currencies

Each customer has 2 currencies with different amounts

e.g.

Customer A  |  USD | 100 

Customer A | HKD | 800 

Customer B  | USD | 100 

...


When there is a transaction (e.g. Customer A receives 50 USD), it creates a new record of balance instead of updating the existing one.

Customer A | USD | 50  (New record)

Customer A  | USD |100 

Customer A | HKD | 800 

Customer B  | USD | 100 

...


How can I update the record according to the customer and the currency to achieve the following outcome?

Customer A | USD | 150  (Update the existing record)

Customer A | HKD | 800 

Customer B  | USD |  100 

...


Many thanks!!!



2022-03-02 01_42_59-ExchangeTable.png
0
0
01 Mar 2022
Copy Link
2019-04-23 11-32-25
Muhammed Riyas
Solution

Hi Wong,


Try to execute this logic.



Regards,

Riyas

See solution in context
3
0
01 Mar 2022
Copy Link
2021-04-17 09-53-48
José Gonçalves
Solution

Hi Wong,

you need to query the database before inserting any new record. 

  • In that query you must verify if the combination User | Currency already exists.
  • Sum the existing value in the database with the new value and Update the table instead of creating a new record

Regards


1
0
01 Mar 2022
Copy Link
2019-04-23 11-32-25
Muhammed Riyas
Solution

Hi Wong,


Try to execute this logic.



Regards,

Riyas

3
0
01 Mar 2022
Copy Link
UserImage.jpg
Wai Ling Wong

Thank you @Muhammed Riyas and @José Gonçalves!!! It works!!!

0
0
02 Mar 2022
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.