Set maximum age for searches used in suggestion generation

  • Release version: Yokohama
  • Updated November 19, 2025
  • 1 minute to read
  • Set the Auto Flush parameter to limit the age of search strings used to create auto-complete suggestions and search suggestions.

    Before you begin

    Role required: ais_admin

    About this task

    The Search Event [sys_search_event] table contains all of the strings used in searches. Scripts use this table to generate search analytics, search suggestions, and auto-complete suggestions. A system property sets the maximum age for records preserved in the table. The default is 180 days, but you can change this number to preserve search events for a shorter or longer duration. Longer durations increase the size of the table and its disk consumption.

    Procedure

    1. Navigate to the Auto Flush [sys_auto_flush] table's list view.
      1. Select All.
      2. In the Filter field, enter sys_auto_flush.list.
      3. Press Enter.
    2. Search on *search and open the sys_search_event record.
    3. On the Auto Flush form, edit the Age in seconds value.
      The default is 15,552,000 seconds, which is 180 days.