Collapse AllExpand All

13.1.5. Search Path

To configure the search path, go to System > Setup > Configure > Search Path. The following screen will appear:

Configure Search Path

When configuring the search path, you are presented with the following options:

Schemas Not in Order

Displays a list of schemas that exist in the xTuple PostgreSQL database. The list is not displayed in a particular sort order. You have the options to view whether a schema forms part of a package and whether or not it is enabled.

Show all schemas

Check this box to display all schemas in the PostgreSQL database. Uncheck to show only schemas related to xTuple.

Schemas in Order

From the Schemas Not in Order list, consecutively select schemas that you want to be searched in a particular order by PostgreSQL. You can use the MOVE UP and MOVE DOWN buttons to change the order of the selected schemas.

New Search Path

The search path that will be used is displayed in this area. Any schemas that you have selected to be searched in order will take priority in the selected sequence in the search path. Apply or save your changes and restart xTuple to put the new search path into effect.