SYSPRO Espresso > Search Configuration

Search Configuration

This program lets you add and maintain key field searches that can be used within Espresso, and within SYSPRO (if you have enabled the predictive search facility).

The program lets you define what key fields are searched on, the search criteria to use, and how the data is rendered for each key type. You access the program from within the search window and clicking the Settings icon.

Search criteria are based on a database query table (EspSearch) and differ for each type of key field.

Suggested key values are shown in a listview with pre-configured typography. You can change how the data is rendered using XAML Markup.

Panes

Configured Searches

This pane displays the searches that are currently defined.

Field Description
Add This lets you define a new key field search.
Copy This lets you copy the selected search to another level (i.e. system-wide, company, role, or operator).

New Search

Field Description
New Search  
Key field Indicate the key field to use in this search. This entry defines the column browses on the Search Details and Search Criteria panes.
Level Indicate at what level you want the search to apply (i.e. system-wide, company, role or operator).
Search Details  
Layout preview This lets you preview the XAML layout defined for the predictive search.
Configuration
Option Description
Enable predictive search in SYSPRO This lets you enable/disable the predictive search function for this key and level combination.
Predictive search layout The Edit hyperlink lets you define how you want to display the predictive search results, using XAML markup.
Search parameters
Option Description
Fields to return Select the field hyperlink to indicate the columns that must be returned by the search (up to 10). If more fields are selected they will display as their parameter name (e.g. %11%).
Order by fields Select the field hyperlink to indicate the field order for the search results. This order is used for the XAML markup placeholders, as well as specific functions within Espresso.
Number of rows to return Indicate how many rows to return in the search results. The maximum is 50.
SQL statement This displays an example of the SQL statement that will be executed for the current search. This is a read only field.
Search Criteria Define the criteria on which the search must be based.

For example: Below is an example of the search criteria for a stock code using either the stock code, description and long description, and excluding stock codes that are on full hold.

((StockCode LIKE '%{Search text}%') OR (Description LIKE '%{Search text}%') OR (LongDesc LIKE '%{Search text}%')) AND (StockOnHold !='F')

Notes and warnings

Key field considerations

  • You cannot configure custom searches for the following key fields adding a new search:

    • Contact

    • ContactAccounts

    • ContactCustomers

    • ContactSupplier

    Note that you can, however, still configure custom searches for Customer and Supplier key types.

Restrictions and limits

  • Up to 10 XAML search parameters can be passed to the predictive search facility.

System-wide Personalization

Predictive Search