FindAsYouType for Standard Link Fields

Learn about FindAsYouType function for Standard Link Fields.

To configure FindAsYouType for a standard link field:

In the Field Control Editor select a standard link field and define a Select-Function selectRecord() using the findAsYouType property. This provides users with the possibility to type a search string into the link field and select a record from the drop-down list that is then linked to the current record.

Syntax

Use the following syntax, described in the article, “How to configure Find as you type” at https://support.aurea.com.

  • parameter searchFields - valid field types: text, number and variable catalog fields (Field Types C,L,S,K, see Data Types in Aurea CRM).
  • text and catalog fields support substring/wildcard search (e.g. where (Country = "Au*"))
  • parameter textFields - valid field types: all - the output fields as shown in the search results drop-down list
  • parameter maxRows - if more entries are found "..." is displayed at the end of the drop-down list
  • parameter query - The name of the query to be used for findAsYouType. If this parameter is provided, the parameters searchFields and textFields are ignored. The output fields displayed in the drop-down list are determined by the query's output fields.
  • The parameters link and searchContext are not supported for FindAsYouType functions.
Note: Link fields to which a (global or specific) FindAsYouType definition applies, are displayed as editable. If an invalid/erroneous FindAsYouType definition is applied to a field, this field is displayed as read-only and an error message is written to the client log.

Example

Searching for a company to be defined for the Contact Company field in the Ticket info area.
selectRecord({
	from:{
		infoAreaId:"FI"
		},
	findAsYouType:{
		searchFields:["Company","Synonym","Country"],
		textFields:["Company","Street","ZipCode","City","Country"],
		maxRows:20
		}
	})

Typing part of the company's name, synonym or country lists the company plus its address details. The results in the drop-down list are limited to 20.