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:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.