msa talkdb manage pt filters - ajtruckle/meeting-schedule-assistant-support GitHub Wiki

Additional Filters

Additional Filters

The Additional Filters menu (opened from the filter button above the talk list) provides quick, toggle‑based ways to refine the list. These filters can be combined with each other and with the Category Filter.

Screenshot of the filtering panel showing a text filter set to “CONTAINS: future,” with a dropdown of additional filter options such as Has Media, No Media, Excluded, Included, Booked, Not Booked, Never Given, Unassigned, and Advanced. Below, a results list displays four matching items containing the word “future.”

Filter Options Description
Has Media Has Media / No Media Filters talks based on whether they include media (slides, images, etc.). These options are mutually exclusive.
Excluded Excluded / Included Filters talks based on whether they are marked as excluded in your congregation. These options are mutually exclusive.
Booked Booked / Not Booked Filters talks based on whether they have a future booking or scheduled assignment. These options are mutually exclusive.
Never Given Shows only talks that have never been given in your congregation (no last-heard date and never invited).
Unassigned Shows talks that have no speakers assigned. This may indicate your speaker list needs updating or highlight talks that could be assigned locally.

How These Filters Combine

All enabled Additional Filters are applied simultaneously.
For example, you can combine:

  • Category: Christian Living
  • Has Media
  • Not Booked
  • Unassigned

The talk list updates instantly as you toggle each filter.

Advanced Filters

The Advanced option in the filter menu enables a more precise, data‑driven way to filter the talk list. When enabled, an additional filter panel appears above the list, allowing you to build a structured filter based on a field, an operator, and a value.

Advanced filtering works in five simple steps: 

1. Enable Advanced Mode

Choose Advanced... from the filter menu.
The advanced filter controls become enabled above the talk list.

2. Choose the Field

Use the Field combo to select which part of the talk record you want to filter on.
Examples include:

  • Theme
  • Notes
  • Number
  • Count
  • Outline date
  • Last given
  • Next invited
  • Excluded from

Each field has a specific data type (Text, Number, or Date).
The system automatically selects the correct operator set and input control based on the field you choose.

3. Choose the Operator

The operator defines how the selected field should be compared to the value you enter.
The available operators depend on the data type of the selected field.

Field Type Operator Meaning / Description
Date / Number = Equals (default)
!= Not equal
< Less than
<= Less than or equal
> Greater than
>= Greater than or equal
Text = Exact match
!= Does not exactly match
Contains Field contains the specified text (default)
Does not contain Field does not contain the specified text
Starts with Field begins with the specified text
Ends with Field ends with the specified text

4. Enter the Value

The value control changes automatically based on the field type:

  • Date fields show a date picker.
  • Number fields show a numeric input with spinner.
  • Text fields show a free‑text edit box.

5. Apply the Filter

After entering your value, click the Apply (✓) button (located to the left of the Clear Filter button) to perform the advanced filtering.

The talk list updates when you click Apply.

How Advanced Filters Interact with Other Filters

Advanced Filters run in addition to:

  • Category Filter
  • Additional Filters

This allows very fine‑grained combinations, such as:

  • Category: Christian Living
  • Additional Filter: Not Booked
  • Advanced Filter: Last Given DateBefore1 Jan 2020
  • Advanced Filter: TitleContains → “family”

Clearing the Filter

To remove all advanced filtering and return to the full talk list, click the Clear Filter button.