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

Does anyone know how to do a simple search/get to get all stored sales orders? Right now I'm creating a SalesOrder RecordRef, and I must specify the internalId of the particular SalesOrder I am looking for. I would rather just pull all the Sales Orders we have (which is quite low, even in production)

```public static IEnumerable&lt;Record&gt; GetAllSalesOrders()
{
    List&lt;Record&gt; results = new List&lt;Record&gt;();

    TransactionSearch transactionSearch = new TransactionSearch
    {
        basic = new TransactionSearchBasic
        {
            type = new SearchEnumMultiSelectField
            {
                @operator = SearchEnumMultiSelectFieldOperator.anyOf,
                operatorSpecified = true,
                searchValue = new string[] { "_salesOrder" }
            }
        }
    };

    var session = LoginHelper2.Instance;

    if (session != null)
    {
        var response = session.search(transactionSearch);

        if (response.totalRecords &gt; 0)
        {
            for (int i = 1; i &lt;= response.totalPages; i++)
            {
                results.AddRange(response.recordList);

                if (response.pageIndex &lt; response.totalPages)
                {
                    response = session.searchMoreWithId(response.searchId, i + 1);
                }
            }
        }
    }

    return results;
}```

Thanks Jeff! I realize now that many of my attempts to get all the Sales Orders was failing, because I forgot that NetSuite sends search information in pages of 10.

sure thing. glad you got it working :slightly_smiling_face: