<![CDATA[Hexagon Safety & Infrastructure - Post to topic Jail Report]]> http://support.hexagonsafetyinfrastructure.com/infocenter/index?page=home Post to topic Jail Report en Copyright © 2002, 2012, Oracle and/or its affiliates. All rights reserved. Oracle Knowledge Information Manager http://blogs.law.harvard.edu/tech/rss <![CDATA[Jail Report]]> I want to be able to look up all the active inmates for a certain date last year ... anyone have any ideas?

]]> 2014-04-29 13:07:28 Etc/GMT <![CDATA[HELPFUL: RE: Jail Report]]> The only way i've found of doing this, and mind you i've only done it to a limited degree, is to use the Jail log to see who was booked in prior to that and was not currently listed as released.  Depending on how your people use the jail log and log bookings, releases, and rebookings this can get tricky.

I take that back, you can also utilize the jcellhist table to see who was in a cell at that time, though that is also tricky.  I've had a request in to Intergraph for years to have a report to show on a certain date where everyone was in the jail.

]]> 2014-04-29 13:11:15 Etc/GMT