powered by CADENAS

Manual

Manual

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

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

    Example:

    exactdata=bolt

    or

    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

      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 3.1.6.7, “ 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 [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] 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

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

      Use brackets in case of unclear relations.

    • NOT: Exclusion of a certain term

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

    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.

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

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.

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.