Issue.
We're currently having an issue regarding the excel export functionality.
The filters applied to the Scheduler
work just fine to filter out events and resources (i.e. the Scheduler
only shows the filtered resources and events as desired), however, we find the events and resources unfiltered when in the excel document once exported.
We would like to have the filtered exported data.
Here is the Scheduler
specified like this (there are lots of properties defined here, however for now I've omitted most of them), we have the excelExporter
configuration defined here:
this.scheduler = new Scheduler({
appendTo: this.host,
startDate,
endDate,
height,
crudManager,
listeners: { ... },
features: {
eventEdit: true,
dependencies: false,
dependencyEdit: false,
eventCopyPaste: false,
eventDrag: true,
eventResize: true,
headerZoom: true,
eventTooltip: { ... },
eventMenu: { ... },
excelExporter: {
zipcelx
},
},
});
Additionally, we have a button that triggers a flow to perform the export, we currently just export all the data fields from the event instances.
private excelExport(): Promise<void> {
const fields = [];
for (const fieldName in this.scheduler.eventStore.modelClass.fieldMap) {
if (this.scheduler.eventStore.modelClass.fieldMap[fieldName].persist !== false) {
fields.push({text: fieldName, field: fieldName});
}
}
return this.scheduler.features.excelExporter.export({
filename : 'JobScheduleResults',
exporterConfig: {
columns: this.schedulerConfiguration.columns.map((column) => {
return {
text: column.text,
field: column.field,
}
}),
eventColumns : fields
}
});
}