This is a migrated thread and some comments may be shown as answers.

OpenAccessDataSource Filtering (WITHIN)

1 Answer 20 Views
Development (API, general questions)
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
SuperXRAY
Top achievements
Rank 2
SuperXRAY asked on 04 May 2009, 07:20 PM
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.

1 Answer, 1 is accepted

Sort by
0
Thomas
Telerik team
answered on 07 May 2009, 07:41 AM
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,
Thomas
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.
Tags
Development (API, general questions)
Asked by
SuperXRAY
Top achievements
Rank 2
Answers by
Thomas
Telerik team
Share this question
or