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: [email protected] | web: http://www.esilibrary.com On Thu, Jan 22, 2015 at 1:14 PM, Holly Brennan <[email protected]> wrote: > That’s awesome, Mike! Thanks! > > > > How do I find the number codes? Can you give me the database path? > > > > -Holly > > > > *From:* [email protected] [mailto: > [email protected]] *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: [email protected] > > | web: http://www.esilibrary.com > > > > > > On Wed, Jan 21, 2015 at 9:16 PM, Holly Brennan <[email protected]> > 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 > > > > [email protected] > > 907-235-3180 (main) > > 907-435-3154 (direct) > > > > >
