IBM Support

Custom view does not return results when searched by date

Technote (FAQ)


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


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.

Document information

More support for: Sterling Order Management

Software version: All

Operating system(s): Platform Independent

Reference #: 1605924

Modified date: 06 December 2014