Manual

Login

Manual

3.1.6.4.2. Full-text search 3.1.6.4.2.2. Full-text search: Search options in detail
Prev	Next

3.1.6.4.2.2. Full-text search: Search options in detail

3.1.6.4.2.2.1. Wildcard query for a whole directory

You can use the Full-text search with terms only, with numbers only or with a combination 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.

Search with exact type designation
```
DNC
```
Term of a classification node
```
mounting element
```
If you get hits inside a classification, this is signalized by the respective icon in the hit list.

After double-clicking on a hit you can see all parts classified in the same way.

Tip

For a better overview you can enable the setting option Do not show empty classifications.

	Tip
For a better overview you can enable the setting option Do not show empty classifications.

Singular - Plural

Singular and plural terms lead to the same results.

Note

You can also perform an Exact Search. A standard search will also find the singular or plural derivation of a term.

Example:

exactdata=bolt

exactdata=“bolt with shank“

-> In this case no plural term (here "bolts") is found.

Searching in only one certain variable is also possible.

VARNAME_EXACT=bolt

-> The search is only performed in the variable VARNAME.

Several terms:

Each term has to exist anywhere in the project. The sequence is irrelevant.
- ```
cylinder manufacturername
```
  Simply add the manufacturer name into the input field in addition
  
  or alternately determine a manufacturer (catalog) under Search in
  
  Search in -> Current selection
  
  or use the Manufacturer filter in search result.
  
  Manufacturer filter
- ```
bolt with shank
```

-> If no variables are specified, you have to do this in the list of Search results or in the Part view.

Filter table in result list

For details see Section 3.1.6.7, “ Search results ”.

Filter table in part view

For details see .Section 3.1.7, “ Part view ”.

Search with combination of terms and variable values ^[44]
- ```
dnc 500 45
```
- ```
hexagon bolt M30x100
```
  or simply
```
hexagon bolt 30 100
```
When filtering with variable values, a respective icon is displayed in the table of Part view top left. When clicking on the icon the table filter is removed and all rows are displayed.
Search only with variable values

A combination of several values may be so specific that stating of terms is dispensable.
```
63 320 10 75
```
-> For example, herewith a Festo cylinder is found.

Search with article number

12345678

If only parts of a number are known, a placeholder can be used.

Placeholder at the end of the search term
```
1234567*
```

Placeholder at the beginning of the search term

*2345678

Note

Limitation when searching with placeholder at the beginning:

The searched term has to be in NN, NB, CNSORDERNO (order number) or ERP_PDM_NUMBER.

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

	Note
	Providing terms with a placeholder has a very strong negative influence on the performance!

Fragmentation of different character types

A combination of characters, numbers and signs is automatically fragmented in its parts internally.
- ```
89AB123.567
```
  In this case the following search would be successful as well:
```
123 567
```
- Searching with
```
ABC1234DEF
```
  or
```
ABC-1234-DEF
```
  will find
```
ABC 1234 DEF
```
  as well.^[45]
Leading zeros in part numbers

Searching with
```
9876
```
will find
```
00009876
```
Tip

Don't use leading zeros for searches. If the desired part actually has leading zeros, it will be found anyway.

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"
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.

Note

Providing terms with a placeholder has a very strong negative influence on the performance!

Logical operators

Relational operators

When searching with variables, you can use logical operators, not only "equal" (=), but all usual mathematical operators.
- = : Equal
- < : Less
- > : Greater
- <= : Less or equal
- >= : Greater or equal
Example:
```
Hexagon bolt L>200
```

Linking operators

Furthermore you can combine terms and numerical values with "AND" or "OR" and exclude certain terms with "NOT".

Note

Upper or lower case makes no difference for the search term.

Operators such as AND, NOT, OR have to be upper case.

NOT: Exclusion of a certain term

Examples:
- Round cylinders shall be excluded.
```
cylinder NOT round
or
cylinder !round
```
  Note
  
  Between exclamation mark (!) and the term to be excluded, there is no empty space allowed.
- If a sequence of several terms shall be excluded, you have to set them into parentheses.
```
Hand wheel !(Form V)
```
AND: All terms have to exist and all conditions have to be fulfilled.
Note

The AND operator can also be dropped.

bolt shank equals bolt AND shank
Examples on the AND operator
- ```
16.2 21 90
```
- ```
Hexagon bolt L = 400
```
  or
```
Hexagon bolt AND L = 400
```
- ```
Hexagon bolts AND >200
```
  Searching for hexagon bolts with any value greater than 200.
- ```
Hexagon bolt L>=140 L<=160
or
Hexagon bolt L>=140 AND L<=160
```
- ```
Hexagon bolt L = 120 AND D = 22
```
- ```
IDNR>=23012001 AND IDNR<=23012025
```

