Unable to sort the BDC column which contain space

  • Articolo

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

Table description
ID NUMBER
NAME VARCHAR2(20)
LOCATION VARCAHR2(20)
AGE NUMBER

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">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">FIRST NAME </LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>