Storage of custom fees should use discrete names

[damienwebdev]

Is your feature request related to a problem? Please describe.
I'm trying to report on custom fees with JSON_EXTRACT in MySQL, however the data is stored in JSON like:

{"_1748965817694_694": {"code": "my-fee", "type": "percent", "title": "My Fee", "value": 12.5, "percent": "25", "base_value": 12.5, "show_percentage": true}} 

Maintaining the value of _1748965817694_694 in any reports I write is painful.

Describe the solution you'd like
It would be nice if instead this key were the code.

Describe alternatives you've considered
N/A

Additional context
N/A

[JosephLeedy]

Thank you for the ticket, @damienwebdev. The keys are automatically generated by the logic for adding rows to the serialized array configuration field (see line 111 of vendor/magento/module-config/view/adminhtml/templates/system/config/form/field/array.phtml). I plan to refactor the configuration in version 2.0 to use a separate admin page (with a grid), but until that happens, this cannot be changed, unfortunately.

Apologies, I misread your description of the issue and I thought that you were referring to the configuration. I now realize that you're talking about the records in the custom_order_fees table. Those records are fortunately easier to change, so I'll investigate doing so as time permits.

May I please a ask for an example of the report query that you're trying to run? I'd like to see if there are any improvements that can be made to the existing reporting functionality.

Thank you again!

[damienwebdev]

@JosephLeedy I think I can tackle this one myself, I'll submit a PR tomorrow.

[JosephLeedy]

Okay, thank you.