Completed
Last Updated: 14 Oct 2019 10:33 by ADMIN
Release R3 2019 SP1
Husain
Created on: 01 Oct 2019 13:13
Category: GridView
Type: Bug Report
0
"SearchRow" does not search data in child grid of a Heirarchy Grid if paging is enabled

Dear Telerik Support Team,

 

I have a Grid with one level of Hierarchy, I am using also the search row control of Gridview but this control only searches the data in the Parent Grid and not in the child Grid, I am using the version: v.2019.2.618.20 of Telerik controls in the Project. Below is the code snippet which is used in the Project, please let us know how we can search in child grid using the search row of the Gridview.

 

            radgvStockCount.DataSource = dtStockCountHeader
            radgvStockCount.MasterTemplate.EnableHierarchyFiltering = True
            radgvStockCount.UseScrollbarsInHierarchy = True
            radgvStockCount.MasterTemplate.Columns("INVCountHeaderId").IsVisible = False
            radgvStockCount.MasterTemplate.Columns("INVCountNo").HeaderText = "Stock Count No"
            radgvStockCount.MasterTemplate.Columns("CountryCode").HeaderText = "Country Code"
            radgvStockCount.MasterTemplate.Columns("AreaCode").HeaderText = "Area Code"
            radgvStockCount.MasterTemplate.Columns("LocationCode").HeaderText = "Location Code"
            radgvStockCount.MasterTemplate.Columns("LocationName").HeaderText = "Location Name"
            radgvStockCount.MasterTemplate.Columns("CreatedBy").HeaderText = "Opened By"
            radgvStockCount.MasterTemplate.Columns("CreatedDate").HeaderText = "Opened Date"

            Dim template As New GridViewTemplate()
            template.DataSource = dtStockCountBatches
            radgvStockCount.Templates.Add(template)
            template.Columns("INVCountBatchesId").IsVisible = False
            template.Columns("INVCountHeaderId").IsVisible = False
            template.Columns("INVCountNo").HeaderText = "Stock Count No"
            template.Columns("INVCountBatchesNo").HeaderText = "Stock Count Batch No"
            template.Columns("LocationCode").HeaderText = "Location Code"
            template.Columns("LocationName").HeaderText = "Location Name"
            template.Columns("SupervisorQty").HeaderText = "Supervisor Qty"
            template.Columns("CreatedBy").HeaderText = "Batch File Uploaded By"
            template.Columns("CreatedDate").HeaderText = "Uploaded Date"
            template.AllowAddNewRow = False
            template.AllowEditRow = False
            template.AllowDeleteRow = False
            template.AllowSearchRow = False
            template.AllowRowResize = False
            template.EnableFiltering = True
            template.EnableHierarchyFiltering = True
            template.ShowHeaderCellButtons = True
            template.ShowGroupedColumns = True
            template.EnableHierarchyFiltering = True
            template.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill

            Dim relation As New GridViewRelation(radgvStockCount.MasterTemplate, template)
            relation.RelationName = "StockCountBatches"
            relation.ParentColumnNames.Add("INVCountHeaderId")
            relation.ChildColumnNames.Add("INVCountHeaderId")
            radgvStockCount.Relations.Add(relation)
8 comments
ADMIN
Dess | Tech Support Engineer, Principal
Posted on: 03 Oct 2019 06:30
Hello, Husain,    

Thank you for specifying that you are using paging. Indeed, in this case the search behavior doesn't traverse the child rows from the hierarchy. 

I have logged it in our feedback portal by making this thread public. You can track its progress, subscribe for status changes and add your comments on the following link - feedback item.

 

I have also updated your Telerik points.

Currently, due to the specificity of the issue the possible solution that I can suggest is to disable the paging if you need to search in the hierarchy rows. We will do our best in order to introduce a fix as soon as possible. Please excuse us for the inconvenience caused.

I hope this information helps. If you need any further assistance please don't hesitate to contact me.

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Husain
Posted on: 02 Oct 2019 16:50

Dear Dess,

 

I have been able to reproduce the issue in the Project which you had send me, the search row does not search in child grid if the paging is enabled in the gridview control. In your project it was not enabled and in my project it was enabled as you can see in the screen shot of my grid sent to you earlier.

I am attaching the screenshot of your Project where the search row does not search in child grid if paging is enabled in the gridview.

Please let me know if the paging is enabled in the gridview how to make the search row search in child grid templates as well.

 

Thanks and Regards,

Husain. 

ADMIN
Dess | Tech Support Engineer, Principal
Posted on: 02 Oct 2019 10:10
Hello, Husain,    

I have prepared a VS 2010 project with .NET 4.0 Target Framework. Please refer to the zip file.

I am looking forward to your reply.

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Attached Files:
Husain
Posted on: 02 Oct 2019 08:57

Dear Dess,

 

