I created a BDC list. Sorting is not working for the some of the columns which are system.string type and in data base it is varchar. More over the BDC list is enable with filter criteria. So can any one please help me to solve this issue. This is
I’m not sure there is whether an blank spaces in your SQL . for example, SELECT NAME AS "FIRST NAME" FROM Test, if it contains the blank spaces, the sort will not work.
you can modify it to like the following .
<TypeDescriptor TypeName="System.String" Name="NAME">
<LocalizedDisplayName LCID="1033">FIRST NAME </LocalizedDisplayName>