3

I have OdataService with CustDetails table (I am using Entity Framework). In the table I have column PostalCode of string type. When I sort the data it working fine. It sort the data by considering it as string type. But my requirement is, in my PostalCode all values are integer value only , so I need to sort the data by considering it as integer type. Is it possible to change the field data type while sorting ?

Actual sorted Result:

100,
1100,
12,
2,
200

But My expected result is

2,
12,
100,
200,
1100

Please help me to overcome this. Note: I am not able to change the data type in database.

scott_lotus
  • 3,171
  • 22
  • 51
  • 69
Sunil Prabakar
  • 442
  • 1
  • 5
  • 19

1 Answers1

0

OData doesn't support conversion of primitive types in the query. See Odata Query String Options

You could, however, write a service operation to handle this for you (assuming your query provider supports this).

S.Dav
  • 2,436
  • 16
  • 22