OpenAccessDataSource Filtering (WITHIN)

Thread is closed for posting
2 posts, 0 answers
  1. SuperXRAY
    SuperXRAY avatar
    82 posts
    Member since:
    Feb 2007

    Posted 04 May 2009 Link to this post

    This is a rather advanced option, but is there or does someone have a good working suggestion, for filtering with the OADS using an IN or WITHIN type of statement?

    I have a RadGrid that reads ObjectA via an OADS, but it needs to read ObjectA WHERE ObjectA.OwnerPerson NOT IN (ObjectB).
    ObjectB just represents a LIST of people that the OwnerPerson is avoiding.

    I can accomplish this easily in MS SQL Queries, and SSRS has this invaluable feature. Is it easier than I'm making it out to be?

    I don't want to rewrite a bunch of things, but if I can just put this in the OpenAccessDataSource1_Selecting event, that would suit me just fine.
  2. Thomas
    Thomas avatar
    590 posts

    Posted 07 May 2009 Link to this post

    Hi SuperXRAY,

    currently the generation of SQL IN clauses is only supported by our LINQ implementation, which is not (yet) used by the data source implementation. The best workaround is to make a not( a=x or a=y or a=z) statement.
    I will put this forward as a feature request: Support for (negated) IN clauses in OQL  and data source.

    Thanks for your input,
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
Back to Top