[OPEN-ILS-GENERAL] Truncating fields in reports

[Mike Rylander]

On Thu, Oct 27, 2011 at 8:28 PM, John Morris <jmorris at beau.org> wrote:
> On Thu, 2011-10-27 at 09:03 -0400, Whalen, Liam wrote:
>> >
>> > I currently truncate long fields like title or author on
>> > reports so that it can fit in a nice tabular format.  Can't
>> > find a way to do that with the generator.
>>
>> The tabular form of output that Evergreen uses for its reports is an HTML table, so, as long as you don't have extremely long words, the table will break up long fields into multiple lines.
>
> I'm old school.  If I could find a way to get greenbar fanfold paper
> into a laser printer I'd be printing reports on it.  But I ran a test
> and the consensus is multiple lines is ok and everyone else liked the
> look so I'm outvoted.  Down to one remaining problem.  I have a three
> day fudge factor coded in so items wouldn't start popping out on the
> report until it is three days overdue.  Can't find a way to do the
> equivalent to "AND due_date < (NOW() + '3 days')"
>

You should be able to use the Age transform for this, and you'll want
to use the "Greater than" operator.  That is equivalent to "AND
AGE(NOW(),due_date) > '3 days'::INTERVAL"

-- 
Mike Rylander
 | Director of Research and Development
 | Equinox Software, Inc. / Your Library's Guide to Open Source
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  miker at esilibrary.com
 | web:  http://www.esilibrary.com