Dynamics CRM 2016 (Online) WebAPI Query

(0) Share

Report

Posted on by filbert

I want to make string desc as int desc while using web api query.

ex) string desc -> 2, 10, 1
    int desc -> 10, 2, 1



Query : new_projects?$select=new_dt_start,new_txt_project_no&$orderby=new_txt_project_no desc

Is there any way?

*This post is locked for comments

All responses (3)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Dynamics CRM 2016 (Online) WebAPI Query

Hi Filbert

What I'm sure would work is a third party CTI that I've been using for quite some time now which is called Tenfold. They have click to dial and features like screen pop up on incoming and outgoing calls, easy note and task creation, handling multiple matches and creating new leads when no contact match from CRM. They also suppport MS Dynamics integration. Here is a complete list of www.tenfold.com/.../dynamics
Verified answer

Nithya Gopinath 17,074 on at

Like (0)

Report

RE: Dynamics CRM 2016 (Online) WebAPI Query

Hi Filbert,

If the field new_txt_project_no is a whole number field, then you can achieve this by the query you have given above. Otherwise, you need to create a new whole number field and copy the string to the whole number field.

See: community.dynamics.com/.../154056

Hope this helps.
Suggested answer

jlattimer 24,558 on at

Like (0)

Report

RE: Dynamics CRM 2016 (Online) WebAPI Query

You can't do this in the query itself - you'd need to store a numeric version of the string on the record and sort by that field.