Can you please share with me the sample project in .Net Framework 4.0 in Visual Studio 2010 SP1 with the Telerik Control version as v.2019.2.618.20.

 So I can try at my end and let you know the result, the current sample project does not open in Visual Studio 2010 SP1.

 

Thanks and Regards,

Husain. 

ADMIN
Dess | Tech Support Engineer, Principal
Posted on: 02 Oct 2019 08:47

Hello, Husain,    

Indeed, the screenshot illustrates the weird behavior.

According to the provided code snippet, it would be difficult to conclude why the search behavior is not working for the child template on your end. I have set the same properties on my end and the search behavior still behaves as expected. Could you please give the sample project a try and share with me whether it works on you end? 

If the issue is reproducible only in your project, would be possible isolate the problematic form in a sample project and get back to me with it? The grid can be populated with dummy data for simplicity. Thus, we would be able to make an adequate analysis of the precise case and track the incorrect behavior. Thank you in advance for your cooperation.

I am looking forward to your reply. 

 

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Husain
Posted on: 02 Oct 2019 06:22

Dear Support Team,

 

Please find attached the screen shot of the Application.

 

Husain
Posted on: 02 Oct 2019 06:19

Dear Support Team,

 

It does not work for me, Please find below the code which I am using to bind the grids I am using the datatables to bind both the parent and the child grid and I am bringing the data in the datatable using the Stored Procedures. Please find below the method which I am using. Please let me know why it does not work for me?

 

Code Snippet:

 

Private SubLoadStockCountInGrid(ByValdtStockCountHeader As DataTable, ByValdtStockCountBatches As DataTable)

Try

radgvStockCount.DataSource = dtStockCountHeader

radgvStockCount.MasterTemplate.EnableHierarchyFiltering = True

radgvStockCount.UseScrollbarsInHierarchy = True

radgvStockCount.MasterTemplate.Columns("INVCountHeaderId").IsVisible = False

radgvStockCount.MasterTemplate.Columns("INVCountNo").HeaderText = "Stock Count No"

radgvStockCount.MasterTemplate.Columns("CountryCode").HeaderText = "Country Code"

radgvStockCount.MasterTemplate.Columns("AreaCode").HeaderText = "Area Code"

radgvStockCount.MasterTemplate.Columns("LocationCode").HeaderText = "Location Code"

radgvStockCount.MasterTemplate.Columns("LocationName").HeaderText = "Location Name"

radgvStockCount.MasterTemplate.Columns("CreatedBy").HeaderText = "Opened By"

radgvStockCount.MasterTemplate.Columns("CreatedDate").HeaderText = "Opened Date"

Dimtemplate As New GridViewTemplate()

template.DataSource = dtStockCountBatches

template.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill

radgvStockCount.Templates.Add(template)

template.Columns("INVCountBatchesId").IsVisible = False

template.Columns("INVCountHeaderId").IsVisible = False

template.Columns("INVCountNo").HeaderText = "Stock Count No"

template.Columns("INVCountBatchesNo").HeaderText = "Stock Count Batch No"

template.Columns("LocationCode").HeaderText = "Location Code"

template.Columns("LocationName").HeaderText = "Location Name"

template.Columns("SupervisorQty").HeaderText = "Supervisor Qty"

template.Columns("CreatedBy").HeaderText = "Batch File Uploaded By"

template.Columns("CreatedDate").HeaderText = "Uploaded Date"

template.AllowAddNewRow = False

template.AllowEditRow = False

template.AllowDeleteRow = False

'template.AllowSearchRow = True

template.AllowRowResize = False

template.EnableFiltering = True

template.EnableHierarchyFiltering = True

template.ShowHeaderCellButtons = True

template.ShowGroupedColumns = True

template.EnableHierarchyFiltering = True

template.EnableAlternatingRowColor = True

Dimrelation As New GridViewRelation(radgvStockCount.MasterTemplate, template)

relation.ChildTemplate = template

relation.RelationName = "StockCountBatches"

relation.ParentColumnNames.Add("INVCountHeaderId")

relation.ChildColumnNames.Add("INVCountHeaderId")

radgvStockCount.Relations.Add(relation)

radgvStockCount.AllowSearchRow = True

'SetupFiltering(radgvStockCount.MasterTemplate, True)

Catchex As Exception

Throwex

End Try

End Sub

ADMIN
Dess | Tech Support Engineer, Principal
Posted on: 02 Oct 2019 05:28

Hello, Husain,    

Following the provided information, I was unable to reproduce the issue you are facing. The search behavior highlight the rows that match the search criteria in the child template as well. Please refer to the below screenshot illustrating the result on my end :

I have attached my sample project. Could you please specify the exact steps how to reproduce the problem? Feel free to modify it in a way to reproduce the experienced issue and get back to me with it so I can investigate the precise case. Thank you in advance. 

I am looking forward to your reply.

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.