powered by CADENAS


Manual  Full-text search: Search options in detail

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

    • 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] 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] Note

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




    exactdata=“bolt with shank“

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

    Searching in only one certain variable is also possible.


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

      Search in -> Current selection

      or use the Manufacturer filter in search result.

      Manufacturer filter

      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

Filter table in result list

For details see Section, “ Search results ”.

Filter table in part view

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


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

    • Placeholder at the end of the search term


    • Placeholder at the beginning of the search term


      [Note] 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] 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] 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




      will find

      ABC 1234 DEF

      as well.[45]

  • Leading zeros in part numbers

    Searching with


    will find


    [Tip] 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.


    • 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] 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.


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


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


        • Round cylinders shall be excluded.

          cylinder NOT round
          cylinder !round

          [Note] 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] Note

        The AND operator can also be dropped.

        bolt shank
        bolt AND shank

        Examples on the AND operator

        • 16.2 21 90

        • Hexagon bolt L = 400


          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
          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] 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] 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] Note


        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.


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


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

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

    Example: Search for "Cuboid 50". "Cuboid" is found in the table, "50" via topological 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, “ 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, “Wildcard query for a whole directory ”.

[Note] Note 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.

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:


Details on this can be found Section, “ 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.