jQuery UI Widgets Forums TreeGrid Export only Filtered data in treegrid

This topic contains 2 replies, has 2 voices, and was last updated by  drgandhi 1 month ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
  • Export only Filtered data in treegrid #120815

    drgandhi
    Participant

    Hi Team,

    I am using website licnese in my application.
    I have more then 1000 data to load in treegrid.

    All is working fine.I have added simple filter mode in treegrid. But now when I tried to export the data , every time whole data will export to xls. I want only filtered data to be export.
    I can not find any demo or reference link for this tipe of issue.

    Please help me on this.

    Export only Filtered data in treegrid #120817

    Yavor Dashev
    Participant

    Hi drgandhi,

    Yes this functionality is supported by the jqxTreeGrid component by using the exportSettings property.

    This property is an object and the exportData method takes those setting when the jqxTreeGrid is exported.

    A jsfiddle which shows you how to set the exportSettings so that only the filtered data is exported: http://jsfiddle.net/t9ejcL85/

    ExportSettings code snippet for this scenario:

    exportSettings: {
            columnsHeader: true, 
            hiddenColumns: false, 
            serverURL: '', 
            characterSet: 'UTF-8',
            collapsedRecords: false, 
            recordsInView: true,
            fileName: "yourfilename"
        	},

    And I strongly recommend you to check out the API docs regarding the jqxTreeGrid component which covers the mentioned properties as well.

    Link to the API docs: https://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxtreegrid/jquery-treegrid-api.htm

    Please, do not hesitate to contact us if you have any additional questions.

    Best Regards,
    Yavor Dashev
    jQWidgets team
    https://www.jqwidgets.com

    Export only Filtered data in treegrid #120821

    drgandhi
    Participant

    Thank you Team,

    I missed the property “recordsInView:True”. I added that in exportsetting and now its working fine.

    Can any one help me about how to use Server URL to export larger entity ?

    From where i can get dataExport.php file ? and how I can use that ?

    Currently when I expand all the records, it throws an error about Too large entity.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.