Filter criteria in BDC list RRS feed

  • Question

  • Hi All,

    I created a BDC list with filter enable criteria with wildcard character. but the filter is not working for "is equal to", "ends with". It is working fine with "contains" and "starts with".
    Here is the code for the sql command.
    Select * from [dbo].[tickets] where [Ticket ID] Like @TicketID
    I even tried changing the Like to = but no use. So can anyone provide solution for this.

    Thanks in advance,


    • Moved by Jack-GaoModerator Thursday, February 23, 2012 7:04 AM this is Business Data Catalog(Pre-SharePoint)) (From:SharePoint - Accessibility (pre-SharePoint 2010))
    Tuesday, February 21, 2012 8:44 AM