How to use sortingExpression on List Request in BDE

unknown

Hi All,

Hope you all are doing well.

I am trying to get the data using BDE and List Method based on some sorting expression.  can you pls help me.

<emp:List>
<ListRequest>
<!--Optional:-->
<ControlArea>
<!--Optional:-->
<sortingExpression>firstDateOfEmployment asc</sortingExpression>
<!--Optional:-->
</ControlArea>
</ListRequest>
</emp:List>

and getting below error

<S:Envelope xmlns:S="">schemas.xmlsoap.org/.../">
<S:Body>
<S:Fault xmlns:ns4="">www.w3.org/.../soap-envelope">
<faultcode>S:Server</faultcode>
<faultstring>No valid sortingExpression received (a non-empty sortingExpression is not supported).</faultstring>
<detail>
<Result:Result xmlns:Result="">www.infor.com/.../Employee_v2" xmlns="">www.infor.com/.../Employee_v2">
<messageCode xmlns:ns7="">www.infor.com/.../Employee_v2" xmlns="">tlbctsb0050</messageCode>
<messageType xmlns:ns7="">www.infor.com/.../Employee_v2" xmlns="">Error</messageType>
<messageText xmlns:ns7="">www.infor.com/.../Employee_v2" xmlns="">No valid sortingExpression received (a non-empty sortingExpression is not supported).</messageText>
<messageSource xmlns:ns7="">www.infor.com/.../Employee_v2" xmlns="">Public Layer</messageSource>
</Result:Result>
</detail>
</S:Fault>
</S:Body>
</S:Envelope>

unknown

What I found is as of now it works for only below options

1) sortingExpression is set (XML Tag exist with Empty value) -- Database will decide which index to use.

2) sortingExpression is not set (No XML tag) -- Will always use index_1

3) sortingExpression is set (XML Tag exist with Any value) -- this is for Future enhancement and does not work yet. 

Please correct me if anyone have different observation.