Administer > Database administration > Data persistence > Queries > Use the index function in a query

Use the index function in a query

Applies to User Roles:

System Administrator

Example: Retrieve all records where the character string DEFAULT occurs anywhere in the device name and the device name ends in the number string 002.

In this example, we use a like query and wildcard characters with the index function to perform an Advanced Search on records in the device.qbe form.

To use the index function in a query:

  1. Click Tailoring > Database Manager.
  2. Type =device in the Form field, and then click Search.
  3. On the Asset Information form, open the More Actions menu.
  4. Select Expert Search.
  5. In the Query field, type like “*002” and index(“DEFAULT”,>0, and then click Search.

    Note: Wildcard characters are only valid in like queries. In other types of queries, the characters are literal interpretations.

  6. Click any record in the list of returned records to view the details.

Note: A device is also referred to as an Asset or Configuration Item (CI).

Related topics

Complex query expressions
Record retrieval
Relational operators
Stored queries
The Database Manager utility
Using functions in a query
More Actions menu

Use like queries to search for a string of characters
Use the lng function in a query
Use the tod function in a greater than or less than query