Developer forum

Forum » Development » Order Search filter using Custom order fields

Order Search filter using Custom order fields

E-mail notifications
Shiwanka Chathuranga Dynamicweb Employee
Shiwanka Chathuranga
Reply
Posted on 19/02/2024 09:57:17

OrderSearchFilter filter = new OrderSearchFilter();

filter.SearchCustomerFields = "OrderCustomfield=1";
var orderList = orderService.GetOrdersBySearch(filter);

any good example to search orders using Order custom fields?


Replies

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Posted on 19/02/2024 11:58:52
Reply

If you want to search for values in CUSTOM fields, set OrderSearchFilter.SearchInCustomOrderFields to true

SearchCustomerFields is searching in the CUSTOMER fields:

Searching for one word:
filter.SearchCustomerFields = "Nicolai";

Searching for a phrase
filter.SearchCustomerFields = "\"Nicolai Pedersen\"";

 
Shiwanka Chathuranga Dynamicweb Employee
Shiwanka Chathuranga
Posted on 20/02/2024 04:38:46
Reply

Hi Nicolai

Thanks for the explanation 

if i want to search one order custom field value, something like CustomerOrderfield=1, any possible way of doing it?

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Posted on 20/02/2024 08:32:39
Reply
This post has been marked as an answer

Currently not.

Best option is maybe to do a simple SQL on the database returning only the orderids using your criteria, and then pass those orderids to the orderservice.

BR Nicolai

Votes for this answer: 1
 
Shiwanka Chathuranga Dynamicweb Employee
Shiwanka Chathuranga
Posted on 20/02/2024 10:30:16
Reply

Thanks Nicolai

 

You must be logged in to post in the forum