Case-Insensitive Query - Intergraph Smart Materials - Version 2020 (10.0) - Help - Hexagon PPM

Intergraph Smart Materials Classic Help (2020)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Help
Smart Materials/Smart Reference Data Version
2020 (10.0)

The case-insensitive query feature allows you to search for text strings in the database, regardless of whether upper- or lowercase characters are used. Using this feature, you can find records that were entered incorrectly, for example, with uppercase instead of lowercase, or vice versa, or a combination of uppercase and lowercase.

The DBA setting CASE_INSENSITIVE_QUERY controls the case sensitivity of the query operation. If this DBA setting is set to Y, the query operation is executed in case-insensitive mode. If this setting is set to N (default), the query operation is strictly case-sensitive, which means you must enter exactly the same upper- and lowercase letters for the query condition as used in the text strings you are looking for.

For more information about DBA settings, see DBA Settings.

Switch to enter query mode using the Enter query button, click in the field that is used for the query, and enter the search string into this field. If the case-insensitive mode is activated, it does not matter if you enter the string in uppercase, in lowercase, or in mixed case.

For example, to query all tables on the S.20.02 Tablenames with Details screen that have a group description with the substring ‘material’, ‘Material’, ‘MATERIAL’, or any other spelling anywhere in the text, do the following: Open the S.20.02 screen, switch to enter query mode, and enter the string '%material%' in the Description field, as displayed in the picture below.

Click the Run query button to execute the query. Any occurrences of the entered substring will be found, for example, in ‘steel materials’:

or in ‘Material for PAS pipes’:

or in ‘JACK_BOLT_MATERIAL’: