[OPEN-ILS-GENERAL] Serials Report on Expected Issues not Received

[Lebbeous Fogle-Weekley]

Hi Tim,

You want to look at the serial.item table, which has a date_received 
field.  It's the items belonging to the issuance that get marked 
received, rather than the issuances themselves.

Hope this helps!

Lebbeous

On 11/16/2011 01:51 PM, Tim Spindler wrote:
> I have been trying to construct a report to get a list of expected issues
> (issances) for a given org for a range of publication dates.  I can see the
> datasources for the issuances but I don't see what you would use to
> identify whether the issue is received or not.  Looking at the database
> table issuances, the only indication I see is that the create date and edit
> date is the same.
>


-- 
Lebbeous Fogle-Weekley
  | Software Developer
  | Equinox Software, Inc. / Your Library's Guide to Open Source
  | phone:  1-877-OPEN-ILS (673-6457)
  | email:  lebbeous at esilibrary.com
  | web:  http://www.esilibrary.com