Community
Showing results for 
Search instead for 
Do you mean 
Reply

Odata $oderby on customFields

Copper Contributor
Posts: 32
Country: Germany

Odata $oderby on customFields

Hi,

 

I read quite a few posts on using $select | $expand or $filter on customFields, but haven't seen anyone mention $orderby, so here I go.

 

I'm trying to filter products in a certain Opportunity by a custom field. So, something like:

 

.../api/opportunites/{some-Opp-ID0}/products?$orderby=customFields/MyCustomField

 

However, through Postman I get a "unable to sort on this column" as a result.

 

Admittedly, using $filter, $select or $expand on customFields under products didn't work either so far in my tests, so I'm either doing something very basic very wrong, or all of this is not yet implemented in that part of the data. Which one is it?

Highlighted
Copper Contributor
Posts: 32
Country: Germany

Re: Odata $oderby on customFields

It's been two weeks. Any feedback on this?
Employee
Posts: 70
Country: USA

Re: Odata $oderby on customFields

Your syntax is correct, but ordering on custom fields are not supported yet.  I will bring this up to product owner to see if we can get this added.

 

        /api/opportunites/{some-Opp-ID0}/products?$orderby=customFields/MyCustomField

Copper Contributor
Posts: 32
Country: Germany

Re: Odata $oderby on customFields

So same as expand and the rest then, ok. Thanks for clarifying, Stephen. Smiley Happy