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

As of V9.08, at Full-text search, projects and link database are always searched together[39]. 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.

Example 1:

Search with "bolt super":

The one term aims to score hits in a project file, the other in the link database.

The one term aims to score hits in a project file, the other in the link database.

The table shows the hit in the LinkDB column DESCRIPTION:

Example 2:

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

The characteristic again is, that the one terms will score hits in project files, the other in the link database.

Search:

gasket OR o-ring

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

That means: Projects are found, which either have the term "gasket" OR the term "o-ring", regardless of whether the term is in the project file or in a LinkDB column.

Search with "gasket OR o-ring"

Search with "gasket OR o-ring"

Search Results:

The hit list contains "o-rings" and "gaskets". It does not matter, where the hit scores, in project files or in the link database.

Search with "gasket OR o-ring"

Search with "gasket OR o-ring"

In the following example the reason is, that the term "Gasket" is found in the DESCRIPTION column of the LinkDB.

[Note]Note

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

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

The blue database icon shows, that the ERP index is available, otherwise it would be grayed out.

The blue database icon shows, that the ERP index is available, otherwise it would be grayed out.

The index contains all role information.




[39] when using an ERP integration

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

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

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