filter expressions as a string?

[mac]

heya.. I know I saw this in use in one of the demos but can't find it any longer. I have a grid with the following
<telerik:radgrid id="Radgrid1" FilterExpression= "[column] = 'TextValue' ....>
I also have a checkbox control on the page to quicly just filter out the items that have a count greater than zero.

Is there a reason I can't build a filter expression using regualar t-sql?


code snippet.

Protected Sub appfilter_CheckedChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles appfilter.CheckedChanged

        RadGrid1.MasterTableView.FilterExpression = Nothing
        If appfilter.Checked = True Then
                    RadGrid1.MasterTableView.FilterExpression = "(([Icount] > '0' and [ActivityStatus] = 'Vacant') or [Ecount] > '0')" ' consider the first two items or consider the third.
            RadGrid1.MasterTableView.Rebind()

        Else
            RadGrid1.MasterTableView.FilterExpression = "([ActivityStatus] = 'Vacant')"
            RadGrid1.MasterTableView.Rebind()
        End If

    End Sub

[Shinu]

Hi Mac,

I hope you are trying to set the FilterExpression for the Grid in the aspx. If so try setting it as shown below.

ASPX:

<telerik:RadGrid ID="RadGrid1" runat="server" Skin="WebBlue"     AllowSorting="true"   PagerStyle-HorizontalAlign="right" AllowMultiRowSelection="true" DataSourceID="SqlDataSource1"   >
                <MasterTableView FilterExpression="[ActivityStatus] = 'Vacant'"  TableLayout="Fixed"     DataSourceID="SqlDataSource1">

Thanks
Shinu

[mac]

your example works as expected however my question was in dealing with multiple columns, not just one.
ie. (([column1] = 'Alpha' and [thecount] > 0) OR [columnb] = 'some other value'). when written as is, the filter is completely ignored.
Question: How to formulate multi column filter expression?
Question: Is the column related to the Datasource Column Name or the Grid Unique Name or the Grid DataField Name?

Thank you for your assistance in this.

[Yavor]

Hello mac,

Attached to this message, is a small application, which handles a similar task.
I hope it helps.

Kind regards,
Yavor
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.