Search orders and sort by Meta Fields


I am searching for PurchaseOrders using the ordercontext.Search method. 

var orders = orderContext.Search<PurchaseOrder>(orderSearch, out count)

Here I can specify a where clause on the MetaField using the property SqlMetaWhereClause on the OrderSearchParameters. But how can i perform sort on the meta field.

Coming from version 7.5, we got away by writing the order by clause in the SqlMetaWhereClause itself. But after upgrading to the 13.26, its breaking with the error  -  The ORDER BY clause is invalid in views, inline functions, derived tables ..... as the underlying meta tables are converted to views.

Now is there any way I can do an order  by on meta fields?


Nov 11, 2020 15:36

I might be terribly outdated but I don't think the order tables have been converted to views. What were "converted" was catalog tables in Commerce 9

Nov 11, 2020 21:55
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.