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 <[email protected]> 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 <[email protected]> > Subject: Re: [OPEN-ILS-DEV] Want to know the variable name of patron's > phone number > To: Evergreen Development Discussion List > <[email protected]> > Message-ID: > <CALRLYEm4RFJigMgfcowywNBeJhU_XS9JtQiDZfzwBCThX=w...@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 <[email protected]> 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
