If you attended the 2006 Discovery conference. I spoke in a short but sweet workshop on the very last day on the very last timeslot about how to display various IQA queries on the dashboard.

Well that was only a step in my goal, which is to provide my users a way to quickly access their favorite IQA queries at any time during their iMIS workload.

I have developed a pretty neat way to include the IQA queries on every module's sidemenu without having to update each client's machine after every new IQA query is created.

Screenshot below

Basic workflow

I have two files stored in the ../system framwork directory

• MyIQA-Submenu.html
• Department-Submenu.html

For each sidemenu I want my IQA menu options to appear
I just add the raw html syntax not to forget to include the javascript that ASI uses to interact the popup window.

Inside each Submenu.html file contains an object tag. For those HTML coders out there: Since ASI uses windows.createpopup for their menus, a popup window does not render all html tags including the useful iframe.

the object tag just calls an .ASP page that pulls the names of the queries from the iMIS DB and displays the list.

How does it know the queries to pull

In our shop, we have organized our IQA into various folders. every iMIS users has their own folder Report view/Personal/userid and every department has their own folder Report view/Department/departmentname. I have create a SQL view that includes all the iMIS userids. their matching iMIS ID and their department.

The .ASP page knows what user is logged in based on the IQA browser cookie that is created when the user logs into iMIS. the browser cookie stores the iMIS ID and from my sql view I can pull the UserID and Department.

Now that I have the UserID and Department names, It just have to perform a search on the IQA tables and look for matching folder names. The .asp page then just displays the names of all the queries in that folder.

The code

do you all want me to post some of the code,sql vies...etc? If so I don't mind but I am not sure where on the website they go As attachments to this blog or is there a document lib of some sort that I should upload the code to and reference it from here? this is my first blog ever and I am not sure the standard around here yet