External Filters and Filter Functions In addition to embedded filters, you can also have a function external to the grid, that determines if a particular object matches a filter. So, for example, you could have an external filter panel, that would filter the records on basis of a column that is not shown in the grid, or some custom logic that cannot be easily wrapped in a filter control. The way you do this, is to specify a filterFunction for the level you are interested in filtering. So if you want to filter the top level records, you would set the filterFunction and the top level. If you are interested in filtering inner level records, you would navigate to the level you are interested in, and then specify a filterFunction there. This is particularly applicable for hierarchical grids (as opposed to flat grids) because hierarchical grids don't have a filter bar for sub grids. For a running example of this functionality, please review myCompanyNameSpace.externalFilter_filterDeviceTypes=function(item){ if(SOME_LOGIC_HERE) return true; else return false; }; Export Options - Deep Dive Flexicious, out of the box, offers you the ability to Export the data grid data to Word, Excel, HTML, Text and XML. We also provide a plug-in based mechanism, where in you can add your own exporters. There are certain aspects of the Export mechanism that require some additional insight, which we will cover in this chapter. Built in Exporters Out of the box, there are the following Exporters available: CsvExporter DocExporter HtmlExporter XmlExporter TxtExporter ExcelExporter, (which basically creates HTML, but names the file as XLS, which excel will open) All these exporters can be found in the export namespace. They all inherit from the Exporter class. By default when you do an export, you will see the following popup:
External Filters and Filter Functions In addition to embedded filters, you can also have a function external to the grid, that determines if a particular object matches a filter. So, for example, you could have an external filter panel, that would filter the records on basis of a column that is not shown in the grid, or some custom logic that cannot be easily wrapped in a filter control. The way you do this, is to specify a filterFunction for the level you are interested in filtering. So if you want to filter the top level records, you would set the filterFunction and the top level. If you are interested in filtering inner level records, you would navigate to the level you are interested in, and then specify a filterFunction there. This is particularly applicable for hierarchical grids (as opposed to flat grids) because hierarchical grids don't have a filter bar for sub grids. For a running example of this functionality, please review myCompanyNameSpace.externalFilter_filterDeviceTypes=function(item){ if(SOME_LOGIC_HERE) return true; else return false; }; Export Options - Deep Dive Flexicious, out of the box, offers you the ability to Export the data grid data to Word, Excel, HTML, Text and XML. We also provide a plug-in based mechanism, where in you can add your own exporters. There are certain aspects of the Export mechanism that require some additional insight, which we will cover in this chapter. Built in Exporters Out of the box, there are the following Exporters available: CsvExporter DocExporter HtmlExporter XmlExporter TxtExporter ExcelExporter, (which basically creates HTML, but names the file as XLS, which excel will open) All these exporters can be found in the export namespace. They all inherit from the Exporter class. By default when you do an export, you will see the following popup:
Flexicious%20HTMLTreeGrid.docx