Multiple filters on typed datasource

Hi,

I have a webpage with a grid on it. This grid is bound to a typed datasource. I want to be able to search on a number of properties on this datasource (using an 'OR'-like query), but the results returned must belong to the currently logged on user (so, an 'AND'-query like 'AND ownerid = ....'). In SQL this query would look like 'SELECT ...... WHERE ownerid = 1 AND (name like '%something%' OR value like '%something%'). Can this be achieved using typed datasources and filters?

Currently my code looks like this:

<data:VDossierDataSource SelectMethod="getpaged" runat="server" ID="DSDossiers" EnablePaging="true" EnableSorting="true">

<Parameters>

<data:SqlParameter Name="WhereClause" UseParameterizedFilters="false">

<Filters>

<data:VDossierFilter Column="opdrachtgeverid" ControlID="__Page" PropertyName="OpdrachtgeverID"

ComparisionType="Equals" />

</Filters>

</data:SqlParameter>

</Parameters>

</data:VDossierDataSource>

Regards,

Fabian

...

'SELECT ...... WHERE ownerid = 1 AND (name like '%something%' OR value like '%something%').

... 

Fabian,

The support for grouping has been checked-in (rev. 558)

Try this:

<data:VDossierDataSource SelectMethod="getpaged" runat="server" ID="DSDossiers" EnablePaging="true" EnableSorting="true">
    <Parameters>
        <data:SqlParameter Name="WhereClause" UseParameterizedFilters="false">
            <Filters>
                <data:VDossierExpressionBuilder Column="opdrachtgeverid" ControlID="__Page" PropertyName="OpdrachtgeverID" BuilderExpression="AppendEquals" />
                <data:VDossierExpressionBuilder Column="name" DefaultValue="somevalue" BuilderExpression="Append" Format="%{0}%" GroupState="AndBegin" Junction="" />
                <data:VDossierExpressionBuilder Column="value" DefaultValue="somevalue" BuilderExpression="Append" Format="%{0}%" GroupState="End" Junction="OR" />               
            </Filters>
        </data:SqlParameter>
    </Parameters>
</data:VDossierDataSource>

which is equivalent to this:

VDossierExpressionBuilder searchQuery = new VDossierExpressionBuilder();
searchQuery.AppendEquals(VDossierColumn.opdrachtgeverid, "1");
searchQuery.BeginGroup("AND");
searchQuery.Append("", VDossierColumn.name, String.Format("%{0}%", "somevalue"));
searchQuery.Append("OR", VDossierColumn.value, String.Format("%{0}%", "somevalue"));
searchQuery.EndGroup();