RE: Retrieve Code Analysis metrics history from DB

Did you first run the object/file with Save to DB selected?  History only becomes available after it's been run.

In 11.6, there will be a much more comprehensive way to get the history.  The current method is a bit clunky but if you just open the file/object, no history will be available  (even if there is history in the DB).  After you run it with DB inserts, the history will show up.

Greg

From: [email protected] [mailto:[email protected]] On Behalf Of Brian R Trull
Sent: Friday, June 08, 2012 01:38 PM
To: [email protected]
Subject: [toad] Retrieve Code Analysis metrics history from DB





I've been playing with the feature to save Code Analysis results to the DB. I chose the option to have the related tables created in the local user, as opposed to the public Toad user. I ran a couple of analyses to test it. I see their entries in the tables, and I can run reports, but when I click the "Retrieve Code Analysis metrics history from DB" icon (little eyeglasses over a disk drive), I get "No history available."

I activated the SQL Tracker to see what is going on and was able to see why it didn't work. Two queries are generated, one each for the package and package body of whatever package I have selected. The problem is that it generates this clause, "AND cx."SCHEMA" = 'N/A'", instead of the actual user name, which is what was saved in the schema column.