[Chap Moore]

I am trying to query records and getting inconsistent results. Sometimes it will return a positve answer and other times it will not. In the usage log it shows as going through and returning no results and then you run it again and it will return the result.

$service = new NetSuiteService();

$service->setSearchPreferences(false, 20);

$contactSearch = new ContactSearch();

$contactSearchBasic = new ContactSearchBasic();//SearchRecordBasic

$contactSearchBasic->email = new SearchColumnStringField();

$contactSearchBasic->email->searchValue = ‘XXX@XXX.com’;

$contactSearchBasic->email->operator = SearchStringFieldOperator::is;

$contactSearch->basic = $contactSearchBasic;

$searchRequest = new searchRequest(); //% contains a searchRecord

$searchRequest->searchRecord = $contactSearch;

$searchResponse = $service->search($searchRequest);

Any answers to this would be helpful
This is a cached copy. Click here to see the original post.

[ktarog]

Hi Chap,

Could you try other operators and see if you can get more consistent results?

Other operators to try

– contains

– startswith

– any

[Author]

Posts