Discussions
Joined search for Sales orders and Transfer orders
I want to search the transactions “Sales Orders” and “Transfer Orders” jointly. The following conditions work fine separately without any problem. I want to join these to make a single call.
Can you help in joining these ?
Thanks.
$transactionsearch = new nsComplexObject(‘TransactionSearchBasic’);
$transactionsearch->setFields( array( ‘type’ => array( ‘operator’ => ‘anyOf’, ‘searchValue’ => “_salesOrder” ),
‘internalIdNumber’ => array( ‘operator’ => ‘greaterThan’, ‘searchValue’ => $last_id),
‘status’ => array( ‘operator’ => ‘anyOf’, ‘searchValue’ => ‘_salesOrderPendingFulfillment’),
‘paymentEventResult’ => array(‘operator’ => ‘noneOf’, ‘searchValue’ => ‘_paymentHold’),
‘customFieldList’ => array ($CustomBodyField1,$CustomBodyField2,$CustomBodyField3)
));
OR
$transactionsearch = new nsComplexObject(‘TransactionSearchBasic’);
$transactionsearch->setFields( array( ‘type’ => array( ‘operator’ => ‘anyOf’, ‘searchValue’ => “transferOrder” ),