I have attached 3 contacts to a Sales Order from UI. There is Contacts sub list under Relationships tab. I have selected contact from Contact List, attached the contact with sales order by clicking Attach button. I want to retrieve the first name, last name phone of the first contact of the sales order using suitescript. Can anyone help me to get this.

do a contact search with a filter on the transaction join to limit your result rows

Does contact search has search join option of transaction e.g, Sales Order ?

this is something you can confirm yourself: Contact Search

I have have not seen any option like Sales Order or Transaction in Type list

what are you looking at?

I want to get list of contacts that is attached to a sales order.

reasonable, however i dont know how

I have have not seen any option like Sales Order or Transaction in Type list (edited)

relates to my suggestion, which was to use a contact search

Thanks. I created a contact saved search with with transaction join. I got the desired result

Out of curiosity, @battk do you know if the same can be achieved with query request?

a quick look suggests no

Thank you!