Skip to content
logo Knowledgebase

Error: "The WFquery name query does not exist" / Can I add a SQL query to a Landing page?

Created on  | Last modified on 

Cause

This solution is for v7 and higher only.

  • In the Menu item, the Request name is case-sensitive and must match the Query tool (aka Requester in v6) or Graphical query tool's code exactly.
  • The SQL Query tool (aka SQL Requester) does not work in Menu items. 
    • This is not a defect, but is due to the change in architecture between v6 and v7+.  Review the workaround in the resolution section below.

Resolution

CAUTION: Sage support can't assist with third-party products, hardware, report customizations, or state and federal tax questions. Refer to our Scope of Support for more info. Contact your Sage business partner, network administrator, or accountant for assistance.

Solution for Query tool or Graphical query tool:

  1. Go to Administration, Authoring, Menu Items.
  2. Find the menu item that you are attempting to add.
  3. Click on the Actions icon and select Detail.
  4. Click Edit.
  5. Change the Request name to the proper name using the proper case.
  6. Click Save.
  7. Test your Landing page again.

 

Solution for the SQL query tool (GESALQ):

Summary: Copy/paste the SQL code from the SQL query tool to a new View. Create a Query tool based off this SQL view. Add the Query tool to a Menu item. Add the Menu Item (as a Gadget) to a Landing page (or Dashboard).

  1. Launch Development, Data and parameters, Views (GESAVW).
    1. Create
    2. Required:
      • Code
      • Abbreviation
      • In the SQL server box, paste the SQL query statement
    3. Add fields on the Fields tab
    4. Define key (index) on the Keys tab if it is an indexed view
    5. Save
  2. Launch Setup, Usage, Printouts, Query tool (GESALH).
    1. Create
    2. Type:
      • Code (View code)
      • Description
      • Short description
    3. Fields tab
      • Add desired fields
    4. Advanced tab
      • Define Number of lines and Maximum
    5. Save
  3. Launch Administration, Authoring, Pages, Menu Items.
    1. Create menu Item
    2. Type:
      • Code
      • Title
      • Description
    3. Select
      • Link type (Choose Query)
      • Application
      • Endpoint (optional)
    4. Type:
      • Query (must match name of Query Tool query's code exactly, including capitalization)
    5. Save
  4. Add the new menu item to the desired Landing page (see attached KB 40908) or dashboard.

Note: In the Views (Dictionary of views) screen, in the Fields tab, you may not use duplicate fields with the same name. For example, if both fields from two different tables are called QTYUOM, you cannot enter this same field name into two different rows. The error received will be something such as "Code already exists on line [X]". If you are seeing this error, see KB article 80270 in the link below.