DataFilter with Relations

4 posts, 0 answers
  1. KSafadi
    KSafadi avatar
    9 posts
    Member since:
    Oct 2012

    Posted 02 Jun Link to this post

    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

  2. Dess
    Admin
    Dess avatar
    2107 posts

    Posted 02 Jun Link to this post

    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.
  3. KSafadi
    KSafadi avatar
    9 posts
    Member since:
    Oct 2012

    Posted 02 Jun in reply to Dess Link to this post

    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

  4. Hristo
    Admin
    Hristo avatar
    1028 posts

    Posted 05 Jun Link to this post

    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.
Back to Top