Where is history information stored?

[Hypermommy]

Hi all... I've been exploring the queries I'm able to run against the CI_INFOOBJECTS database lately. Now I'm wondering... the information that shows up when I (as a user) click on "history" under ePortfolio must be saved somewhere. I'm guessing it's probably another CI_(something) database? Anyone know what that one is? Thanks.

 

[MJRBIM]

In CE 8.5 the SQL database table is called APS_InfoObjects - it contains all the Object data for Enterprise (eg. Groups, Users, Folders, Report Object, and Report Instances).

The key fields are TypeID and ObjectName - they contain the class and name of the Object.

Specific Report Instance details (eg. Success, Fail, Parameters, etc) that appear in the "HISTORY" window I think are pulled from the Properties field which Crystal stores as an Image.

I'm not sure how to translate that image back to it's raw components. CE does it, as do some of the 3rd party APOS tools - so it's possible...I've just never had the time to analyze it properly.