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 logical.name like “*002” and index(“DEFAULT”, logical.name)>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).