Unable to sort the BDC column which contain space
Let me explain you with an example, If you have table like described below and you would like to show the “Name” field as “First Name”.
Table Name :- employee_test
Create the view using the following SQL command
Create view view_employee as SELECT ID, NAME AS "FIRST NAME", LOCATION, AGE FROM EMPLOYEE_Test
Generally you create a application definition file view_employee.xml and add the Type descriptor like this ;-
<TypeDescriptor TypeName="System.String" Name="FIRST NAME" />
and now if you try to sort the Business Data List web part , you won’t get the correct result. To resolve this use the following SQL command :-
create view view_employee as SELECT ID, NAME , LOCATION, AGE FROM EMPLOYEE_Test
Change the type descriptor for your localized version (In my example I changed for English-Us so the LCID is 1033) in the application definition file. I fetched the Name without using the space but changed it for the display purposes.
<TypeDescriptor TypeName="System.String" Name="NAME">
<LocalizedDisplayName LCID="1033">FIRST NAME </LocalizedDisplayName>