Searching by lastModifiedDate
This sample shows how to create a customer, and then search for the customer that was created based on a specific time frame. In this case, the sample uses the lastModifiedDate field to search “within” a couple of seconds before the customer was created and then a minute after. The search returns the record that was previously created.
Java
Customer c = (Customer) new TestCustomer().createMinimalRecord();
Calendar timeFrom = Calendar.getInstance();
WriteResponse wr = sessMgr.getPort().add(c);
outputResult(wr.getStatus().isIsSuccess());
Calendar timeTo = Calendar.getInstance();
timeTo.setTimeInMillis(timeTo.getTimeInMillis() + 60000);
CustomerSearch cs = new CustomerSearch();
CustomerSearchBasic csb = new CustomerSearchBasic();
SearchDateField sdf = new SearchDateField();
sdf.setOperator(SearchDateFieldOperator.within);
sdf.setSearchValue(timeFrom);
sdf.setSearchValue2(timeTo);
csb.setLastModifiedDate(sdf);
cs.setBasic(csb);
SearchResult sr = sessMgr.getWrappedPort().search(cs, this);
SOAP
<searchRecord xsi:type="ns1:CustomerSearch"
xmlns:ns1="urn:relationships_2017_1.lists.webservices.netsuite.com">
<ns1:basic xsi:type="ns2:CustomerSearchBasic"
xmlns:ns2="urn:common_2017_1.platform.webservices.netsuite.com">
<ns2:lastModifiedDate operator="within" xsi:type="ns3:SearchDateField"
xmlns:ns3="urn:core_2017_1.platform.webservices.netsuite.com">
<ns3:searchValue xsi:type="xsd:dateTime">2007-02-10T00:16:17.750Z</ns3:searchValue>
<ns3:searchValue2 xsi:type="xsd:dateTime">2007-02-10T00:17:53.015Z</ns3:searchValue2>
</ns2:lastModifiedDate>
</ns1:basic>
</searchRecord>
Related Topics
- search
- Basic Searches in SOAP Web Services
- Joined Searches in SOAP Web Services
- Advanced Searches in SOAP Web Services
- Joining Through Custom Fields
- Setting Valid Search Values
- Setting the anyof, mine, or myteam Filtering Values
- Understanding Sorting in Advanced Search
- Search-Related Sample Code
- Searching for a Multi-select Custom Field
- Search Issues and Best Practices for SOAP Web Services and SuiteScript