Hi @RKumar_WMF, this looks like a change that should be implemented on Gravy's end as we currently do not have access to the card details and also we do not pass the card scheme with the transaction for card transactions.

Chaos crew completed tasks

• T427847: Adyen blik transaction incorrect order_id, backend_gateway_txn_id - Adyen blik transaction incorrect order_id, backend_gateway_txn_id
• T431327: Prevent to assign order id to processor_contact_id - Prevent to assign order id to processor_contact_id
• T431776: finance_batch_generate failed to return vendor for checkoutcome - finance_batch_generate failed to return vendor for checkoutcome
• T432872: Unset or unmapped payment_submethod for dlocal via gravy results in incorrect payment method = cash in Civi - Unset or unmapped payment_submethod for dlocal via gravy results in incorrect payment method = cash in Civi
• T431230: Bug with move of venmo to gravy - the gr4vy ID rather than the braintree ID is being stored as the braintree ID - Bug with move of venmo to gravy - the gr4vy ID rather than the braintree ID is being stored as the braintree ID
• T431231: Stripe audit - currency rejected as not upper case - Stripe audit - currency rejected as not upper case

Feature team completed tasks

• T423232: Yape payment method in Peru - Yape payment method in Peru
• T422391: Bre-B Payment method in Colombia - Bre-B Payment method in Colombia
• T416702: Cancel Double Opt-In activities if donor later opts out. - Cancel Double Opt-In activities if donor later opts out.

Gravy sent the test tokens imported from the Adyen tokens, we are currently in the process of ingesting those for testing.

A total of 39900 active Adyen IDeal tokens have been sent to Adyen for export to Gravy. Awaiting feedback from Adyen and Gravy.

A total of 6780 active Adyen SEPA tokens have been sent to Adyen for export to Gravy. Awaiting feedback from Adyen and Gravy.

A total of 1625 active Adyen ACH tokens have been sent to Adyen for export to Gravy.

This is currently blocked as we have sent the full list to Adyen of active recurring tokens and waiting to hear back from them.

Hi @Priyankar22, thanks for working on this. On my last comment on your patch, I mentioned making the styles for the paused card on the manage donation page match that of the paused card on the homepage. What I was referring to was the card and the status text background color as shown in the image below.

Chaos crew completed tasks

• T430992: check value pass in sleep - check value pass in sleep
• T430784: Acoustic job throwing omni mystery errors - Acoustic job throwing omni mystery errors
• T431328: Add more info for refund in different currency log for invetigate - Add more info for refund in different currency log for invetigate
• T431778: chargeback_reversed failed to get gross in RecurDonationMessage - chargeback_reversed failed to get gross in RecurDonationMessage
• {T412534} - Why do a few donors have a last name and no first name?
• T424766: missing partial name from 3rd party response - missing partial name from 3rd party response
• T431459: Validation error during recurring charge, in field: last_name - Validation error during recurring charge, in field: last_name
• T423155: Ensure country from form is saved to civicrm_contribution_recur_smashpig.original_country - Ensure country from form is saved to civicrm_contribution_recur_smashpig.original_country
• T413671: Trouble donating via Venmo does not move to TY page automatically + error message displayed still charged - Trouble donating via Venmo does not move to TY page automatically + error message displayed still charged
• T409471: Recurring ACH looks like a success but then is actually failed - Recurring ACH looks like a success but then is actually failed
• T431468: Omnirecipient.load null return - Omnirecipient.load null return
• T431004: Remove "Changes must be made" in Paypal note when recurring donation is not active - Remove 'Changes must be made' in Paypal note when recurring donation is not active
• T430183: Improve inclusion and display of cancelled/failed recurrings in donor portal - Improve inclusion and display of cancelled/failed recurrings in donor portal
• T430699: Venmo donation missing PII in Civi 6/28/26 - Venmo donation missing PII in Civi 6/28/26
• T431882: Silverpop export very slow to build has_recur table when update_world is large - Silverpop export very slow to build has_recur table when update_world is large
• T431508: SearchDisplay totals aggregation select per column doesn't seem to save changes after 6.17 upgrade - SearchDisplay totals aggregation select per column doesn't seem to save changes after 6.17 upgrade
• {T352728} - Enable detailed civicrm logs for non-admin users.

Feature team completed tasks

• T429831: Add Settings to enable ComboWiki SpecialPage - Add Settings to enable ComboWiki SpecialPage
• T430258: Stripe audit - chargeback reversals not handled - Stripe audit - chargeback reversals not handled
• T299566: translations needed for japan form - translations needed for japan form
• T428019: Add Vue.js SPA to ComboWiki Special Page - Add Vue.js SPA to ComboWiki Special Page
• T424083: Get Paypal Fundraise Up Audit reports coming in by SFTP - Get Paypal Fundraise Up Audit reports coming in by SFTP
• T430603: Adyen batches duplicating MiscFees - Adyen batches duplicating MiscFees
• T427981: Add ComboWiki To Donation Interface - Add ComboWiki To Donation Interface
• T430572: Initial checkout.com setup and testing - Initial checkout.com setup and testing
• T430011: Preference Centre: Confirm Activites will be descriptive - Preference Centre: Confirm Activites will be descriptive

Hi @krobinson 39206274 had already been cancelled at the time of running the query as such it didn't fulfil the set requirement to be added to the list. I'd check again to see if I missed anything.

Using this query, I was able to pull out contacts that tried to cancel but failed:

@Dwisehaupt apologies I was unaware the environment variables were your blocker yesterday. Now that I'm up to speed, I think your suggestions would work and is probably the way to go.