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

DataFilter with Relations

3 Answers 101 Views
DataFilter
This is a migrated thread and some comments may be shown as answers.
Karim
Top achievements
Rank 1
Karim asked on 02 Jun 2017, 09:45 AM

Hello,

we are using a RadGridView which has implemented a master table with severals child tables. The datasource of the grid is a dataset containing the datatables with their realations. Now we want to use the DataFilter component to filter the data in the grid. 
It is possible to use the DataFilter which is based on a datasource (dataset) with relations? Maybe you can give us an example.

Thanks' in advance
Karim

3 Answers, 1 is accepted

Sort by
0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 02 Jun 2017, 11:07 AM
Hello Karim, 

Thank you for writing.  

When you filter a given GridViewTemplate by selecting the Custom item from the filter menu, a CompositeDataFilterForm is shown. This dialog uses a RadDataFilter allowing the user to compose a complex filter expression for each child template. Additional information is available here: http://docs.telerik.com/devtools/winforms/gridview/filtering/custom-filter-dialog

I hope this information helps. Should you have further questions I would be glad to help.

Regards,
Dess
Progress Telerik
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
0
Karim
Top achievements
Rank 1
answered on 02 Jun 2017, 12:57 PM

Hi Dess,

Thank you for your quick answer.
Maybe I must explain a little more precisely. Please have a look at the attached screen shot. Their you can see a master table with 3 child tables ("tblStueckliste", "tblWerkstoffKompositionen" and "tblWettbewerber"). In the DataFilter you can see only fields from the master table. But I want to filter also the fields "Hauptmodul" from the child table names "tblStueckliste". Ist this possible?

Karim

0
Hristo
Telerik team
answered on 05 Jun 2017, 11:07 AM
Hello Karim,

Thank you for writing.

You could add descriptor items by hand if you set up the control in unbound mode: http://docs.telerik.com/devtools/winforms/datafilter/working-with-descriptor-items/unbound-mode. However, you should be careful when applying such a filter is it may contain fields from both of your master and child tables.

I can suggest using separate data filter controls for the different tables. If that is not suitable you can use the same RadDataFilter and bind to the master or child tables when you need to. This way your expression would always be valid as the control would contain fields from only one table.

I hope this helps. Please let me know if you need further assistance.

Regards,
Hristo
Progress Telerik
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Tags
DataFilter
Asked by
Karim
Top achievements
Rank 1
Answers by
Dess | Tech Support Engineer, Principal
Telerik team
Karim
Top achievements
Rank 1
Hristo
Telerik team
Share this question
or