Text search in individual field

Use a prefix in the search string

Note: These features are part of the Visforms Subscription and are not included in the free Visforms version.

If a search is possible in one field in the general text search field, a search is always carried out in all other fields at the same time.
In this case, you can only search in a single field using a prefix.

By entering the correct field-specific prefix, the search string that immediately follows is only applied to the values of the respective field.
The syntax for this is:

  • field name:search text

The following details must be taken into account when prefixing:

  • The field name fieldname: is the value from the Name option from the field configuration.
  • The colon must appear immediately after the field name without spaces.
  • The field name is not case-sensitive.

These details of using a search prefix are in accordance with Joomla. In Joomla, this type of search syntax can be used to search in many places in individual fields.

A prefix search with the following prefixes for a specific data record ID is also supported:

  • ID:number
  • id:number

Additional prefix for the user-name

A text search is possible in all data records for the name of the user who submitted the form using a prefix in the search field.
Start the search string in the search field with one of the following prefixes, without spaces, followed immediately by the name of the user you want to search for:

  • CREATOR:user-name
  • creator:user-name

Note: This search string is only evaluated if the overhead field Created by is also displayed in the specific data view.

A text search is possible in all data records for the name of the user who made the last change to the data record using a prefix in the search field.
Start the search string in the search field with one of the following prefixes, without spaces, followed immediately by the name of the user you want to search for:

  • EDITOR:user-name
  • editor:user-name

Note: This search string is only evaluated if the Changed by overhead field is also displayed in the specific data view.