[OPEN-ILS-GENERAL] catalog link for particular Shelving Location

[Mike Rylander]

Sure thing.  They're in the table asset.copy_location.  I don't recall if
the id is visible in the copy location editor or not...


--
Mike Rylander
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  miker at esilibrary.com
 | web:  http://www.esilibrary.com


On Thu, Jan 22, 2015 at 1:14 PM, Holly Brennan <haderhold at ci.homer.ak.us>
wrote:

>  That’s awesome, Mike! Thanks!
>
>
>
> How do I find the number codes? Can you give me the database path?
>
>
>
> -Holly
>
>
>
> *From:* open-ils-general-bounces at list.georgialibraries.org [mailto:
> open-ils-general-bounces at list.georgialibraries.org] *On Behalf Of *Mike
> Rylander
> *Sent:* Thursday, January 22, 2015 8:06 AM
> *To:* Evergreen Discussion Group
> *Subject:* Re: [OPEN-ILS-GENERAL] catalog link for particular Shelving
> Location
>
>
>
> Holly,
>
>
>
> You can use the id of the shelving location with a "locations()" filter,
> like this:
>
>
>
>
> http://catalog.ci.homer.ak.us/eg/opac/results?query=locations(187)&qtype=keyword&locg=4
>
>
>
> That can be a comma-separated list, to include multiple locations
>
>
>
> HTH,
>
>
>
>
>    --
>
> Mike Rylander
>
>  | President
>
>  | Equinox Software, Inc. / The Open Source Experts
>
>  | phone:  1-877-OPEN-ILS (673-6457)
>
>  | email:  miker at esilibrary.com
>
>  | web:  http://www.esilibrary.com
>
>
>
>
>
> On Wed, Jan 21, 2015 at 9:16 PM, Holly Brennan <haderhold at ci.homer.ak.us>
> wrote:
>
> I want to provide a link to all graphic novels for kids, so patrons can
> click the link on our website and go directly to a “pre-searched” page of
> catalog results.
>
>
>
> In the past I have created this type of link with keyword searches and
> Copy Location Groups, but because the individual Shelving Locations aren’t
> listed in Advanced Search I’m a bit stumped.
>
>
>
> Our collection has these books cataloged with the Shelving Location of
> ‘Children’s Library – Graphic Novel’, so I don’t need to mine the MARC data
> or keywords for this search. I just need to figure out the formula for
> grabbing from a particular Shelving Location.
>
>
>
> I’m thinking there must be a clue in this link below, which is a search
> for everything in the Copy/Shelving Location *GROUP* containing all
> Children’s Shelving Locations (* in the Keyword box, ‘All Children’s’ group
> selected, everything else blank)…. This link below shows that “All
> Children’s” copy location group is coded as locg=4….. so what is the code
> for individual shelving locations? And how do I figure out what number this
> group has been assigned? In the staff client Copy Location Groups ‘All
> Children’s’ is listed as #2, so it’s not listed as #4 there….
>
>
>
>
> http://catalog.ci.homer.ak.us/eg/opac/results?bool=and&qtype=keyword&contains=contains&query=*&bool=and&qtype=title&contains=contains&query=&bool=and&qtype=author&contains=contains&query=&_adv=1&locg=4%3A2&pubdate=is&date1=&date2=&sort
> =
>
>
>
> Thank you!!
>
>
>
>
>
> Holly Brennan
>
> Library Technology Specialist
>
> Homer Public Library, Alaska
>
>
>
> hbrennan at cityofhomer-ak.gov
>
> 907-235-3180 (main)
>
> 907-435-3154 (direct)
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20150122/cf8f9df9/attachment-0001.htm>