Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Complex Query using SOAP ContractServiceV2
Hi,
I hope you can help me, I'm trying to get all active contracts filtering for a especific DFF value at line level.
Something like this:
Select *
from contract_table ct,
contract_lines ctl
where 1 = 1
and ct.contract_number = 4003
and ct.status = 'ACTIVE'
and ct.contract_id = ctl.contract_line
and ctl.attribute8 in (value1, value2) --tvsaPoid
But Using the SOAP ContractServiceV2 -> findContract operation:
I built the next payload (unfortunly it's not working):
<ns2:filter>
<ns2:group>
<ns2:conjunction>And</ns2:conjunction>
<ns2:upperCaseCompare/>
<ns2:item>
<ns2:conjunction>And</ns2:conjunction>
<ns2:upperCaseCompare/>
<ns2:attribute>ContractNumber</ns2:attribute>
<ns2:operator>=</ns2:operator>