This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I can't figure out how to query this field. It shows on the transaction but it's nowhere in the search record structure. Or, I should say; I can query the field I believe it _should_ be, but it comes back empty.

It's also there when joining to the `contact (primary) fields...` on a transaction search

I'm querying from `contact`, joining to the tran internalid, and pulling `contactrole`. Nada.

`contactprimary` will only return the primary role.

There's no way I can find to reproduce that sublist via search.

Oh you mean using the query/analytics module, not saved search, right?

er, no, haven't tried query/analytics, just doing saved search, then migrating to script

I'm not sure what you mean then, the field is there on a contact search

Oh like only the primary contact is there, not the others?

I can get the primary, yes. Any other contacts I can get by querying `contact` and joining via tran internalid, but I can't get the roles associated with them.