Create Menu Item/Link to a specific SQL Query Tool Report

SUGGESTED

I created a sql query tool report from (All - Setup - Usage - Reports - Sql Query Tool). Is there a way to link this specific report as a menu item?

I've tried creating a new menu item and setting it as a query, but I'm getting an error stating that "The WFPXXXXXX (X being the sql query code) query does not exist. I'd rather have the user click on a link instead of traversing through All - Setup - Usage - Reports - Sql Query Tool and then typing in the code for the report. Not sure why it's referencing 'WFP'.

Thank You

Andrew

Parents
  • 0
    SUGGESTED

    Hello,

    I believe you need to create the function in order for it to work as a menu item. The menu item code should just be the query code, then create a function

    Then add it to your menu submodules. I've added mine to Reports -> Reports

    And then it works.

    Additionally, there are some other options.

    You can get to this query easily by clicking report -> report -> view queries.

    Additionally you can create a button for it right on the home page by adding a new button to a process map.

    In my custom process map for systems, I created a button, and set the link as "Query" with the query name as the SQL query name.

    After saving and validating, it opens the query when clicked.

  • 0 in reply to Zoey Mattison

    Did you find an answer to this  ? I just encountered a similar issue trying to visualise a custom query as a "gadget" on a dashboard. Many of the tutorials don't use a SQL query but rather the 'query tool' (sans SQL).

    I tried to follow a few things   mentioned but didn't get much further!

Reply Children