How to exclude specific data from getting exported in Excel export in mendix
0
Hello, There is a scenario where we need to download excel sheet (using excel export). Need to export all data except data whose status is ARCHIEVED. It is an enumeration value. I am trying to put constraint from Export template only from Association, constraint section But facing one issue, as I am trying to exclude this particular status from getting exported so I am trying to put not equal to constraint but getting following error Please let me know how to put this this constraint to filter that specific data of this particular status
asked
Trishla T
2 answers
0
Use in the MX Constraint of the attribute of type enumeratio, the name/key value of the enumeration. Not the caption.
answered
Chris de Gelder
0
Please use the attribute status (type enumeration) in the filter (not TaskName) but after 'not equal' type Archived. Actually your Name of the enumeration (See my sample below)
Actually it is a bug in the module: IVK_ConstraintSave , in the 'text' split. Change the 'propper contraint' [Sic], to
$MxConstraint/Constraint = XLSReport.ConstraintType.Contains
or
$MxConstraint/Constraint = XLSReport.ConstraintType.Equal
or
$MxConstraint/Constraint = XLSReport.ConstraintType.StartWith
or
$MxConstraint/Constraint = XLSReport.ConstraintType.NotEmpty
or
$MxConstraint/Constraint = XLSReport.ConstraintType.NotEqual
or
$MxConstraint/Constraint = XLSReport.ConstraintType._empty
The engine can handle this.
Beware the update procedure in the future
answered
Chris de Gelder