Chris and I finally had some downtime today to catch up on a few things.

• Catch up with Peter Gassner and the Verticals On Demand Crew
• Finally record a flash demo for Client/Server single signon

When we recorded the flash demo of the single signon, we remembered that we had one customer who had created shortcuts to run queries in windows, which single signon made work really well for them. Of course, we had to include this in the demo.

Cool! How did you do it

Well, we actually leveraged a hook that I had been using up until release 8.0 in the windows client (you could actually pass parameters in the windows client to open up a panel with a specific item the same way you can in the web).

The actual command line used in the shortcut is as follows

E:\pt846\bin\client\winx86\psqed.exe PUBLIC.QUERY.GS_TEST_JRNL_DTL

As long as you follow the syntax of PUBLIC.QUERY and then the query name (or PRIVATE.QUERY if the query is private), this will work. Unfortunately, there isn't a way to tell it to run a query and pass in the parameters (but Chris tells me he's already working on it).

Labels: Drilling, Query