Searching Through a Project Database

23.08.2021

You can search the active project database or parts of it for objects that fulfill particular criteria. Do the following:

1.In the Folders window, select the folder that you want to search.

2.Click Home[Edit] > Find. The Search in Project Database window appears.

3.Select the option Include subfolders in search if subfolders of the selected folder should also be searched.

4.Select the option Output in Find Results 2 if the objects found should be output to the Find Results 2 window instead of the Find Results 1 window.

5.Select the option Use search index if you want to speed up the search process. In this case, objects not yet calculated will be ignored during the search. To do this, Data Indexing must be enabled for the project database. The search process may be slow if the Use search index option is not used. However, objects not yet calculated will be updated during the search.

6.The next step is to determine the criteria that the objects searched for should fulfill. You can combine multiple criteria by clicking on More and setting the desired logical operation. The search criterion can be combined with a Boolean AND or OR, where AND takes precedence over OR. The individual search items and search operations are listed below. The input search value is also covered below.

7.Click on New Search. The Find Results window is first cleared and then the objects found are displayed. If you want to start a new search while keeping the objects currently displayed in the Find Results window, then click Search instead of New Search.

8.You can cancel the search at any time by clicking on Stop.

The editing options in the Find Results window where the objects found are displayed mostly match those of the object list.

Search Item

The following table lists all search items supported by FlexPro. In the right-hand column you can see whether a search item is available for searching in the project database, for index-based searching in the project database, or for index-based searching in external files:

Criterion

Description

Available in

Absolute end time

Date and time of last X value. The data set must either have an X component or it must be selected as the X component itself.

 

Absolute start time

Date and time of first X value. The data set must either have an X component or it must be selected as the X component itself.

 

Sampling rate

The sampling rate of an equidistant data set or of its Y component.

 

Sampling rate of X component

The sampling rate of a data set's X component.

 

Sampling rate of Z component

The sampling rate of a data set's Z component.

 

Date modified

Date and time of the last modification of an object.

 

Number of dimensions

The number of dimensions for a data set, e.g. 2 for a data matrix.

 

Number of columns

The number of columns in a two-dimensional data set.

 

Number of rows

The number of rows in a data set. In the case of a one-dimensional data set, this is its number of values.

 

Author

The name of the data set author.

 

Calculation description

The description of a calculation.

 

Calculation unit

The unit of a calculation.

 

Calculation formula

The FPScript code of a calculation.

 

Calculation name

The name of a calculation entered on the Calculations tab of an object.

 

Calculation name and value (numerical)

The name and value of a string calculation. Both attributes must match.

Index-based search only

Calculation name and value (string)

The name and value of a numerical calculation. Both attributes must match.

Index-based search only

Calculation value (numerical)

The value of a numerical calculation.

 

Calculation value (string)

The value of a calculation that produces a string.

 

Upper range limit

The upper range limit of a data set or of its Y component.

 

Upper range limit of X component

The data upper range limit of a data set's X component.

 

Upper range limit of Z component

The data upper range limit of a data set's Z component.

 

Lower range limit

The data lower range limit of a data set or of its Y component.

 

Lower range limit of X component

The data lower range limit of a data set's X component.

 

Lower range unit of Z component

The data lower range limit of a data set's Z component.

 

File extension

The file name extension of the file from which the data set originates, such as "fpf" for FlexPro text data.

File index only

File name

The name of the file from which the data set originates.

File index only

File type

The type of file from which the data set originates, as it is displayed in the FlexPro Import dialog box, e.g. "FlexPro Text Data (*.fpf)".

File index only

Data structure

The data structure of a data set.

 

Data type

The data type of a data set or of its Y component.

 

Data type of X component

The data type of a data set's X component.

 

Data type of Z component

The data type of a data set's Z component.

 

Digital

The "Digital" attribute of a data set or of its Y component. (True, if the data set only contains zeros and ones.)

 

Digital X component

The "Digital" attribute of a data set's X component.

 

Digital Z component

The "Digital" attribute of a data set's Z component.

 

Unit

The unit of a data set or of its Y component.

 

Unit of the X component

The unit of a data set's X component.

 

Unit of the Z component

The unit of a data set's Z component.

 

Scalar value (numerical)

The numerical scalar value of a data set.

 

Scalar value (string)

