Database and Cache Tools

Use the following options to force update the application's caches, update the linked Google Calendar, and clear data.
Database and Cache Tools

Calendar String Cache

This option updates the value displayed on the main search page (next to the calendar icon) detailing the event's calendar data

Open Now Cache

This option refreshes the database's cache field values that activate the green "Open Now" flag

Filtering Options Cache

This option refreshes the database's cache field that stores the filter values for each resource.

Filters affected by this cache value include: Open Hours and Open Days

Force Push Events to Google Calendar

This option checks the database for calendar events that have not been added to a linked Google Calendar. Use this option for updating the linked Google Calendar after a database import operation.

Note: Events previously added to a Google Calendar that have been manually removed will not be re-added. This option only adds events to the Google Calendar that have a `gcal_id` value of null.

Caution: Overuse of this option could cause performance issues or Google API blocking errors.

Remove Linked Events from Google Calendar

This option attempts to delete all known events from the linked Google Calendar. Use this option with the `Update Google Calendar` option to force re-create all calendar events stored in the database. This option does not remove any calendar data from the Mercer County Food Finder Demo database, only the linked Google Calendar.

Caution: Overuse of this option could cause performance issues or Google API blocking errors.

Clear Anonymous User Profiles

These options delete the anonymous profile data stored in the database.

The following user data will be cleared from the database: IP addresses, user location (latitude and longitude), and user device language.

Clear Anonymous User Search Queries

These options delete the search query data stored in the database about the anonymous users.

The following user data will be cleared from the database: date of search request, site name search terms, `Open Hours`, `Open Days`, `People Served`, and `Food Offered` filters that were selected/entered by the user.