Filtering on foreign key columns not working

[Darren]

Morning,
My foreign key columns are not filtering.
I get this error: "Expression expected".
Furthermore none of the foreign key columns have the "Contains" filter option.
The WebsiteUrl column has "Contains" filter option and works perfectly.

My columns look like this:

        <telerik:GridBoundColumn DataField="WebsiteId" DataType="System.Int64"
            EmptyDataText="&amp;nbsp;" HeaderText="WebsiteId" ReadOnly="True"
            SortExpression="WebsiteId" UniqueName="WebsiteId" Visible="false" ForceExtractValue="InEditMode">
        </telerik:GridBoundColumn>

        <telerik:GridBoundColumn DataField="WebsiteUrl" EmptyDataText="&amp;nbsp;"
            HeaderText="WebsiteUrl" SortExpression="WebsiteUrl" UniqueName="WebsiteUrl">
        </telerik:GridBoundColumn>

            <telerik:GridTemplateColumn HeaderText="Client"
                DataType="System.Int64" UniqueName="Client" >
                    <EditItemTemplate>
                        <telerik:RadComboBox ID="RadComboBoxClientName" Runat="server"
                            DataSourceID="LinqDataSourceClient" DataTextField="ClientName"
                            DataValueField="ClientId" SelectedValue='<%# Bind("ClientId") %>'
                            Skin="Vista" Width="280px">
                            <CollapseAnimation Duration="200" Type="OutQuint" />
                        </telerik:RadComboBox>
                    </EditItemTemplate>

                    <ItemTemplate>

                        <asp:Label ID="LabelClientName" runat="server" Text= <%#Eval("tblClient.ClientName")%>         > </asp:Label>

                    </ItemTemplate>
                </telerik:GridTemplateColumn>

            <telerik:GridTemplateColumn HeaderText="Server"
                DataType="System.Int32" UniqueName="Server"  >
                    <EditItemTemplate>
                        <telerik:RadComboBox ID="RadComboBoxServerName" Runat="server"
                            DataSourceID="LinqDataSourceServer" DataTextField="ServerName"
                            DataValueField="ServerId" SelectedValue='<%# Bind("ServerId") %>'
                            Skin="Vista" Width="280px">
                            <CollapseAnimation Duration="200" Type="OutQuint" />
                        </telerik:RadComboBox>
                    </EditItemTemplate>

                    <ItemTemplate>

                        <asp:Label ID="LabelServerName" runat="server" Text= <%#Eval("tblServer.ServerName")%>> </asp:Label>

                    </ItemTemplate>
                </telerik:GridTemplateColumn>


        <telerik:GridBoundColumn DataField="LogFilePath" EmptyDataText="&amp;nbsp;"
            HeaderText="LogFilePath" SortExpression="LogFilePath"
            UniqueName="LogFilePath" Display="False">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="BandWidthCost" DataType="System.Decimal"
            EmptyDataText="&amp;nbsp;" HeaderText="BandWidthCost"
            SortExpression="BandWidthCost" UniqueName="BandWidthCost" Visible="false">
        </telerik:GridBoundColumn>

I've Specified the filter menu manually like this:

    protected void RadGrid1_Init(object sender, EventArgs e)
    {

        GridFilterMenu menu = RadGrid1.FilterMenu;
        int i = 0;
        while (i < menu.Items.Count)
        {
            if (menu.Items[i].Text == "NoFilter" ||
               menu.Items[i].Text == "Contains" ||
               menu.Items[i].Text == "EqualTo" ||
               menu.Items[i].Text == "GreaterThan" ||
               menu.Items[i].Text == "LessThan")
            {
                i++;
            }
            else
            {
                menu.Items.RemoveAt(i);
            }
        }

    }

[Yavor]

Hello Darren,

I reviewed the code snippet and it looks correct.
If the issue persists at your end, you can open a formal support ticket, and send us the problematic code, in the form of a small project, for further investigation.

Kind regards,
Yavor
the Telerik team

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

[peter]

thanks i've opened up a ticket.

[Scott Marx]

Was there every a solution for this situation?

[Martin]

Hello Scott Marx,

Here are some quotes from the support ticket responses my colleagues have provided:

"... I have noticed that the template columns are missing datafield property value. This property is needed in order RadGrid to map which property of its datasource maps to a given column. Thus please set an appropriate value and try if this helps. 

As to your other question the Contains filter option is applicable on for string value, thus it is automatically omitted from filter option when filtering on numeric values."

"... Can you please try removing the DataType or set it to tblClient.ClientName's return type from the column's declaration similar to the following:"

<telerik:GridTemplateColumn HeaderText="Client"
UniqueName="Client" DataType="System.String" DataField="tblClient.ClientName">
    <EditItemTemplate>
        <telerik:RadComboBox ID="RadComboBoxClientName" Runat="server"
            DataSourceID="LinqDataSourceClient" DataTextField="ClientName"
            DataValueField="ClientId" SelectedValue='<%# Bind("ClientId") %>'
            Skin="Vista" Width="280px">
            <CollapseAnimation Duration="200" Type="OutQuint" />
        </telerik:RadComboBox>
    </EditItemTemplate>

    <ItemTemplate>

        <asp:Label ID="LabelClientName" runat="server" Text= <%#Eval("tblClient.ClientName")%>> </asp:Label>

    </ItemTemplate>
</telerik:GridTemplateColumn>

I hope this helps.

All the best,
Martin
the Telerik team