The scalar string value of a data set.

 

Creation date

Date and time of the creation of an object.

File index only

Formula

The FPScript code of a formula or of an object derived from a formula.

 

Quantity

The name of the physical quantity of a data set or of its Y component.

 

Quantity of X component

The name of the physical quantity of a data set's X component.

 

Quantity of Z component

The name of the physical quantity of a data set's Z component.

 

Grandparent folder name

For an object in the project database, this is the name of the folder containing the folder in which the object is located. For an external data set, this is the name of the folder in which the file that contains the data set is located.

 

Origin

The origin of a data set. Usually this is the path name of the file from which it originates.

 

Hyperlink

The hyperlink assigned to an object.

 

Increment

The increment of an equidistant data set or of its Y component.

 

X component increment

The increment of a data set's equidistant X component.

 

Z component increment

The increment of a data set's equidistant Z component.

 

Internal path

The path of an object inside a project database.

 

Category

The object category assigned with the Categorize Object List command.

 

Comments

The comments of an object or of a data set's Y component.

 

Comments of X component

The comments of a data set's X component.

 

Comments of Z component

The comments of a data set's Z component.

 

Machine

The host name of the computer on which the file is stored from which a data set originates.

File index only

Maximum

The maximum of a data set or of its Y component.

 

Maximum of X component

The maximum of a data set's X component.

 

Maximum of Z component

The maximum of a data set's Z component.

 

Minimum

The minimum of a data set or of its Y component.

 

Minimum of X component

The minimum of a data set's X component.

 

Minimum of Z component

The minimum of a data set's Z component.

 

Mean

The mean value of a data set or of its Y component.

 

Mean value of X component

The mean value of a data set's X component.

 

Mean value of Z component

The mean value of a data set's Z component.

 

Name

The object name.

 

Object path

The path of the file on the hard drive or of the folder in the project database where the object is stored.

 

Object path and name

The object name and its path in the project database or on the hard disk.

 

Object text

Any text appearing in an object.

Search in database only; no index

Object type

The object type.

 

Folder path

The path of the folder on the hard drive on which the file is stored from which a data set originates.

File index only

Parameter name

The name of a parameter entered on the Parameters tab of an object.

 

Parameter name and value (numerical)

The name and value of a string parameter. Both attributes must match.

Index-based search only

Parameter name and value (string)

The name and value of a numerical parameter. Both attributes must match.

Index-based search only

Parameter value (numerical)

The text of a string type parameter.

 

Parameter value (string)

The value of a numerical parameter.

 

Parameter unit*

The physical unit of a numerical parameter.

 

Relative end time

The last X value of a data set. The data set must either have an X component or it must be selected as the X component itself.

 

Relative start time

The first X value of a data set. The data set must either have an X component or it must be selected as the X component itself.

 

Standard deviation

The standard deviation of a data set or of its Y component.

 

Standard deviation of X component

The standard deviation of a data set's X component.

 

Standard deviation of Z component

The standard deviation of a data set's Z component.

 

Void values

The "Contains void values" attribute of a data set or of its Y component.

 

Void values in the X component

The "Contains void values" attribute of a data set's X component.

 

Void values in the Z component

The "Contains void values" attribute of a data set's Z component.

 

Parent folder name

For an object in the project database, this is the name of the folder that contains the object. For an external data set, this is the name of the file that contains the data set (without the file extension).

 

Folder path

For a data set on the hard drive, this is the path name of the folder in which the file that contains the data set is located.

Index-based search only

Timestamp

The timestamp of a data set or of its Y component.

 

Timestamp of X component

The timestamp of a data set's X component.

 

Timestamp of Z component

The timestamp of a data set's Z component.

 

* When searching for the unit, the search is case sensitive. When searching in other text, however, case does not matter.

Search operations

Depending on the search criterion data type, you can choose one of the following search operations:

Data type

Operation

Search for object if...

Available in

Text

contains

The specified text appears in the searched text.

 

 

does not contain

The specified text does not appear in the searched text.

 

 

is

The specified text is identical to the text in the searched text.

 

 

begins with

The text that is searched starts with the specified search text.

 

 

ends with

The text that is searched ends with the specified search text.

 

 

does not start with

The text that is searched does not start with the specified search text.

 

 

does not end with

