[kentroylance]

I am having a dickens of a time trying to figure out how to get the contacts from a partner. Even though I see that there is a contact field for the Partner record, I am not able to get that value. I can set the contact value, but not retrieve. I would appreciate any help on this. Thanks. Here is some of my code:

var filters = new Array();

filters[0] = new nlobjSearchFilter(‘internalid’, null, ‘is’, input.id);

var columns = new Array();

columns[0] = new nlobjSearchColumn(‘internalid’);

columns[1] = new nlobjSearchColumn(‘contact’); Error: An nlobjSearchColumn contains an invalid column, or is not in proper syntax: contact.”

var results = nlapiSearchRecord(‘partner’, null, filters, columns);
This is a cached copy. Click here to see the original post.

[david.smith]

You should reverse your search logic. A “contact” can belong to more than one partner and/or entity. Try something like this.

Code:
nlapiSearchRecord(‘contact’,null,[[‘partner.internalid’,’anyof’,164]])

[kentroylance]

Thanks David!, that is just what i was looking for.

[Author]

Posts