Query button

The Query facility is available from certain fields that access static data records. It allows you to search for and select an existing record. By default the records are sorted by their code.

Button Client
Windows client
Web

User definable lookups can be created by configuring search criteria on the following query routines:

  • Address
  • Supplier
  • Customer
  • Item
  • Account
  • Asset

To configure a query, create an SSQSEL form in Form Designer that contains the parameters for which you would like to search. For example, if you want to search for a combination of Post Town, Telephone Number, and the First Line of Address on the Address Query, you would create a form called SSQSEL for the function Address (VW5138) containing those three fields.

Note: You must log off and on again before the form is detected.

You can use any field on the base table as a search parameter, with a maximum limit of 20 fields, but cannot use data from any related tables in the function. For example, for the Customer Query any field from the main Customer table can be used but not fields from the Contact/Tax related tables that are also included within the static data function. If any of those are put on the SSQSEL form they will be disabled.

Use the Query button or the F5 key, for example from the Address Code fields, to display the SSQSEL Query form. This window displays data specific to the field you are searching on.

Select the row you require and click OK. The Query window closes and the highlighted record appears in the field.

Note: If a query field is located within a grid in the Windows client, the icon is displayed in the column heading.
Note: Using single-byte and double-byte characters in lookups (which are Primary and Secondary database keys) can cause errors or produce inaccurate results when used for range checking (in selecting, deleting and printing) and sorting. For example, an error occurs when using double-byte Japanese or Chinese characters in the Lookup Codes in Analysis Codes.

If no data is found or you choose to search again using Clear Screen, the SSQSEL form is presented again so you can enter your revised search criteria. You can continue to enter a partial code in the main field before pressing F5 when the system immediately attempts to display the matching rows without presenting the selection criteria form. Wild cards such as % can be used in alphanumeric fields. For example, %b%v in a description field would find any record that had a b and a v within its description field.

Note: Setting the SSQSEL form up is a system wide setting and all users can use the new query parameter form when the query is invoked.
Note: Deleting the SSQSEL form will trigger the system to revert to the old query mechanism.

Data Dictionary Lookups

For certain forms such as Event Profiles, the query button displays a Data Dictionary Lookup form. These forms allow you to select the data you require.