Scheduling FTS indexing scans for join, vendor, and view forms

The join, vendor, and view forms are not updated in the same manner as regular forms. To make sure full text searches are accurate, schedule scans to check for updates in these types of forms. When the forms are scanned, the AR System server indexes only the entries that have been added or changed.

The scan works as follows:

  • For join forms, the server can detect which fields on the join form represent the last-modified timestamps on base forms. Using those timestamps, the server scans for updates at the scheduled times.
  • For vendor and view forms containing a core field with field ID 6, equivalent to a last-modified timestamp, the server scans for updates at the scheduled times.
  • If the vendor or view forms do not contain a field with ID 6 or the join forms do not contain any last-modified timestamps, the form cannot be scanned for updates, and the server re-indexes all the indexed fields on the form each time the form is scheduled to perform a scan.
  • The deleted entries or entries that disappear because join key fields are changed in base forms are not detected, and the entries are represented in the index until you complete a field re-index. For more information, see Rebuilding-an-index-for-specific-fields.

Related topics

Rebuilding-an-index-for-specific-fields

Configuring-FTS-by-using-the-Server-Information-form

Warning

Schedule scan intervals with caution. Do not overload the system with many form scans at small intervals, especially those that perform a complete re-index because of the unavailability of the last-modified timestamps. If using the AR System server interface is the only way your organization updates the database table associated with a view form, you do not need to schedule scanning for that view form.


To schedule a scan for updates

  1. In Developer Studio, open the form.
  2. Select the Definitions tab.
  3. Expand the Other Definitions panel and the Full Text Search panel.
  4. Select the scan times to check for updates to fields that have been indexed for FTS.
    22_1_FTS_schedule_scan_times.png
  5. Save the form.

AR System server does not support Full Text Search if you have a read-only database.

For more information about using a read-only database, see Using read-only database.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*