locked
Unable to sort the BDC list column RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    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

    Thursday, February 23, 2012 3:49 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
     

    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


    Friday, February 24, 2012 6:08 AM
    Moderator