none
Unable to sort the BDC list column

    질문

  • 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

    2012년 2월 23일 목요일 오후 3:49

답변

  •  

    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


    2012년 2월 24일 금요일 오전 6:08