Change the default search wildcard setting

By default, AVEVA PI Vision search appends a wildcard (*) to the end of the search term. Use the SearchPatternUsesWildcards setting to turn this off and to give users the ability to do exact search term matching.

To explore if changing this parameter is applicable for your application, contact Technical Support.

Navigate to the AVEVA PI Vision database on the SQL Server.

• To create a wildcard setting table entry:

  INSERT INTO [dbo].[UserSettings] (Name, Value,
  Owner, TenantID) VALUES
  ('SearchPatternUsesWildcards', 'true', '', 0)

• To disable the wildcard setting:

  UPDATE [dbo].[UserSettings] SET [Value] = 'false'
  WHERE [Name] = 'SearchPatternUsesWildcards'

• To enable the wildcard setting:

  UPDATE [dbo].[UserSettings] SET [Value] = 'true'
  WHERE [Name] = 'SearchPatternUsesWildcards'

The search wildcard setting can also be controlled for individual users by adding a UserID argument. This will override the global setting for that user.

The syntax is as follows. Replace '{UserID}' with the actual ID of the user.

• To create a wildcard setting table entry for a user:

  INSERT INTO [dbo].[UserSettings] (Name, Value,
  Owner, TenantID) VALUES
  ('SearchPatternUsesWildcards', 'true', '{UserID}', 0)

• To disable the wildcard setting for a user:

  UPDATE [dbo].[UserSettings] SET [Value] = 'false'
  WHERE [Name] = 'SearchPatternUsesWildcards' && [Owner] = '{UserID}'

• To enable the wildcard setting for a user:

  UPDATE [dbo].[UserSettings] SET [Value] = 'true'
  WHERE [Name] = 'SearchPatternUsesWildcards' && [Owner] = '{UserID}'