#StackBounty: #magento2 #module #sales-order-grid Get additional_information from sales_order_payment to show in backend sales order grid

Bounty: 50

I have a custom sales order grid module I want to extend, to show the information from the field additional_information, in the table sales_order_payment.

I have this right now, but it ain’t showing the payment method like Invoice or Credit Card, only the payment provider.

Path:

appcodeVendorSalesOrderGridviewadminhtmlui_componentsales_order_grid.xml

Code:

    <column name="payment_method" component="Magento_Ui/js/grid/columns/select">
        <settings>
            <filter>select</filter>
            <options class="MagentoPaymentUiComponentListingColumnMethodOptions"/>
            <dataType>select</dataType>
            <label translate="true">Payment Method</label>
            <visible>false</visible>
        </settings>
    </column>

The data in additional_information is stored like this:

{"svea_order_id":0000000,"country_id":"SE","method_title":"Svea 
Checkout","svea_payment_method":"INVOICE","svea_queue_id":"0000000"}

or

{"svea_order_id":0000000,"country_id":"SE","method_title":"Svea 
Checkout","svea_payment_method":"SVEACARDPAY_PF","svea_delivery_id":0000000}

And I want to fetch the data INVOICE and SVEACARDPAY_PF and others to show in the sales order grid.

Thank you,


Get this bounty!!!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.