Manual

Login

Our 3D CAD supplier models have been moved to 3Dfindit.com, the new visual search engine for 3D CAD, CAE & BIM models.

You can log in there with your existing account of this site.

The content remains free of charge.

Manual

3.1.6.4.2. Full-text search 3.1.6.4.2.3. Full-text search options - Syntax
Prev	Next

3.1.6.4.2.3. Full-text search options - Syntax

3.1.6.4.2.3.1. Wildcard query for a whole directory

Term query (alphanumerical and numerical)

A term query is the actual basis for all queries. The search term may exist of text or numbers or a mixture of both.

One term:

Bolt

The term "Bolt" can occur anywhere, also as substring. Some examples:

Through boring for bolts

Stop bolts

Bolts with flange

	Note
	A precise spelling is important. With scrambled letters (blot) or empty spaces (b o l t) you won't get any results.

Singular - Plural

Singular and plural terms lead to the same results.

Several terms:

Each term has to exist anywhere in the project. The sequence is irrelevant.

Bolt with shank
Hexagon bolt M10x50

	Note
	"M10x50" is not yet a variable search in the real sense (on this see under Section 3.1.6.4.3, “ Variables search ”), but is contained as text in the table. So empty spaces between the single parameters make a difference. A query with "M 10 x 50" is not successful.

Differentiation of character types

Inserting
```
ABC1234DEF
```
or
```
ABC-1234-DEF
```
```
ABC 1234 DEF
```
is also found.^[42]
Leading zeros in part numbers

Inserting
```
9876
```
```
00009876
```
is also found.

Topological measures of length ^[43]

Not only table values are queried, but also topological measures of length.

This extension is especially beneficial when searching own part catalogs, because here characteristic values are not necessarily found in the table.

Hits from the topology are displayed in an own column Topology and are marked with yellow.

The figure shows an example with the search term "Tischplatte 266".

In the Part view you can find the docking window Topology information in addition with a detailed listing which also contains the number of each occurrence.

Example: Search for "tischplatte 266".

Explicit Topology search

An explicit topology search is used when searching for details.

If, for example you are searching for "3 holes with diameter 5", then add the Topology search. On this see Section 3.1.6.4.10, “ Topology search ”.
Term query with NOT operator

A NOT operator can be used in order to exclude certain terms from the results. Different spelling can be used for this method.
```
Bolt NOT reduced shank
Bolt !reduced shank
```
A hit "bolt with shank" for example can be filtered in this way.
```
Bolt flush mounted NOT not
Bolt flush mounted !not
```
A hit "bolt not flush mounted" for example can be filtered in this way.

Note

Between exclamation mark (!) and the term to exclude there may not be an empty space.
Term query with OR operator

With the OR operator the search can be expanded to several terms. At least one of the terms has to apply.
```
Hexagon bolt OR Head cap bolt
```
Term query with AND Operator (Default!)

All terms connected by the AND operator have to be part of the result. This kind of query leads to the same result when no operator is used.
```
bolt AND shank
bolt shank
```
```
16.2 21 90
16.2 AND 21 AND 90
```

Term query with defined sequence (phrase) => "xyz"

Using quotation marks (") you can determine that the contained terms have to occur in the given sequence.

Examples:

Term without quotation marks:
```
Hexagon head bolts with shank
```
This search both leads to exact hits and hits such as "Hexagon flange bolts with reduced shank".

Term with quotation marks:

"Hexagon head bolts with shank"

This search leads only to exact hits such as "Hexagon head bolts with shank", because the terms have to be directly behind one another.

Note

Using the plural form

"Hexagon head bolts with shank"

leads to the same hits than using the singular form.

"Hexagon head bolt with shank"

A "query with phrase" is automatically generated when a term contains special characters or terms which are composed by characters and numbers.

AB1-455-PDA => "AB 1 455 PDA"

Query of terms with placeholder (wildcard) '*'

Wildcard at the end of term or number
- Alphanumerical search:
  
  Terms are segmented in meaningful minor terms (substrings according to dictionaries).
  
  "Tisch" can find "Tischplatte" without using a wildcard *.
  
  "Tisc" will not find anything. In this case you have to search with "Tisc*".
- Numerical search:
  
  A wildcard search * at the end of the search term is not automatically performed for numbers.^[44]
  
  Example:
  
  Search for:
```
12345678
```
  - A search with
    
    1234567
    
    will not be successful.
  - A search with
    
    1234567*
    
    will be successful.

Wildcard at the beginning of term or number

Note

Restriction:

The searched term (alphanumerical or numerical) has to be part of NN, NB, CNSORDERNO (order number) or ERP_PDM_NUMBER.

The placeholder has to be at the beginning OR at the end of the search term. Before and behind at the same time is not possible.

Example:

Search for:

AN102822

Searching with
```
*2822
```
is successful.

Placeholder in the middle of term or number is NOT possible.

	Note
	The use of this feature requires an update of the full-text search index!

	Note
	Searching with the use of placeholders strongly affects the performance!

Query of terms with wildcard '?'

The wildcard '?' allows any character instead of the wildcard (?). You can also use several wildcards at any position.
```
ABC-5?6
```
Use this option for replacements in order numbers. That means, for example, in a search term such as ABC-1234-3421 or ABC783892. This option is not intended for replacements in alphanumerical terms.
Wildcard query for a whole directory

See Section 3.1.6.4.2.3.1, “Wildcard query for a whole directory ”.
Syntax for table variables

Full-text search and Variables search can be combined in the input field. With numbers mm supposed.

Connect the variable name with certain values by using mathematical operators.
- Variable name with concrete value
```
Hexagon bolt L1 = 400
```
- In order to search for several variables, use mathematical operators.
  
  Note
  
  Upper or lower case makes no difference for the search term.
  
  Operators such as AND, NOT, OR have to be upper case.
```
Hexagon bolt L > 150 AND D = 20
Hexagon bolt L = 150 OR D = 20
```
- Not only (=) can be used, but all established operators such as (=, <, <=, >, >=).
```
Hexagon bolt L >= 120 AND L < 160 AND D = 22
```
- Use brackets
  
  Example 1:
  
  Hexagon bolts shall be found, either with the characteristic M10x50 or M10x60.
  
  Search term:
```
Hexagon bolt (M10x50 OR M10x60)
```
  Example 2:
  
  Bolts with material St37 or St70 shall be found.
  
  Search term:
```
Bolt (st37 OR st70)
```

3.1.6.4.2.3.1. Wildcard query for a whole directory

Performing a wildcard search (*) in the Full-text search input field all projects of the directory set under Search in are outputted.

This can be interesting for a Cloud Map Search or also the export of the search result of a whole directory.

Cloud Map Search:

Example: All handles of the set directory are displayed in the Cloud Map.

Save search results in a file :

Click on the button .

The respective dialog box opens. Here you can specify the columns to be exported. You can save all search results or only the selected ones.

^[42]Other special characters are handled in the same way.

^[43]After an update of version providing this functionality, the full-text search index has to be generated anew.

^[44]In contrary to V10: In V10 the wildcard could be left out. In V11 explicit adding of the wildcard at the end of the search term is required.

Prev	Up	Next
3.1.6.4.2.2. Full-text search example	Home	3.1.6.4.2.4. What is searched?

Manual

Login

Top Links

Manual

3.1.6.4.2.3. Full-text search options - Syntax