RE: Retrieve Code Analysis metrics history from DB

Roddy,
  Looks like you may have found a bug.  I'll take a look and see what's going on.

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.