none
Unable to sort the BDC list column

    Pertanyaan

  • Hi All

    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 very urgent.


    Regards,
    Kishore

    Kishore

    23 Februari 2012 15:49

Jawaban

  •  

    Hi Kishorekv,

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

    Thanks,

    Jack


    24 Februari 2012 6:08