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
```

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 ^[40]
- ```
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.^[41]
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

When searching with variables for values, you can use logical operators, not only "equal" (=), but all usual mathematical operators such as "=", "<", "<=", ">", ">=").

<: less
>: greater
<=: less or equal
>=: greater or equal

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

AND: Both terms you to exist or both conditions have to be fulfilled.
OR: It is sufficient, if only one term exists or one single condition is fulfilled.

Note

Use brackets in case of unclear relations.
NOT: Exclusion of a certain term

Note

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

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

Examples:

Variable search with specific value
```
hexagon bolt L = 400
```
Search with AND operator

All terms linked with the AND operator have to be part of the result. This is also the case, if no operator is used.
```
bolt shank

equals

bolt AND shank
```
```
16.2 21 90

equals

16.2 AND 21 AND 90
```
```
hexagon bolt  L>=150 AND L<=160
```
```
hexagon bolt  L = 120 AND D = 22
```
```
IDNR>=23012001 AND IDNR<=23012025
```

Search with OR operator

With the OR operator the search can be broadened with several terms. At least one term has to match.

hexagon bolt  OR cylinder head cap bolt

hexagon bolt  (M10x50 OR M10x60)

Note

Use brackets in case of unclear relations.

In above example, without brackets a hexagon bolt with M10x50 OR "anything" with M10x60 would be searched.

oval-head screw (ST37 OR st70)

NOT: Exclusion of a certain term
```
cylinder NOT round
or
cylinder !round
```
With this round cylinders are filtered.

Note

Between exclamation mark (!) and the term to be excluded, there is no empty space allowed.

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 ^[42] ^[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 "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 ???. 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.

^[40]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.

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

^[42]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.4.5.2.1, “ Update Full-text search index (and Geometrical search index) for finding topological values via Full-text search ” in PARTsolutions / PARTcommunity4Enterprise - Administration Manual.

^[43]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