message: allow for derivatives to be filterable
diff: @@ -28,6 +28,10 @@ import { useFiretableContext } from "contexts/FiretableContext";
  import { useAppContext } from "contexts/AppContext";
  import { DocActions } from "hooks/useDoc";
  +const getType = (column) =>
  + column.type === FieldType.derivative
  + ? column.config.renderFieldType
  + : column.type;
  const OPERATORS = [
  {
  value: "==",
  @@ -168,6 +172,7 @@ const Filters = () => {
  operator: "",
  value: "",
  };
  + const type = getType(selectedColumn);
  if (
  [
  FieldType.phone,
  @@ -175,21 +180,21 @@ const Filters = () => {
  FieldType.url,
  FieldType.email,
  FieldType.checkbox,
  - ].includes(selectedColumn.type)
  + ].includes(type)
  ) {
  updatedQuery = { ...updatedQuery, operator: "==" };
  }
  - if (selectedColumn.type === FieldType.checkbox) {
  + if (type === FieldType.checkbox) {
  updatedQuery = { ...updatedQuery, value: false };
  }
  - if (selectedColumn.type === FieldType.connectTable) {
  + if (type === FieldType.connectTable) {
  updatedQuery = {
  key: `${selectedColumn.key}ID`,
  operator: "array-contains-any",
  value: [],
  };
  }
  - if (selectedColumn.type === FieldType.multiSelect) {
  + if (type === FieldType.multiSelect) {
  updatedQuery = {
  ...updatedQuery,
  operator: "array-contains-any",
  @@ -202,7 +207,7 @@ const Filters = () => {
  const operators = selectedColumn
  ? OPERATORS.filter((operator) =>
  - operator.compatibleTypes.includes(selectedColumn.type)
  + operator.compatibleTypes.includes(getType(selectedColumn))
  )
  : [];
  @@ -222,7 +227,8 @@ const Filters = () => {
  const id = open ? "simple-popper" : undefined;
  const renderInputField = (selectedColumn, operator) => {
  - switch (selectedColumn.type) {
  + const type = getType(selectedColumn);
  + switch (type) {
  case FieldType.checkbox:
  return (
  <Switch
  