Re: [OPEN-ILS-GENERAL] catalog link for particular Shelving Location
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... snip Thanks! I’m not seeing anything useful for creating links in the Copy Location Editor in the staff client. Holly, you can run a quick report to get the location id's if you don't have direct database access. Look under All Available Sources for Copy/Shelving Location. You'll want to display Location ID and Name, and probably Owning Org Unit - Short (Policy) Name -- Jason Etheridge | Community and Migration Manager | Equinox Software, Inc. / The Open Source Experts | phone: 1-877-OPEN-ILS (673-6457) | email: ja...@esilibrary.com | web: http://www.esilibrary.com
Re: [OPEN-ILS-GENERAL] catalog link for particular Shelving Location
Thanks, Jason. I have view access to the database through Notepad++ and editing access to some less-dangerous areas. :) This is a great suggestion for all users though. And would probably print nicely for reference. Thanks! -Holly -Original Message- From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Jason Etheridge Sent: Thursday, January 22, 2015 9:51 AM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] catalog link for particular Shelving Location 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... snip Thanks! I’m not seeing anything useful for creating links in the Copy Location Editor in the staff client. Holly, you can run a quick report to get the location id's if you don't have direct database access. Look under All Available Sources for Copy/Shelving Location. You'll want to display Location ID and Name, and probably Owning Org Unit - Short (Policy) Name -- Jason Etheridge | Community and Migration Manager | Equinox Software, Inc. / The Open Source Experts | phone: 1-877-OPEN-ILS (673-6457) | email: ja...@esilibrary.com | web: http://www.esilibrary.com
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=keywordlocg=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: mi...@esilibrary.com | web: http://www.esilibrary.com On Wed, Jan 21, 2015 at 9:16 PM, Holly Brennan haderh...@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=andqtype=keywordcontains=containsquery=*bool=andqtype=titlecontains=containsquery=bool=andqtype=authorcontains=containsquery=_adv=1locg=4%3A2pubdate=isdate1=date2=sort = Thank you!! Holly Brennan Library Technology Specialist Homer Public Library, Alaska hbren...@cityofhomer-ak.gov 907-235-3180 (main) 907-435-3154 (direct)
Re: [OPEN-ILS-GENERAL] catalog link for particular Shelving Location
That’s awesome, Mike! Thanks! How do I find the number codes? Can you give me the database path? -Holly From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@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=keywordlocg=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: mi...@esilibrary.commailto:mi...@esilibrary.com | web: http://www.esilibrary.com On Wed, Jan 21, 2015 at 9:16 PM, Holly Brennan haderh...@ci.homer.ak.usmailto:haderh...@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=andqtype=keywordcontains=containsquery=*bool=andqtype=titlecontains=containsquery=bool=andqtype=authorcontains=containsquery=_adv=1locg=4%3A2pubdate=isdate1=date2=sort= Thank you!! Holly Brennan Library Technology Specialist Homer Public Library, Alaska hbren...@cityofhomer-ak.govmailto:hbren...@cityofhomer-ak.gov 907-235-3180tel:907-235-3180 (main) 907-435-3154tel:907-435-3154 (direct)
Re: [OPEN-ILS-GENERAL] catalog link for particular Shelving Location
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: mi...@esilibrary.com | web: http://www.esilibrary.com On Thu, Jan 22, 2015 at 1:14 PM, Holly Brennan haderh...@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-boun...@list.georgialibraries.org [mailto: open-ils-general-boun...@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=keywordlocg=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: mi...@esilibrary.com | web: http://www.esilibrary.com On Wed, Jan 21, 2015 at 9:16 PM, Holly Brennan haderh...@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=andqtype=keywordcontains=containsquery=*bool=andqtype=titlecontains=containsquery=bool=andqtype=authorcontains=containsquery=_adv=1locg=4%3A2pubdate=isdate1=date2=sort = Thank you!! Holly Brennan Library Technology Specialist Homer Public Library, Alaska hbren...@cityofhomer-ak.gov 907-235-3180 (main) 907-435-3154 (direct)
Re: [OPEN-ILS-GENERAL] catalog link for particular Shelving Location
Thanks! I’m not seeing anything useful for creating links in the Copy Location Editor in the staff client. Thanks again. I’m going to make links for everything! -Holly From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Mike Rylander Sent: Thursday, January 22, 2015 9:25 AM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] catalog link for particular Shelving Location 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: mi...@esilibrary.commailto:mi...@esilibrary.com | web: http://www.esilibrary.com On Thu, Jan 22, 2015 at 1:14 PM, Holly Brennan haderh...@ci.homer.ak.usmailto:haderh...@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-boun...@list.georgialibraries.orgmailto:open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.orgmailto:open-ils-general-boun...@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=keywordlocg=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: mi...@esilibrary.commailto:mi...@esilibrary.com | web: http://www.esilibrary.com On Wed, Jan 21, 2015 at 9:16 PM, Holly Brennan haderh...@ci.homer.ak.usmailto:haderh...@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=andqtype=keywordcontains=containsquery=*bool=andqtype=titlecontains=containsquery=bool=andqtype=authorcontains=containsquery=_adv=1locg=4%3A2pubdate=isdate1=date2=sort= Thank you!! Holly Brennan Library Technology Specialist Homer Public Library, Alaska hbren...@cityofhomer-ak.govmailto:hbren...@cityofhomer-ak.gov 907-235-3180tel:907-235-3180 (main) 907-435-3154tel:907-435-3154 (direct)
[OPEN-ILS-GENERAL] catalog link for particular Shelving Location
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=andqtype=keywordcontains=containsquery=*bool=andqtype=titlecontains=containsquery=bool=andqtype=authorcontains=containsquery=_adv=1locg=4%3A2pubdate=isdate1=date2=sort= Thank you!! Holly Brennan Library Technology Specialist Homer Public Library, Alaska hbren...@cityofhomer-ak.gov 907-235-3180 (main) 907-435-3154 (direct)