Hello,
I would like to search out a sales order with using .NET SDK.
I don't know how to search out the sales orders by ship to name or address. Is there any example?
I was trying this code,
Dim fType As String = ""
Dim fString As String = TextBox3.Text.Trim
Dim fContain As FilterExpression = FilterExpression.Contains(FilterExpression.Property("ShipToAddress.Name"),
FilterExpression.StringConstant(TextBox1.Text.Trim))
Dim fStartDate As FilterExpression = FilterExpression.GreaterThanOrEqual(FilterExpression.Property("SalesOrder.ShipByDate"),
FilterExpression.Constant(CDate(TextBox1.Text.Trim)))
Dim fEndDate As FilterExpression = FilterExpression.LessThanOrEqual(FilterExpression.Property("SalesOrder.ShipByDate"),
FilterExpression.Constant(CDate(TextBox2.Text.Trim)))
modifiers.Filters = FilterExpression.AndAlso(fStartDate, fEndDate)
modifiers.Filters = FilterExpression.AndAlso(modifiers.Filters, fContain)
list.Load(modifiers)
Thank you in advance,
Brian