Creating User-Defined Queues

Based on your business needs, you can customize a queue to display the information you use most. The User-Defined Queue Maintenance tool helps you define how you want to display a queue and what data you want to retrieve from Eclipse.

To edit an existing queue, use the Queue ID field to enter the queue name you want to edit and skip to step 4 editing the remaining fields and columns, as needed.

Note: Standard queue functions work for your user-defined queues, including sorting, color coding, graphing, and views.

To create a user-defined queue:

1. From the Tools > User Defined Queues menu, select User Defined Queue Maintenance to display the User Defined Queue Maintenance window.

2. Click New Queue.

3. At the Enter New Queue ID prompt, enter the name of the queue you want to create and click OK.

The system converts the name to a program name for recall later for attaching to a menu or other user-defined function.

4. In the Queue Title field, enter the title you want to display in the Title Bar of the queue window. For example

   

5. In the Universe File field, enter the program file from which you want to retrieve data, such as PRODUCT or BUY_LINE.

Note: If you are unsure which file to use, review the commonly used files in Files Commonly Used In Reports to see what information is stored in different Eclipse files.

6. Use each of the following panes to define how you want the queue to behave:

• Column Display

• Header Fields

  Column	Description
  Field Label	Enter the name you want to use to label the field, such as Product ID. This label displays as the field in the queue.
  File	The system populates this field with the Universe File you enter. You can change this if you need to retrieve information from another Eclipse file. For information about the common files and what they contain, see Files Commonly Used In Reports . The file structure is the same for user-defined queues.
  Dictionary ID	Select the dictionary line the information for the column you want to display. An icon displays if more than one value is available for the option. Set these values, sub-values, and sub-sub-values in the Value Level field.
  Conversion	Select how you want the information to display in your queue. This determines how it will display. For example, if you select Product Desc you must select Product Description in this field so that the product description displays instead of the product ID.
  Validation	Select the information you want the system to use for the conversion. For example, if you select Buy Line for a column, then in this field you must select Buy Line so that the system knows what kind of entry is valid. If you do not select the corresponding entry, the system does not update records or may update records with possibly invalid entries.

   

  Like File Import Maintenance, the Field Validation and Field Conversion fields work together. The value or field type you have in the Field Validation field, determines what you need to enter in the Field Conversion field. Similar to a MS Excel cell format, if you select in the Field Validation field for the value to be Numeric, then you use the Field Conversion field to tell the system how you want that number to use the decimals. For example, to move the decimal to the right two places, you enter MR2. Press F10 to display a list of valid options.

  For more options, see User-Defined Queue Header and Select Options.

• Select Options

  Column	Description
  Number	The select number for the queue results. If you leave it blank, the system assumes it is all one select statement.
  Count*	Keeps a line count for the selects. A running total displays at the bottom, but keep the count here and to help reference.
  And/Or	When combining Select statements, use And or Or to tell the system how to treat the selection above the one you are entering in relation to the new select. For example, you may select the product file to return products that begin with BR. You want to add another select to return products with KOH. Use And in this field to connect the first and second select statements. Note:If you are familiar with TCL, you can use a GET-LIST as a select statement for lists you have saved.
  File	The system populates this field with the Universe File you enter. You can change this if you need to retrieve information from another Eclipse file. For information about the common files and what they contain, see Files Commonly Used In Reports . The file structure is the same for user-defined queues.
  Dictionary ID	Select the dictionary line the information for the column you want to display. An icon displays if more than one value is available for the option. Set these values, sub-values, and sub-sub-values in the Value Level field. If a displays, then more than one value, sub-value, or sub-sub-values are available to define.
  Filter Operations	Enter a filter to further define your selection, such as Greater Than or Equal To.
  Filter Type	Item or Eclipse Dictionary you want to select on. Item - This is a free-form filter. Dictionary - Enter the dictionary item exactly. Using this option activates the Formula column.
  Filter Value / Dictionary	Define which dictionary or value you want to select from the file you are working with.
  Formula	Add any formula operation you want to include in the selection. For example, if your Filter Value is set to Unit Weight, you can add *3 to multiply that unit weight by three. Important: The Filter Type column must be set to Dictionary to activate the Formula column. For more information about using pricing formulas in tables, see Pricing Basis and Formula Guidelines in Price Management.
  Select button	Press Select to populate the Count field to see if the number of results are what you expect. The display indicates how many records retrieve based on your selections. Select rows, or statements, work off each other like filters. You can continue to add select rows until you get the results you want to see.

  * View Only

• User Options to restrict access, as needed.

7. Click Run Queue to preview the queue.

8. Add the queue to a widget, if needed.

9. Save your queue and exit the window.