Manuals - PARTsolutions

You can perform a full-text search [Full-text search] using terms alone, numbers alone or a combination of both.
If no variables are specified, then you can also do this ...
1. ... in the list of search results [Search results] (For details see Section 3.1.6.7, “ Search results ”. )
  
  Filter table in results list
  
  or
2. ... in the parts view [Part view]. (For details see Section 3.1.7, “ Part view ”. )
  
  Filter table in part view
Define the search area under Search in.
For details see Section 3.1.6.1.1, “ Search in...: Where? ”.
Under Search for, specify whether you want to search for individual parts or part families. For details, see Section 3.1.6.3, “ Search for Parts | Part families and Parts ”.

3.1.6.4.3.2.1. Search with one single term

```
Schraube
```
The term "Bolt" can occur anywhere, also as substring. Some examples:
Through hole for screws
Stop screws
Coil spring

Note
The exact spelling is important, as you will not get a hit if there is a misspelling (Wnad ) or a space (W a n d ).
Search with exact type designation
```
DNC
```
Term of a classification node
```
befestigungselement
```
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
If necessary, activate the setting option Do not display [Do not show empty classifications] empty classifications.

	Tip
If necessary, activate the setting option Do not display [Do not show empty classifications] empty classifications.

3.1.6.4.3.2.2. Singular - Plural

Singular and plural terms lead to the same results.

Also see Section 3.1.6.4.3.2.6, “ Exact search {} ”.

3.1.6.4.3.2.3. Multiple terms

Each term has to exist anywhere in the project.

```
Schraube mit Schaft
```
You could also search:
```
Schaft Schraube
```
The sequence plays a certain role, because exact accordances are higher ranked.
```
Zylinder Herstellername
```
Simply add the manufacturer name into the input field in addition
or alternatively select a manufacturer under Search in

Search in -> Current selection

or use the manufacturer filter [Manufacturer filter] in the Filter docking window.

Manufacturer filter

3.1.6.4.3.2.4. Search with combination of terms and variable values

```
dnc 500 45
```

Sechskantschraube M30x100

or simply

Sechskantschraube 30 100

When filtering with variable values, a corresponding icon appears in the top left of the parts view [Part view] table. Click on the icon to remove the table filter and you will see all rows.

3.1.6.4.3.2.5. 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 can be found.

3.1.6.4.3.2.6. Exact search {}

For an exact search, place the search term in curly brackets {}.

Condition: The searched term must appear in the result in exactly the same way. However, other terms may also appear in the result. The exact search does not tolerate Stemming or word splitting.

Example:

A search with

{Schraube}

will find "Screw" or "Lever with screw", but not "Screws" or "Screwdriver".

The syntax has been changed compared to V11.

Syntax in V11: exactdata=Bolt

Syntax in V12: {Bolt}

For a better understanding, two important differences between phrase search and exact search should be mentioned:

Stemming:^[45]
Phrase search:
```
"mit gebördelt Rohr"
```
finds "flared couplings" (stemming tolerated)
Exact search:
```
{mit gebördelt Rohr}
```
does not find "with flared pipe" (Stemming not tolerated)
Compound words (mainly relevant in German):
Phrase search:
```
"Schraube mit Mutter"
```
also finds "Zylinderschraube mit Mutter". (The compound word "Zylinderschraube" has been treated split in its subparts.)
Exact search:
```
{Schraube mit Mutter}
```
does not find "cap screw with nut".

3.1.6.4.3.2.7. Strict search!

For a strict search [Strict search], place an exclamation mark (!) at the end of the desired term.

Condition: The result may only contain what was entered (apart from spaces or a separator such as a period). The strict search [Strict search] tolerates Stemming [Strict search] ^[46].

Execute the strict search [Strict search] as a variable search only.

Examples:

A search with
```
WS=Steel
```
for example, also finds "Stainless steel".

If you only want to find "Steel", use the strict search [Strict search].
```
WS=Steel!
```
If, on the other hand, you only want hits with "Stainless steel", e.g. you want to exclude hits with "Steel" alone, then combine Phrase search and Strict search.
```
WS="Stainless Steel"!
```

	Note
	If the strict search [Strict search] is to be applied to a combination of several terms, it must be combined with the phrase search.

	Note
	Running a strict search [Strict search] across all catalogs may take a little longer!

