Page tree
Skip to end of metadata
Go to start of metadata

The Data Filter Query configuration used by various Business Functions now supports a relative date option.

Enhancements

1.

The Data Filter Query "filterPeriod" now supports "LAST_DAYS" for periodType date columns.

2.New element under "filterPeriod" is required, "days", which specifies as an integer the number of days, prior to today, records retrieve.
3.

Example below pulls Return Orders "Pending Approval" for the last 30 days:

{
    "metadata":false,
    "totalRecords":false,
    "formatData":false,
    "dataFilter":
    {
        "firstResult":0,
        "maxResult":150,
        "filterIn":
        {
            "merchant.dbo.VwOrderStatusCalculated.orderStatusCode":["pendingApproval"]
        },
        "filterPeriod":
        {
            "merchant.dbo.OrderHeader.createDate":
            {
                "periodType":"LAST_DAYS",
                "utcOffsetStart":"-04:00",
                "utcOffsetEnd":"-04:00",
                "days":30
            }
        },
        "orderBy":
        {
            "merchant.dbo.OrderHeader.createDate":"asc"
        }
    }
}

Business Benefit

Continual improvements of EDGE Business Functions.




  • No labels