Discussions
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
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” ),