The text that is searched does not end with the specified search text.

 

 

matches

The text to search matches the specified search pattern. See below for more details.

Search in database only; no index

Numeric

equal to

The value to find is identical to the reference value.

 

 

less than

The reference value is smaller than the value to find.

 

 

less than or equal to

The reference value is smaller than or equal to the value to find.

 

 

greater than

The reference value is greater than the value to find.

 

 

greater than or equal to

The reference value is greater than or equal to the value to find.

 

Date & Time

equal to

The reference date matches that of the date to find. The time is ignored in this comparison.

 

 

older

The date and time occur after the date & time specified for the search.

 

 

newer

The date and time occur before the date & time specified for the search.

 

Object

is

The searched object matches the selected type.

 

 

is not

The searched object does not match the selected type.

 

Attribute

true

If the attribute to check is present.

 

 

not true

If the attribute to check is not present.

 

Entering search values

You can enter numerical values as floating point, time span or calendar time. For example:

123

-1.25

1.3E-10

12:13:14.56

4:12:13:14

23.1.2010 12:13:14.56

23.2.2010

2/23/2010 12:13:14.56

You can also enter complex values:

1+3i

(1 ; 3)

FlexPro forms its absolute value and uses it for the search.

You can also calculate the value using an FPScript expression. Start the formula with '=':

= 0.5 * PI

Please note that in FPScript code the period is always used as the decimal separator.

Pattern matching when searching for text

The matches search criterion helps you search for text patterns. The text pattern is defined here as what is called a regular expression. All text is found that matches the given regular expression. In regular expressions, special characters and sequences are used to represent a text pattern. The following table describes these characters and sequences and provides some examples.

Character

Description

^

Finds the beginning of the string.

$

Finds the end of the string.

*

Never finds the preceding character or finds it several times. For example, "zo*" finds "z" or "zoo".

+

Finds the preceding character once or several times. For example, "zo+" finds "zo", but not "z".

?

Finds the preceding character zero times or once. For example, "b?ig?" finds "ig" in "signal".

.

Finds every single character.

x|y

Finds either x or y. For example, "z|wood" finds "z" or "wood". "(z|w)oo" finds "zoo" or "wood".

{n}

n is a non-negative integer. Finds exactly n times. For example, "o{2}" does not find the "o" in "Bob", but it does find the first two o’s in "foooood".

{n,}

n is a non-negative integer. Finds at least n times. For example, "o{2,}" does not find the "o" in "Bob", but finds all o’s in "foooood." "o{1,}" is equivalent to "o+". "o{0,}" is equivalent to "o*".

{n,m}

m and n are non-negative integers. Finds at least n and at most m times. For example, "o{1,3}" finds the first three o’s in "fooooood." "o{0,1}" is equivalent to "o?".

[xyz]

A group of characters. Finds every one of the characters included. For example, "[abc]" finds the "a" in "signal".

[^xyz]

A group of excluded characters. Finds every character not included. For example, "[^abc]" finds the "s" in "signal".

[a-z]

A range of characters. Finds every character in the range. For example, "[a-z]" finds every alphabetical character from "a" to "z".

[^m-z]

A range of excluded characters. Finds every character not in this range. For example, "[m-z]" finds every character that does not lie between "m" and "z".

\b

Finds a word limit, i.e. the position between a word and a space. For example, "al\b" finds the "al" in "signal", but not the "al" in "signals".

\B

Finds a non-word limit. "ea*r\B" finds "ear" in "never early".

\d

Finds a number. Equivalent to [0-9].

\D

Finds a non-numeric character. Equivalent to [^0-9].

\s

Finds a space character. Equivalent to "[ ]".

\S

Finds everything but space characters. Equivalent to "[^ ]".

\w

Finds every word character including underline. Equivalent to "[A-Za-z0-9_]".

\W

Finds every character that does not belong to a word. Equivalent to "[^A-Za-z0-9_]".

Note:   The search only takes into account text that is found for which the regular expression is a pattern for the complete text. "Signal+", for instance, finds the object with the name "Signal1", but not the object "Signal20". The regular expression "Signal+" only looks for the string "Signal2" in "Signal20".

See Also

Project Database

FlexPro Object

Object List

Setting Up Indexing of Project Databases

Share article or send as email:

You might be interested in these articles