Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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:

Code Block
languagetext
{
    "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.