The Product Query Tool (PQT) allows mass entry of products by keywords, or manual selection of products for a Region, Exchange, and Product Group. The Global Query is also available for searching all exchanges. All results can easily be appended to the eModule.
Accessing the Product Query Tool
The Product Query Tool can be accessed from the eMODULE ribbon.
Or, the PQT can be accessed from within the eModule Control Panel, which can be accessed via the icon in Column E of the eModule.
PQT Zoom Option
Upon opening the Product Query Tool (PQT), the user will be prompted to enter the "PQT zoom percent". This is defined by the user to accommodate different video attributes.
Selecting Products within the Product Query Tool
Similar to the eModule, the Product Query Tool allows the user to drill down into the product details to define the data to be appended to the existing eModule. All applicable products display within the Products list.
- Select the Region
- Select the Exchange
- Select the Product Group
- Manually select the Products within the Product List, or use the Keywords section to select products by keyword or type. In the figure below, the keyword search includes "CORN", which was inserted in the free form text filed and added to the Keywords list, and also includes "FUTURE", which was selected from the drop-down of Product Types. By clicking SELECT PRODUCTS by keywords or type, all CORN FUTURES are highlighted, and can be appended to the eModule.
Product Query Tool Actions
Action can be taken on those selected products within the Products List, further defining the products to be selected, and ultimately appended to the eModule.
- APPEND SELECTED Products into eModule
Clicking this button will result in the selected products, and defined "Optional Attributes", appending into the current eModule.
- SELECT All
Clicking this button will select all of the products displayed in the Products List for Group and Exchange. If necessary, products can be removed by de-selecting them manually. When the list accurately represents the products to include, it can be appended to the eModule.
- CLEAR Selections
Clicking this button will clear all selections within the Products List for Group and Exchange. Products can then be selected manually as needed. When the list accurately represents the products to include, it can be appended to the eModule.
- LOAD Keywords from Selected Product
Clicking this button will load the keywords from all of the selected products to the Keywords List. Keywords can be added or deleted as needed (up to 12).
The new Keywords section allows the user to add and remove keywords to be used when searching for products to append to the eModule. Keywords can be manually added, or loaded from selected products, which are identified through an interrogation of the product name.
In addition to selecting by keyword, users are also able to select according to Product Type. The keywords and product type can then be combined for a more specific search.
By clicking the Keywords List button, a full list of system generated keywords will display to the right of the Keywords section. This list can be sorted alphabetically, or according to the frequency in which they appear within the product reference data.
The Keywords section, and Keywords list are detailed below.
- Clear Keywords
Clicking this button will clear all keywords from the selected keywords section.
- Delete Selected Keyword
Clicking this button will delete the selected keyword(s) from the section.
- Add Keyword
Clicking this button will add the keyword that has been typed into the freeform field.
- Select by Product Type
Selecting the Product Type from the dropdown will allow the user to further define the product.
- Sort KW Alpha
Clicking this button will sort the defined keywords in alphabetic order, and update the button name to Sort KW Freq.
- Sort KW Freq
Clicking this button will sort the defined keywords according to the frequency in which they appear in the Docs reference data, and update the button name to Sort KW Alpha.
- Add Keyw’s
Clicking this button will add the selected items to the Keywords List.
- Logical Connector
Keywords can be associated through the use of this tool. This form connector is relevant if more than one keyword is selected, such as “SOYBEAN” and “SWAP”. The selection of “OR” matches if ANY keyword appears in ANY product record, as seen below.
The selection of “AND” matches if ALL keywords appear in a SINGLE product record, as seen below.
- Optional Attributes
The additional fields of Execution Type, Rate Type, and Brokerage Amount can all be defined for the products being appended to the eModule. Similar to the eModule tool itself, both the Execution Type and Rate Type display as drop-down selections, and include the current reference data within Docs. The Brokerage Amount field can be used to define the rate for all of the selected products. These optional attributes will all appear when the products are appended to the eModule. Please note that these values can still be modified within the eModule on a product by product basis after being appended.