Broken Action FindMandate

[GFF-DS]

Using FindMandate with Search Action Designer raises a fatal error with message Invalid field 'id desc'. It raises a corresponding error, whatever value for the pick field is chosen.

• CiviCRM Core 6.1.2
• Action Provider 1.177
• Search Action Designer 1.31
• CiviSEPA 1.13.0-alpha3

[bjendres]

Tahnks for reporting, @GFF-DS.

Could you please test the version in https://github.com/Project60/org.project60.sepa/tree/757-broken-find-mandate?

If that works for you I would still put this into 1.13.0, but I don't want to wait too long with the 1.13 release

[GFF-DS]

Thanks @bjendres!

I tested the branch with

• CiviCRM Core 6.4.1
• Action Provider 1.181
• Search Action Designer 2.0.3

The same problem still exists. It's raised in civicrm-core/Civi/Api4/Query/Api4SelectQuery.php:284

[bjendres]

The same problem still exists. It's raised in civicrm-core/Civi/Api4/Query/Api4SelectQuery.php:284

Ok, thank you. I'm back from my holidays now, and will try to have a go at it this week.

[GFF-DS]

Here's a search action to test / reproduce:

{
    "title": "Test",
    "name": "test",
    "success_message": "Action done",
    "type": "contact",
    "is_active": "1",
    "records_per_batch": "25",
    "configuration": {
        "summary": "",
        "weight": "0"
    },
    "fields": [],
    "actions": [
        {
            "name": "find_sepa_mandate",
            "title": "Find SEPA Mandate",
            "type": "FindMandate",
            "mapping": {
                "contact_id": "id",
                "account_holder": "",
                "iban": "",
                "reference": ""
            },
            "configuration": {
                "type": "",
                "active": "",
                "pick": "id desc"
            },
            "weight": "1"
        }
    ]
}

[GFF-DS]

The same problem still exists.

Actually I was wrong. At least now the patch fixes the issue. Tested with

• Drupal 10
• CiviCRM Core 6.4.1
• Search Action Designer 2.0.3

There may be another issue with for example read the mandate reference from a found mandate, but my suggestion would be to separate both issues and thus merge this patch here and close this issue here. After I will eventually open a new issue for follow-up-problems.

Update: I just saw the difference in both test environments is Search Action Designer 2.0.3 vs. 1.31, maybe that affects the issue.