- Posts: 41
- Thank you received: 0
Question about 'donor_id' from _jd_field_value table
- Dave
- Topic Author
- Offline
- Senior Member
Less
More
10 months 2 weeks ago #164124
by Dave
Question about 'donor_id' from _jd_field_value table was created by Dave
The _jd_donors table has 'id'.
'id' is auto_increment.
"id' will increment each time a record is written to the table, regardless of whether the transaction fails or is canceled.
If a rollback occurs due to transaction fail or cancel, 'id' does not decrement.
The _jd_field_value table has 'donor_id'.
What are the conditions for incrementing 'donor_id'?
Will 'donor_id' increment if a transaction fails or is canceled?
Basis: I want to use 'donor_id' as a sequential Member Number for each successful donor.
If it works correctly, the most recent Member Number should always match the total NumberDonors.
In other words, 'donor_id' should only increment for successful transactions. It should not increment for failed or cancelled transactions.
Is this how 'donor_id' works in JoomDonation?
Thanks.
'id' is auto_increment.
"id' will increment each time a record is written to the table, regardless of whether the transaction fails or is canceled.
If a rollback occurs due to transaction fail or cancel, 'id' does not decrement.
The _jd_field_value table has 'donor_id'.
What are the conditions for incrementing 'donor_id'?
Will 'donor_id' increment if a transaction fails or is canceled?
Basis: I want to use 'donor_id' as a sequential Member Number for each successful donor.
If it works correctly, the most recent Member Number should always match the total NumberDonors.
In other words, 'donor_id' should only increment for successful transactions. It should not increment for failed or cancelled transactions.
Is this how 'donor_id' works in JoomDonation?
Thanks.
Please Log in or Create an account to join the conversation.
- Mr. Dam
- Offline
- Administrator
Less
More
- Posts: 12827
- Thank you received: 1661
10 months 2 weeks ago #164145
by Mr. Dam
Replied by Mr. Dam on topic Question about 'donor_id' from _jd_field_value table
Hi Dave,
donor_id in table #__jd_field_values is id in table #__jd_donors.
Joom Donation will use ID in table #__jd_donors to update into the records in table #__jd_field_values
Thanks
Dam
donor_id in table #__jd_field_values is id in table #__jd_donors.
Joom Donation will use ID in table #__jd_donors to update into the records in table #__jd_field_values
Thanks
Dam
Please Log in or Create an account to join the conversation.
- Dave
- Topic Author
- Offline
- Senior Member
Less
More
- Posts: 41
- Thank you received: 0
10 months 2 weeks ago #164149
by Dave
Replied by Dave on topic Question about 'donor_id' from _jd_field_value table
OK.
Then I need to pay for custom work.
I will start a ticket.
Thanks.
Then I need to pay for custom work.
I will start a ticket.
Thanks.
Please Log in or Create an account to join the conversation.
Moderators: Mr. Dam, Dũng Nguyễn Việt
Support
Documentation
Information
Copyright © 2024 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.