powered by CADENAS

Manual

Manual

3.1.11.2.1.  Full-text search: Geometry and ERP values mixed

In the following some important things when searching with existing ERP integration shall be clarified:

Example 1:

Using Full-text search projects and link database are always searched together. Even if several search terms are entered it doesn't matter whether hits result from the project file (geometry data) or from a link database column.

[Note] Note

Performing a standard search with simple input of single search terms one after another please regard that ALL terms have to be found (anywhere).

[Tip] Tip

At very specific searches like for ERP numbers or special descriptions it makes sense searching line based, that means to use the option "Search for parts".

Search with "hexagon bolt superduper":

Result: Click on more... to the the details.

Sie sehen, "sechskantschraube" wurde in der Sachmerkmalstabelle gefunden, "superduper" in der LinkDB .

In der Tabelle sehen Sie ebenfalls, dass der Eintrag sowohl in der Projektdatei als auch in der LinkDB erfolgte.

[Note] Note

The filter icon top left signalizes, that the table is restricted. If you wan to see all lines, then click on the icon.

Example 2:

In this example search terms are used, which are linked with the boolean operator OR.[97]

Search with "hexagon bolt OR superduper"

Search with "hexagon bolt OR superduper"

[Note] Note

Don't forget to use Search for parts and part families this time. The search term "hexagon bolt" would result in a huge amount of hits.

The characteristic again is, that some terms will achieve hits in project files, others in the link database.

Search:

hexagon bolt OR superduper

With OR it is sufficient, if one of the terms scores a hit.[98]

That means: Projects are found, which either have the term "hexagon bolt" OR the term "superduper", regardless of whether the term is in the project file or in a LinkDB column.

Search Results:

The hit list contains hexagon bolts, of course, but any bolt could be possible if it contains the search term "superduper".

Search with "hexagon bolt OR superduper"

Search with "hexagon bolt OR superduper"

The reason is, that the project with head cap bolts has an entry "superduper" in the link database.

[Note] Note

Please keep in mind - especially when manually adding a term into the link database, that the ERP index has to be created again.[99]

The respective command is found in PARTadmin -> Index administration -> context menu command Create link database search index.

The blue database icon signalizes, that the ERP index is available, otherwise the icon is grayed out.

The blue database icon signalizes, that the ERP index is available, otherwise the icon is grayed out.

The index contains all role information.



[97] Boolean operators could also be used in earlier versions.

[98] Without operator or when using AND both terms would have to score a hit on the respective line.

[99] In productive use this will happen via nightly update mostly.