2.13.1.2. PARTsolutions search
2.13.1.2.16.  Full-text search: Wildcard search with * now possible at the beginning of a search term
Prev  Next
2.13.1.2.16.  Full-text search: Wildcard search with * now possible at the beginning of a search term

Now as of V11 it is possible to perform a wildcard search (*) at the beginning of a search term, however with the limitation that the search term (alphanumerical or numerical) has to be part of the Standard number (NN), Standard name (NB) or order number (CNSORDERNO).

Example:

We are searching the following term:

AN102822

The following searches will be successful:

  • AN1028*

  • *2822
[Note]Note

Using the wildcard in the middle of the search term is not possible:

AN10*22
[Note]Note

Using the wildcard at the beginning AND at the end of the search term at the same time is not possible.

*0282*

[Note]Note

The use of this feature requires an update of the full-text search index!

Basic rules:

  • Alphanumerical search:

    Terms are segmented in meaningful minor terms (substrings according to dictionaries).

    "Tisch" can find "Tischplatte" without using a wildcard *.

    "Tisc" will not find anything. In this case you have to search with "Tisc*".

  • Numerical search:

    A wildcard search * at the end of the search term is not automatically performed for numbers.[22]

    Example:

    • 1234567 will NOT find 12345678.

      1234567* will find 12345678.

  • Segmentation of numbers and characters

    Number and character strings are segmented by default (internally) so that each of them will provide results.

    Example: Searching for the ERP_PDM_NUMBER DEM1596

    You will get results both with DEM and with 1596.

    [Note]Note

    Wildcard search at the beginning like *596 for example is not possible in this case, because it is the ERP_PDM_NUMBER (not NN, NB, CNSORDERNO).



[22] In contrary to V10: In V10 the wildcard could be left out. In V11 explicit adding of the wildcard at the end of the search term is required.

Prev Up Next
2.13.1.2.15. 3D view: Boolean comparison operations in realtime Home 2.13.1.2.17. Custom Search