NOTES:

List of query parameter invoked filters & other filters (in order of execution):

• Flattener (write, removes subtables)

  • merges subtables

  required pre-conditions:

  • none

• ReportTotalsCalculator (read-only, requires INDEX values, but should not be necessary to use them)

  • calculates totals values

  required pre-conditions:

  • requested columns must exist
  • table hierarchy must be final and non-altered

• priority queued filters (write, remove/add rows, remove/add/change columns, any sort of manipulation to non-data)

  required pre-conditions:

  • requires datatable to be in initial state. visualizations should not be required to know if the table has been flattened or not. this would mean, however, that they should run on subtables so if they are flattened the result is changed correctly.

• ExcludeLowPopulation (write)

  • removes rows with column value lower than, etc.

  required pre-conditions:

  • dependent columns must be pre-prettified

• SafeDecodeLabel (write, changes label values, not super necessary)

  • changes label values

  required pre-conditions:

  • table row count has to be considered final
  • has to be run before label columns considered 'final'

• LabelFilter (write)

  • removes rows that do not match label query

  required pre-conditions:

  • labels must have FINAL values (table does not have to be final value)

• Pattern(Recursive) (write)

  • removes rows that do not match pattern

  required pre-conditions:

  • dependent columns must be pre-prettified
  • table cannot truncated or limited

• AddColumnsProcessedMetrics(Goal) (write)

  • adds lazy column values that calculate processed metrics

  required pre-conditions:

  • dependent columns must be pre-prettified

• Sort (write)

  • re-orders rows

  required pre-conditions:

  • the column must exist and must have its pre-prettified value

• Truncate (write)

  • cuts off after a certain amount

  required pre-conditions:

  • the table must be in the right ORDER

• Limit (write)

  • takes subsection of whole table

  required pre-conditions:

  • the table must be in its FINAL state

• presentation/queued filters

  required pre-conditions: datatable must be in final state

  • TODO: rename queueFilter() in DataTable to queuePresentationFilter()?

• ColumnDelete (write)

  • removes column values

  required pre-conditions:

  • processed columns must be final

  TODO:

  • must modify so processed columns are set

NOTE: priority queued filters have to be able to run on pre-ReplaceColumnNames tables

Other notes:

• concept of 'recursive' filter should be removed. all filters should be recursive, if it is not desired to run them on subtables, the subtables should not be loaded (ie, expanded=0)