3.1.6.4.3.2.8. Phrase search "" (specific order of terms)

For a phrase search (specific sequence of terms), place the entire search term in quotation marks.

Condition: All search terms must be found. There must be neither anything missing nor anything in between. There may be other terms outside the search term. The phrase search tolerates Stemming^[47] and decomposition of compound words.

Example:

A search with

"Schraube mit Mutter"

also finds

Sechskantschrauben mit
Muttern

Here in this example the hit is made by accordance in the project path.

For a better understanding, two important differences between phrase search and exact search should be mentioned:

Stemming:
Phrase search:
```
"mit gebördelt Rohr"
```
finds "flared couplings" (stemming tolerated)
Exact search:
```
{mit gebördelt Rohr}
```
does not find "with flared pipe" (Stemming not tolerated)
Compound words (mainly relevant in German):
Phrase search:
```
"Schraube mit Mutter"
```
also finds "Zylinderschraube mit Mutter". (The compound word "Zylinderschraube" has been treated split in its subparts.)
Exact search:
```
{Schraube mit Mutter}
```
does not find "cap screw with nut".

3.1.6.4.3.2.9. Wildcard search *

If you only know subparts of a string of numbers, characters or combined numbers and characters, you can use the wildcard search. The searched part may occur at any place.

Example:

With

*A89*

is found, for example, 1SF A89 7102R7000.

If the unknown places do occur at the beginning, at the end or in the middle, doesn't matter. Also the number of used placeholders is arbitrary.^[48]
```
1SF*7102R7000
```
```
1SFA8*102R*000
```
In V11, single positions could be replaced by the placeholder (?). This placeholder also works in V12, however, much more easier and flexible is the placeholder (*), as it may stand for no, one or multiple characters.
```
1SFA8?
?102R?000
```
If the unknown part is delimited by spaces, separators such as periods or characters of a different type (numeric/alphanumeric), the placeholder is not required.
Alphanumeric search:
By default, terms are fragmented in meaningful minor terms (substrings according to dictionaries).
With table you can also find table top without using the placeholder *.
However, you cannot find what you are looking for with Tisc. In this case, you must use the wildcard search and search with Tisc *.
Numerical search:
123 * 567 *
A wildcard search does not use Stemming^[49] is executed. * chraube only finds schraube and not schrauben. If you want to find both, you must specify *chraube*.
A wildcard search is always associated with a certain loss of performance, but it depends on how many hits there are. For example, a search for s* is significantly slower than a search for *screw. If a search for s* is carried out across a large number of catalogs, it can happen that the PARTapplicationServer aborts the search because it would cost too much performance. In this case, an error message such as: Placeholder search too general. [Wildcard search too general. Narrow down the search by specifying additional letters or numbers.] Restrict the search further by entering additional letters or numbers. [Wildcard search too general. Narrow down the search by specifying additional letters or numbers.]

3.1.6.4.3.2.10. Leading zeros in part numbers

Searching with

finds

00009876

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

3.1.6.4.3.2.11. Search for negative values

You can explicitly search for negative values.

Example:

-5 oder WINKEL=-5

Simply enter the negative value. In this way the search for negative values is performed with the highest priority.

3.1.6.4.3.2.12. Number search for a range

If you are searching for a range of numbers and the search is actually to be carried out as a number search, you must enclose the search string in square brackets, e.g. D=[10-14]. If you omit the brackets, a textual search will be carried out.

Examples:

```
D=[10-12]
[10-20]
```
PARTdataManager: Set range in brackets

3Dfindit: Set range in brackets
Square brackets are already used in the number search with units, so the two options can also be combined.
```
D=[1-2 inch]
```
Note
There must be a space between the number and the unit.

PARTdataManager: Result in Inch

PARTdataManager: Result in mm (a conversion to mm is automatically performed, so that also here appropriate result will be found)

3Dfindit: Result in inch

PARTdataManager: Result in mm (a conversion to mm is automatically performed, so that also here appropriate results will be found)
More examples:
```
[10-20 mm]
30[mm]
[10 mm]
```

3.1.6.4.3.2.13. Number search with units (explicitly and implicitly)

Examples:

