Skip to main content

Coins ERP+ Global search

Updated over 2 months ago

A new search feature allows users to search for records in the COINS database (for example, suppliers, customers, subcontractors or jobs). The search is configurable, so you can choose which tables, and which fields on those tables, to include in the search.

  1. Key Parameters to Initially Set:

    • SY/GLOBSRCH - Whether the Global Search is in use (Y or N).

      • If this is set to N, the Search results only include COINS functions.

      • This can be overridden for individual users in System > User Maintenance > Users.

        • NOTE: To use the search frame, the user must have a COINS Desktop configured.

    • SY/SRCHMON - The email address to which any error messages encountered during the global search process will be sent.

    • SY/SRCHOPEN - The system default for how links in Global Search results will open.

      • Main Area – Open in the current main area.

      • Frame – Open in a new desktop frame.

      • Frame with Banner – Open in a new desktop frame with the COINS function title (useful if the function has navigation links in the title).

      • Window – Open in a separate window or tab (this depends on the browser).

      • This can be overridden for individual users in System > User Maintenance > Users, and for individual search types using System > System Setup > Global Search Configuration.

    Figure 1: Key System Parameters

    Global Search now has Extended Search Capability (SOLR) to allow the searching and indexing of any data within COINS, including transactional data. The following new SY parameters corresponding to this change are therefore now available.

  2. These parameters will be set by COINS Tech Department during installation of SOLR.

    • SY/SRCHENGN - Search engine. Blank is the default, which indicates that standard COINS searching will be used.

    • SY/SRCHURL - Base URL for Apache SOLR, such as http://localhost:8983/solr/.

    • SY/SRCHCOL1 - Collection name for COINS data; each collection has a schema and holds data. Multiple collections can be configured for different COINS environments.

    Before adding or deleting a configuration record, it is necessary to stop the index process, and start it again after the record has been added or deleted.

  3. OA ver11.06 makes this possible via Search Broker Status Start and Stop buttons on the Global Search Configuration page.

    Figure 2: Broker Start and Stop Button on Global Search Config Page

  4. Attempting to modify the Global Search Configuration while the Search Brokers are running will result in an error.

    Figure 3: Search Broker Error

    The new Global Search Configuration function allows you to set which tables and fields will be searchable. Before making any changes, stop the search index process. See Step #3 above.

  5. Global Search comes with several standard search configuration records. If you want to use one of these standard searches, open the record and check the Use box.

    Figure 4: Use Check Box and Security RSP Field

  6. Make note of the Security RSP field. This is an optional RSP that returns a security query. For example, job-rsp has a function “getSecurityFilter()” which returns a query condition based on the security code and job security that has been setup. COINS uses this to check that the user is allowed to view the record that is found in the search. If not, then the detail frame is not shown and the link on the item is disabled, so the user can see that a job exists but cannot see the details.

    • If blank then no security is used.

  7. The Build Data action allows you to create, update or delete search index data for a selected configuration record or records. Run this for any configuration lines that have changed.

    Figure 5: Build Data Action

  8. When the appropriate records are selected and the Apply Action button is clicked, COINS displays the following screen, with these options:

    • Delete - Whether to delete the index data for the selected tables. Use this to remove existing indexed records, for example if you have changed the search conditions.

    • Initialize - Whether to create index data for the selected tables.

    • Type - Whether to process company, global or both sets of records.

    • Companies - If processing company-specific data, this is a list of companies to process.

    Figure 6: Build Data Options

  9. Once fully configured, and with the Search Brokers running, the Search frame can be launched by:

    • Pressing Ctrl+Shift+?

    • Clicking the “Magnifying Glass” button on the Desktop.

    Figure 7: Magnifying Glass Icon

Note: The Search frame is only available if you have a COINS Desktop configured and if Global Search is enabled by the configuration of both your system and your user record.

Figure 8: Global Search Frame

  1. You can type a word or words to begin the search. As you type, COINS displays matching records, grouped by index type. If you cursor up or down, or hover over an item with the mouse then a detail frame to the right shows more detail about that record.

    Figure 9: Search Frame with Live Data

  2. You can filter the search to show only records that belong to the categories you select. COINS remembers your filter settings and the text you searched for, and uses them the next time you open Global Search (until you log out).

    Figure 10: Filtering Search Results

  3. Clicking the link on the item launches the corresponding link page. This can open in in a new desktop frame, in a new tab, or in the current main area. See Step #13 below.

  4. Two new fields have been added to the Preferences tab in User Maintenance.

    • Search On - Whether the global search feature is available for this user.

      • If set to Default, the setting of the SY/GLOBSRCH parameter is used.

    • Search Open In - How links from the Global Search function should open (in what type of window/frame).

      • This only applies if the "open in" method has not been set for a particular search type in System > System Setup > Global Search Configuration.

      • This can be one of these options:

        • Default – Use the setting on the user's record and the SY/SRCHOPEN parameter

        • Main Area – Open in the current main area.

        • Window – Open in a separate window or tab (this depends on the browser).

        • Frame – Open in a new desktop frame.

        • Frame with Banner – Open in a new desktop frame with the COINS function title (useful if the function has navigation links in the title).

    Figure 11: New Fields on User Record

Did this answer your question?