Notes on Searching for Data with the DataFinder Toolkit

LabVIEW 2018 DataFinder Toolkit Help

Edition Date: June 2018

Part Number: 372745L-01

»View Product Info
Download Help (Windows Only)

Text Search or Query

Use the text search if you only have parts of the information you are searching for, or if you do not know whether the information you are searching for is in a file, a group, or a channel.

Use the query if you want to search for specific files, groups, or channels. In a query you can specify, for example, that you want to search for channels or files named Time. You can run more complex queries if you combine several search conditions.

The text search and the query are not case-sensitive.

Special Features of the Text Search

If you work with the Text search VI, separate the search terms with spaces. After you execute the text search, the DataFinder returns all files that contain these search terms regardless of whether the DataFinder found the search term in the property of a file, a group, or a channel.
The text search also searches for parts of search terms. The part of the search term must be at the beginning of the search term, for example, exa*.

Note the following characteristics of the quick search:

  • If you enter quotation marks within a search term, DataFinder replaces the quotation marks with a space.

  • If the wildcards (* and ?) are at the beginning of a search term, the text search does not take them into account.

  • If a search is too unspecific, for example, a search for te*, the DataFinder might not be able to return any results although many files match this query. In this case you should specify the query more accurately to limit the search results.

Special Features of a Query

A query consists of one or more search conditions. A search condition comprises the file property, the channel group property, or the channel property the DataFinder searches for, and the operator and the value with which the DataFinder compares the property. Before the search starts you can specify whether the DataFinder returns files, channel groups, or channels as the search results.

By default the DataFinder connects all search conditions with an AND operator. However, you can specify a logical operator yourself and connect the search conditions with AND and OR as you like. Use parentheses to specify the order of evaluation.

Please note the following characteristics of a query:

  • By default, the DataFinder executes a logical AND operation on the search conditions of an advanced search. This means that, for example, the search for groups that contain channels with the name Channel1 AND channels that contain the name Channel2, can never return a result.

  • You can execute OR operations on single values of a search condition, or on entire search conditions, for example, to search for several filenames. Enter the values in the Value column of the search input area and insert an OR between these values. Alternatively, click the ... button multiple times and double-click another value each time, to select the value. DataFinder then automatically executes an OR operation on the selected values. You must select the = sign to connect values with OR.

  • You also can create OR operations in the logical operations line. Create a search condition in the search input area, click the logical operations line, and then enter OR.

  • You only can use wildcards (* and ?) when you search for text properties. If you search for text that contains spaces, you must enter a question mark (?) as a wildcard for each space, in the search.

  • Use the operators =, <>, <, <=, >, and >= to search for numeric properties.

  • When you search for text properties, you can use only the operators = and <>.

  • In the advanced search for date/time properties, for example, for the file property Modify date, the DataFinder provides the following operators: =, >=, <=, and #. If you select the # operator in the DataFinder interface, you can use the following operands: Today, Yesterday, Last 7 days, Last 14 days, Last 30 days. If you execute a search with the # operator in a script, use the following operands: Today, Yesterday, LastSevenDays, LastFourteenDays, or LastThirtyDays. The DataFinder executes the search in relation to the current date. For example, if you use the operator # to search for the creation date Today, and you save the search, the search uses the current date if you run the search again at a later date.
    If you want to search for DataTypeDate type custom properties, you must first optimize this custom property.

  • If you use the = operator when you search for date and time properties, you can search for the exact date, otherwise for the exact second.

  • If you search for the text Or, you must enter /Or as the search text, instead of Or.

  • If you search for a text property, the property must not be longer than 256 characters.

  • The search results are listed in ascending order of the values of the property of the first search condition, according to the following conditions: The property must be a base property or an optimized custom property. DataFinder must be able to clearly evaluate this property for the search result. DataFinder can clearly evaluate only file properties when it searches for files. DataFinder can clearly evaluate only file properties and channel group properties when it searches for channel groups.


Not Helpful