You can use the Full-text search with terms only, with numbers only or with a combination of both.
-> If no variables are specified, you have to do this in the list of Search results or in the Part view.
For details see Section 3.1.6.7, “ Search results ”.
For details see .Section 3.1.7, “ Part view ”.
Search with combination of terms and variable values [44]
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
12345678
If only parts of a number are known, a placeholder can be used.
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
ABC1234DEF
ABC-1234-DEF
ABC 1234 DEF
as well.[45]
9876
will find
00009876
Term query with defined sequence (phrase) => "xyz"
Using quotation marks (") you can determine that the contained terms have to occur in the given sequence.
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.
When searching with variables for values, you can use logical operators, not only "equal" (=), but all usual mathematical operators such as "=", "<", "<=", ">", ">=").
Furthermore you can combine terms and numerical values with "AND" or "OR" and exclude certain terms with "NOT".
Variable search with specific value
hexagon bolt L = 400
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
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)
oval-head screw (ST37 OR st70)
NOT: Exclusion of a certain term
cylinder NOT round or cylinder !round
With this round cylinders are filtered.
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.
See above.
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.
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 "”.
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 |
---|---|
|
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.
Save search results in a file
:
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.