Numerical values are indexed in their base unit. They can also be searched for by specifying a desired unit as a search operator in square brackets [].^[50]
- A search for 5 will find 5 mm and 5 INCH.
- A search for 25.4[mm] will find both 25.4 mm and 1 inch.
- A search for 1 [inch] will find both 1 inch and 25.4 mm.
Values can be searched for in inch notation (e.g. 3 1/2 )
A fractional representation is evaluated as inches by default and a conversion to mm takes place automatically in the background so that mm values are also found.
```
1/2
```
```
1 1/2
```
38.1 mm and 1 1/2 inch are equivalent.
If you want to search for "mm" with a fraction, you have to add "mm" in square brackets.

Note
Only if the unit is explicitly stated, searching is exclusively numerical, otherwise textual.
```
1/2 [mm]
```
When wanting to explicitly search for Inch you have to add "inch" in square brackets.

Note
Only if the unit is explicitly stated, searching is exclusively numerical, otherwise textual.
```
0.5 [inch]
```
Also with inch, you can search "from-to".
```
1/2 - 3/4
```
```
1 1/2 - 1 3/4
```
Also when using from-to statements the unit can be added behind.
```
1 1/2 [inch] - 1.75 [inch]
```
If there is no explicit statement, the last token defines the unit.
The following search leads to Inch results, because the fraction is automatically interpreted as Inch.
```
1.5 - 1 3/4
```
Inch values could also be part of order numbers, for example.

3.1.6.4.3.2.14. Logical operators

Comparison 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:
```
Sechskantschaube L>200
```
Link 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 specific term
  Examples:
  - Round cylinders shall be excluded.
    
    Zylinder NOT rund oder Zylinder !rund
    
    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.
    
    Handrad !(Form V)
- AND: All terms must occur or all conditions must be met.
  Note
  The AND operator can also be dropped.
  
  Schraube AND Schaft ist gleichbedeutend mit Schraube Schaft
  Examples on the AND operator
  - 16.2 21 90
  - Sechskantschraube L = 400
    
    or
    
    Sechskantschraube AND L = 400
  - Sechskantschrauben AND >200
    
    Searching for hexagon bolts with any value greater than 200.
  - Sechskantschraube L>=140 L<=160 oder Sechskantschraube L>=140 AND L<=160
  - Sechskantschraube L = 120 AND D = 22
  - IDNR>=23012001 AND IDNR<=23012025
- OR: It is sufficient if a term occurs or a single condition is fulfilled.
  Examples on the OR operator
  - Sechskantschraube OR Zylinderschraube
    
    The result will include both "Sechskantschrauben" and "Zylinderschrauben".
  - (Hexagon bolt) OR (Head cap bolt)
    
    is equivalent to
    
    Hexagon bolt OR Head cap bolt
    
    The brackets are dispensable. The empty space is equivalent to AND.
  For more details please see next point.

3.1.6.4.3.2.15. Mixture of AND and OR - Parentheses

	Note
	Empty space is equivalent to AND AND has higher priority than OR Parentheses has higher priority than AND and OR

Examples:

Searched: A hexagon bolt with either M10x50 or M10x60
```
Sechskantschraube (M10x50 OR M10x60)
```
is equivalent to
```
Sechskantschraube M10x50 OR Sechskantschraube M10x60
```
If you would omit the brackets in the first case, you would receive much more unclear results.
-> Result:
In English sometimes the term "bolt" and sometimes "screw" is used.
Search input:
```
head cap (bolt OR screw)
```
Searched ISO 4762 or ISO 12474
Search input:
```
ISO (4762 OR 12474)
```
Searched: 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:
```
Zylinderschraube (10.9 OR 12.9)
```
Searching for a part with two options in length
```
Sechskantschraube (L=380 OR L=400)
```
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:
```
(Zylinderschrauben mit Innenvielzahn) OR (Sechskantschraube Gewinde annähernd 
 bis Kopf) (HiHo OR Hello)
```
Result:

3.1.6.4.3.2.16. Topological measures of length

A full-text search [Full-text search] not only searches table values, but also topological linear dimensions, which is particularly advantageous for own parts catalogs, as these often lack a detailed characteristic table.

Hits from the topology are displayed in a separate Topology column and are highlighted in yellow.

(Alternatively, topology search [Topology search] and geometric search (3D) [Geometric search (3D)] are also available)

Prerequisite:

The use of this feature requires an updated full-text search index plus a correspondingly set configuration entry.

In the configuration file partsol.cfg, block INDEX:LUCENE, key TopologyCatalogs insert the desired catalog path in the following form:^[51]

