Custom view does not return results when searched by date

Technote (FAQ)


Question

Custom view does not return results when date range is passed to extended API created for the view.

Answer

To fetch the records based on the modfiyts or createts for a extended (custom) view API below format should be used.

The xml should be of this format; FromModifyts="YYYY-MM-DDT00:00:00" ModifytsQryType="BETWEEN" ToModifyts="YYYY-MM-DDT00:00:00".

For example SampleXml should look like

<EXTNUpcInv IgnoreOrdering="Y" ItemID="" ItemIDQryType="" ItemShortDescription="" ItemShortDescriptionQryType="" OrganizationCode="DEFAULT" ShipNode="" ShipNodeQryType="" SupplyType="" UPCInvVwKey="" UPCInvVwKeyQryType="" FromModifyts="2012-04-25T00:00:00" ModifytsQryType="BETWEEN" ToModifyts="2012-06-25T00:00:00"/>

ModifyQryType should be "BETWEEN" for date range for custom views.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Sterling Order Management
Installation

Software version:

All

Operating system(s):

All

Reference #:

1605924

Modified date:

2012-11-09

Translate my page

Machine Translation

Content navigation