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

[Solved] DetailTable Filter expression not working??

2 Answers 162 Views

Grid

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

mac asked on 16 Apr 2009, 09:44 PM

I have been at this now for awhile. didn't want to post as it seems a pretty simple thing to do.
no matter how i write it, I cannot get my detailtable filter expression to work.

Note the poststat of the mastertableview is different than the poststat of the detailtable.

    
            <telerik:RadGrid  id="RadGrid2" runat="server"   
        
             GridLines="Horizontal" 
        
                AllowPaging="True"  AutoGenerateColumns="False">  
        
                <MasterTableView FilterExpression="([ActivityStatus] = 'Vacant') AND ([poststat] = 'Qualifying')"   
        
                 DataKeyNames="Recordid">  
        
                    <Columns> 
        
                        <telerik:GridBoundColumn DataField="Recordid" DataType="System.Int32" HeaderText="Recordid" Visible="False" 
        
                            ReadOnly="True" SortExpression="Recordid" UniqueName="Recordid">  
        
                        </telerik:GridBoundColumn> 
        
                        <telerik:GridBoundColumn DataField="PostingNumber" /> 
        
                        <telerik:GridBoundColumn DataField="poststat" /> 
        
                        <telerik:GridBoundColumn DataField="ActivityStatus" /> 
        
                    </Columns> 
        
                    <DetailTables> 
        
                        <telerik:GridTableView Name="IA" FilterExpression="([AppStat] = 'Late')"   THIS IS NOT FILTERING!!!
        
                        Caption="Internal Applicants"  DataKeyNames="Applicationid" 
        
                            DataSourceid="AllApps"  runat="server">  
        
                            <ParentTableRelation> 
        
                                <telerik:GridRelationFields DetailKeyField="Apps" MasterKeyField="Recordid" /> 
        
                            </ParentTableRelation> 
        
                            <Columns> 
        
                                <telerik:GridBoundColumn DataField="SenrBalance" HeaderText="Balance"  UniqueName="SenrBalance" /> 
        
                                <telerik:GridBoundColumn  DataField="PostStat" HeaderText="PostStat"   UniqueName="AppStat" /> 
        
                            </Columns> 
        
                        </telerik:GridTableView> 
        
                        </DetailTables> 
        
                    </MasterTableView> 
        
            </telerik:RadGrid> 
        
                     <asp:SqlDataSource ID="AllApps" runat="server" ConnectionString="<%$ ConnectionStrings:PHCJobPostsConn %>" 
        
                         SelectCommand="Applicants" SelectCommandType="StoredProcedure">  
        
                         <SelectParameters> 
        
                            <asp:SessionParameter Name="Apps" SessionField="PostNum" /> 
        
                         </SelectParameters> 
        
                     </asp:SqlDataSource> 
        
                Protected Sub RadGrid2_NeedDataSource(ByVal source As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles RadGrid2.NeedDataSource  
        
                    RadGrid2.DataSource = functions.dt(String.Format("exec SProc '706680'", Session("empID")))  
        
                End Sub

this thing is driving me crazy
mac

[Solved] DetailTable Filter expression not working??

2 Answers, 1 is accepted