Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Error using search.lookupFields(options) with joined fields
I am getting a 'SSS_INVALID_SRCH_COLUMN_JOIN' error when I use search.lookupFields(options) and use the syntax 'join_id.field_id' in the columns.
This works fine:
var myLookup = search.lookupFields({
type: search.Type.PURCHASE_ORDER,
id: poId,
columns: ['entity','tranid']
});
But this doesn't:
var myLookup = search.lookupFields({
type: search.Type.PURCHASE_ORDER,
id: poId,
columns: ['entity','tranid','entity.phone']
});
The error implies 'entity' is wrong when trying to use it as a join. Maybe 'entity.' is not a valid join_id, but I cannot find any documentation to tell me what a valid join_id should.
0