[OPEN-ILS-DEV] Want to know the variable name of patron's phone number

[Wolf Halton]

Hi Darshan,
--Please watch the subject line.  Your response had a subject line of
"...Digest etc etc" and that breaks the threading of the conversation. --

That is the list of databases, and the table is part of the evergreen
database.  If you have a linux desktop to look at gui stuff, you can look
at the structure using pgadmin III (as long as your database is listening
on an external port).  I cannot tell you exactly how to approach using the
field, but I can guarantee it will be there.  (Your money back if not
delighted).

Wolf


On Wed, Jan 4, 2012 at 7:40 AM, darshan <dkhot at dreamsoftech.com> wrote:

> Hi,
>
> I checked in database but I couldn't find table that you mention. In fact
> there was no single table in database. Please see attached screenshot and
> guide me if I am referring wrong database.
>
> Thanks
> Darshan
>
> Message: 2
> Date: Tue, 3 Jan 2012 08:00:34 -0500
> From: Wolf Halton <wolf.halton at gmail.com>
> Subject: Re: [OPEN-ILS-DEV] Want to know the variable name of patron's
>        phone   number
> To: Evergreen Development Discussion List
>        <open-ils-dev at list.georgialibraries.org>
> Message-ID:
>        <CALRLYEm4RFJigMgfcowywNBeJhU_XS9JtQiDZfzwBCThX=WboA at mail.gmail.com
> >
> Content-Type: text/plain; charset="utf-8"
>
> I am not a dev on this project, but I could find you this much.  That
> information is in the table called "usr" there are fields for day_phone,
> evening_phone and other_phone.  I used pgadmin III to look at the table
> details.  This is on evergreen version 2.1.
>
> On Tue, Jan 3, 2012 at 6:48 AM, darshan <dkhot at dreamsoftech.com> wrote:
>
> > Hi,****
> >
> > ** **
> >
> > In email template we use some variables ( like ${PATRON_NAME} and
> > ${PATRON_ADDRESS}) to get patron specific data. We want to use patrons
> > phone number in email message but we could not identify the variable
> > to get this value. Please help.****
> >
> > ** **
> >
> > Thanks****
> >
> > Darshan Khot****
> >
>
>
>
> --
> This Apt Has Super Cow Powers - http://sourcefreedom.com Advancing
> Libraries
> Together - http://LYRASIS.org
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> <
> http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/2012
> 0103/1dba7e0f/attachment-0001.htm>
>
> End of Open-ils-dev Digest, Vol 70, Issue 1
> *******************************************
>



-- 
This Apt Has Super Cow Powers - http://sourcefreedom.com
Advancing Libraries Together - http://LYRASIS.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20120108/c783da15/attachment.htm>