I need to select Customers from Netsuite and filter Customers by Subsidiary I set as filter field Customer.subsidiary. But it doesn't work when I set Id as a parameter value. Is it possible to filter records by internlId of related record?
Hi Vadim Reznichenko
You need to pass the static value as "Subsidiary Name" not the internal id at parameters.
Please check that will work for you
Thanks. Do you mean that for any related object I have to use the name of the related record?
In Netsuite at connector level to pass a parameter to some other related record, we need to pass query filer based on that related record name instead of internal id.
Vinay, thanks. It works but if a name of a record contains the comma. It will be separated to some names. Could you please advice on what we have to do in this case?
If you check that XML response of the record which you query from NS, if that related record has a comma-separated two values you can pass that itself as the query at the connector,It will work for you.
Please try and let me know in case any issue
I mean next:
value2= subname2, inc
Retrieving data ...