Community
Showing results for 
Search instead for 
Do you mean 
Reply

Odata $oderby on customFields

Highlighted
Copper Super Contributor
Posts: 40
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?

Kind Regards,
Thomas
Melville-Schellmann GbR
Consulting and Development for CRM-Software
Copper Super Contributor
Posts: 40
Country: Germany

Re: Odata $oderby on customFields

It's been two weeks. Any feedback on this?
Kind Regards,
Thomas
Melville-Schellmann GbR
Consulting and Development for CRM-Software
Employee
Posts: 113
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 Super Contributor
Posts: 40
Country: Germany

Re: Odata $oderby on customFields

So same as expand and the rest then, ok. Thanks for clarifying, Stephen. Smiley Happy
Kind Regards,
Thomas
Melville-Schellmann GbR
Consulting and Development for CRM-Software
Nickel Contributor m4y
Nickel Contributor
Posts: 547
Country: Belgium

Re: Odata $oderby on customFields

Is it working now?


Xavier Nyssen

ACT! Certified Consultant @ Intuitis | Belgium
{ +32 64 45 08 00 | xavier@intuitis.be | http://intuitis.be }
Employee
Posts: 113
Country: USA

Re: Odata $oderby on customFields

This feature is in our backlog, it is scheduled for July release, but I am trying to find a solution to this.  We upgraded to the lastest OData libraries, which did fix some, but not all the issues with CustomFields.  Currently, $select $Expand, and $Orderby are still not working.