cat/<catalog_name>

For details, see Section 1.3.3.6.6.15, “ Update full text search index (and geo search index ) for finding topological values via full text search ” in PARTsolutions Administration - Manual .

Example:

The figure shows an example with the search term "Cuboid 50".

In the parts view [Part view], you will also find the Topology information docking window with a detailed list, which also contains the number of respective occurrences. 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 (even if there are no table values).

Explicit Topology search

Use an explicit topology search when searching for details.

For example, if you are looking for "3 holes with a diameter of 5", switch on the topology search [Topology search].

See Section 3.1.6.4.12, “ Topology search ”.

3.1.6.4.3.2.17. 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 Stahl released

3.1.6.4.3.2.18. Wildcard query for a whole directory

With a wildcard search (*) in the Full text search [Full-text search] input field, all projects in the directory set under Search in are displayed.

This is interesting, for example, for a cloud map [Cloud Map] search or exporting the search result list of an entire 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.

3.1.6.4.3.2.19. Background information

3.1.6.4.3.2.19.1. Automatic splitting of search terms

In V12 the search term is automatically split into single subterms what can be useful especially in German with its many compound words.

For example, radial shaft seal ring in radial-shaft-seal-ring

For all resulting combinations, searches are performed, and in this case it really makes sense because there are different spellings over all catalogs.

Radial-Wellendichtring

Radialwellen-Dichtring

Also a turn of single parts leads to desired results.

Dichtring Radialwellen

With correct sequence even a phrase search would lead to the desired results, so for example:

"Radial Welle"

In V11 there were only hits with exact accordance compared to the search term.

3.1.6.4.3.2.19.2. Toleration of wrong divisions in strings

A combination of characters, numbers and signs is automatically fragmented in its subparts internally at empty spaces, separators and transitions between different types of characters (numerical/alphanumerical), so that at these places also divergent separations will be tolerated.

```
89AB123.567
```
In this case the following search would be successful as well:
```
123 567
```
With the input of
```
ABC1234DEF
```
or
```
ABC-1234-DEF
```
becomes
```
ABC 1234 DEF
```
is also found.^[52]

3.1.6.4.3.2.19.3. Ranking

Words in the beginning of a field are ranked higher (NN, NT and NB)
In compound words (only concerns German), the last component has a higher rank.
For example, when searching for screw, the result hexagon screw is weighted higher than screwdriver.
When searching for multiple words, results where these words are in the same order are ranked higher.
Exact word matches receive a higher rank.
Example:
A search for screw prioritizes the word screw over cylinder screw.
This means that hits with the word screw are listed in the search results before hits with cylinder screw.
In V11, an accumulation of same words reduced the rank. This is removed in V12.

3.1.6.4.3.2.19.4. Find order numbers with empty spaces and special characters

In V12, order numbers with empty spaces and special characters are also found even if the spelling is not quite correct.

Example:

The following order number contains empty spaces.

XVEWO NW 10 HL

It is even found when searching without empty spaces.

XVEWONW10HL

3.1.6.4.3.2.19.5. Extraction of zeros from search terms

If a search terms includes zeros, the search is performed both with the original search term and in addition with extracted zeros. If both methods lead to results, exact accordances are higher ranked and so are listed on top.

3.1.6.4.3.2.19.6. Search for values of value range fields

In V12, you can search for values of value range fields (if they do not depend on others).

In the search result and in the part view the searched value is set and marked.

Search result: Searched value set

Part view: Searched value set

^[45]Stem form reduction, normal form reduction of languages, e.g. singular and plural

^[46]Stem form reduction, normal form reduction of languages, e.g. singular and plural

^[47]Stem reduction, normal form reduction of languages, e.g. singular and plural

^[48]In V11 the placeholder (*) was only allowed either at the beginning or at the end of a search string.

^[49]Stem form reduction, normal form reduction of languages, e.g. singular and plural

^[50]Works for all units contained in the configuration file unitbase.cfg.

^[51]The tolerance is set in the configuration file and generally cannot be changed. See $CADENAS_SETUP/partsol.cfg -> Block [FULLTEXTSEARCH] -> Key TopologyTolerance.

^[52]Special characters other than the hyphen are also treated in this way.

Prev	Up	Next
3.1.6.4.3.1. Full text search example	Home	3.1.6.4.3.3. What is searched?