FindByKey command

Used in a Server.Load script to enable you to search index entries by key.

Syntax

FindByKey "[KeyField]#searchstring"

Where:

  • key list -- List of keys separated by semicolons. Each key is in the <item>#<value> format, where <item> is the item, name, and <value> is the value. The FindByKey "key list" argument is the Field Name of the column searched, and the value of the data as it appears in the column.
  • option list -- One or more of the following, each separated with a space:

    NO_ACCENT -- Accent insensitive

    NO_CASE -- Case insensitive

    PARTIAL -- Partial compare

    FIRST_EQUAL -- First equal entry

    LAST_EQUAL -- Last equal entry

    GREATER_THAN -- All entries greater than

    LESS_THAN --All entries less than

    UPDATE_IF_NOT_FOUND -- Update if not found

Example

Search a view containing a column referencing the field "Status" and search for those "complete."

FindByKey "[Keyfield]#complete"

The NOTES.INI setting is Keyfield=Status. This also appears, and is set, on the Test Parameters tab.