OR: It is sufficient if one term exists or one condition is fulfilled.

Examples on the OR operator

Sechskantschraube OR Zylinderschraube

The result will include both "Sechskantschrauben" and "Zylinderschrauben".

Note

Only in simply cases parentheses can be dropped.

For the same search with English terms, parentheses should be used.

(Hexagon bolt) OR (Head cap bolt)

For more details see next point.

Mixture of AND and OR - Parentheses

Note

General rule

In principal applies:

a b c d OR e

is equivalent to

a AND b AND c AND (d OR e)

In order to rule out any side effects it is recommended to use parentheses for terms linked with OR in any case.

Note

Parentheses

Parentheses have highest priority in processing. That means when using them, you can explicitely determine the logic of processing yourself. So in case of doubt better too many than too few.

Examples:

In English sometimes the term "bolt" and sometimes "screw" is used.

Search input:
```
(head cap) (bolt OR screw)
```
Searching for DIN 34821 or DIN 912

Search input:
```
DIN (34821 OR 912)
```
Searching for head cap bolt with strength class 10.9 or 12.9 (If the values for strength are found in the link database or in the characteristic attribute table doesn't matter.)

Search input:
```
Head cap bolt (10.9 OR 12.9)
```
Searching for a part with two options in length
```
Hexagon bolt (L=380 OR L=400)
```
Searching for a part with two options in length and nominal diameter
```
Hexagon bolt (M10x50 OR M10x60)
```
Searching for a cheese head screw or a hexagon screw with thread proximate till head and at the same time an entry "HiHo" or "Hello" (in the link database).

Search input:
```
(Cheese head screw) OR (Hexagon screws thread proximate till head)
 (HiHo OR Hello)
```
Please always keep in mind: Better too many parentheses than too few. At both parts set parentheses, because the names consist of single terms.

Result:

Query with placeholder '*'
- Alphanumerical search:
  
  Terms are fragmented in meaningful minor terms (substrings according to dictionaries).
  
  With "hex nut" you can find "hexagon nut" without using the placeholder *.
  
  With "hexag" you wouldn't be successful. In this case you have to search with "hexag*". If you are not sure whether the fragmentation could be found in the dictionary, try with placeholder.
- Numerical search:
  
  See above.
Note

Searching with the use of placeholders strongly affects the performance!
Topological measures of length ^[46] ^[47]

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 "Cuboid 50".

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. See Section 3.1.7.9, “Docking window "Topology information "”.

Example: Search for "Cuboid 50". "Cuboid" is found in the table, "50" via topological information.

Explicit Topology search

Use an explicit topology search 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.11, “ Topology search ”.
Search options with ERP integration

It doesn't matter where the search term is contained. The link database is searched as well. So you can search for ERP numbers, material, release state, stock, etc.
```
12345 steel released
```
Wildcard query for a whole directory

See Section 3.1.6.4.2.2.1, “Wildcard query for a whole directory ”.

	Note
	Under Search in, determine the search area. For details see Section 3.1.6.1.1, “ Search in...: Where? ”. Under Search for, determine whether parts or part families should be searched. For details see Section 3.1.6.3, “ Search for Parts \| Part families and Parts ”.

3.1.6.4.2.2.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.

^[44]The search does not consider units. That means, when searching for the value 10 for example, parts with 10 mm and 10 INCH are found.

^[45]Other special characters as hyphen are treated in the same way.

^[46]When executing a Full-text search, topological measures of length are searched through as well, what is very advantageously, especially when using own part catalogs, because here, often a detailed characteristic attribute table is missing. (Otherwise Topology search and Geometric search (3D) are appropriate methods.)

Using this feature requires an updated full-text search index (version >=V11 SP3) plus accordingly set config entry.

In the configuration file partsol.cfg, block INDEX:LUCENE, key TopologyCatalogs, enter the desired catalog path in the following form:

cat/<catalog_name>

Details on this can be found Section 1.3.8.6.2.2, “ Update Full-text search index (and Geometrical search index) for finding topological values via Full-text search ” in PARTsolutions / PARTcommunity4Enterprise - Administration Manual.

^[47]The tolerance is set via configuration file and normally has not to be changed. See $CADENAS_SETUP/partsol.cfg -> block [FULLTEXTSEARCH] -> key TopologyTolerance.

Prev	Up	Next
3.1.6.4.2.1. Full-text search example	Home	3.1.6.4.2.3. What is searched?

Manual

Login

Top Links

Manual

3.1.6.4.2.2. Full-text search: Search options in detail