#StackBounty: #magento2 #collection #uicomponent Date Range filter not working in custom Grid Magento 2

Bounty: 50

I have created the custom sales report using ui component.

Grid is loading correctly. I have added the date range filter as like below.

<column name="created_at" class="MagentoUiComponentListingColumnsDate">
        <argument name="data" xsi:type="array">
            <item name="config" xsi:type="array">
                <item name="filter" xsi:type="string">dateRange</item>
                <item name="component" xsi:type="string">Magento_Ui/js/grid/columns/date</item>
                <item name="dataType" xsi:type="string">date</item>
                <item name="label" xsi:type="string" translate="true">Created At</item>
                <item name="dateFormat" xsi:type="string">Y-MM-dd HH:mm:ss</item>

Here is the screenshot of error.

enter image description here

In the filter section when the from and To date selected and applied,
I am getting Bad request error.

This is the error in Request

  {error: "UI component could not be rendered because of system exception", errorcode: "23000" }

error: “UI component could not be rendered because of system exception”
errorcode: “23000”

Can anyone check where i am wrong and help me to resolve this error.

Thanks in Advance

Get this bounty!!!

Leave a Reply

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