Export only Filtered data in treegrid

[drgandhiParticipant]

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.

[Yavor DashevParticipant]

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

[drgandhiParticipant]

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.

[Author]

Posts