CONTACT USBack to MinistryPlatform Site
Your Knowledge Base has moved to the new Help Center.  Check out the release notes for details. And don't forget to update your bookmarks and in-house documentation before May 28.

Filtering Lists of Lists

 

Lists of Lists are highly customizable and can be filtered based on one (or more!) record ID in the Platform.

To understand how this works, check out this example of the link structure breakdown:

[[APP_PREFIX]]filtered_sermons?Sermon_Date>=2022-01-01&Sermon_Date<=2022-12-31&title=Sermons+from+2022
  • [[APP_PREFIX]] - Your app prefix. No need to look it up or contact support, just included [[APP_PREFIX]] at the start of your filter.
  • filtered_sermons - The route path.
  • ?Sermon_Date>=2022-01-01&Sermon_Date<=2022-12-31 - The selection criteria you’re using to filter. “Sermon_Date>=2022-01-01&Sermon_Date<=2022-12-31” means you are only selecting Sermon records with a Sermon Date on or after (>=) 01/01/2022 and on or before (<=) 12/31/2022. In other words, you’re selecting Sermon records between 01/01/2022 and 12/31/2022. Note: If the field name has a space, remember to replace the space with an underscore. For example, “Sermon Date” becomes “Sermon_Date”.
  • &title=Sermons+from+2022 - The title that displays at the top of the screen.

 

And while the possibilities are endless, here are some examples to get you started. If you come up with a great way to filter your Lists of Lists, share it in the Community!

Please note: The following URL examples may contain one or two numbers surrounded by curly braces, like this: {100}. These numbers represent a particular object’s record ID in MinistryPlatform. You should be able to see the appropriate record ID by opening that record in the Platform and looking at the title bar.

The curly braces may appear around a phrase, like {this}. These phrases represent some criteria to be replaced.

Bottom line, those curly braces and content within them should be replaced with your specific filter criteria and not be included in your URLs.

Events

[[APP_PREFIX]]events?Event_Type_ID={15}&title={Classes}

Groups

[[APP_PREFIX]]groups?Congregation_ID={4}&Group_Type_ID={22}&title={Church+Groups}

Opportunities

[[APP_PREFIX]]opportunities?Program_ID={10}&{Youth+Opportunities}

Sermons & Sermon Series

[[APP_PREFIX]]filtered_sermons?Speaker_ID={27}&title={Sermons+by+John+Doe}
[[APP_PREFIX]]sermons?[[APP_PREFIX]]filtered_sermon_series?Series_Start_Date>=2022-12-31&title={Series+from+2023}

Filtered Screens

These are special versions of the screens that don't have any filter buttons. For example, you may want to link from Lists of Lists to a filtered view of events, and you're filtering on Event_Type_ID=1. To send the user to the screen without the filters, you can use the filtered path [[APP_PREFIX]]filtered_events?Event_Type_ID=1.

[[APP_PREFIX]]filtered_events?{filter_criteria}
[[APP_PREFIX]]filtered_groups?{filter_criteria}
[[APP_PREFIX]]filtered_opportunities?{filter_criteria}

Pro Tips

  • You can filter based on almost any record field in the Platform, but pay attention to where your filter value is coming from. For example, to filter a list of Sermons by a Congregation, you'll need to get the Congregation ID from the Congregations page. In fact, you can filter on any Foreign Key on a table, and in some cases, on an ID "one step away" such as Event -> Program -> Ministry.
  • You can filter based on multiple IDs! To use multiple IDs in your selection criteria, separate them with a comma. 
Program_ID=1,2,3
  • You can filter based on multiple fields! If you want to use multiple fields, separate them with "&".
Congregation_ID=6&Group_Type_ID=13
  • You can include spaces in your title! To include spaces in your title, separate each word with a plus (+) sign.
&title=Title+Has+Spaces