Hi Jennifer, There are a couple of ways to go about this. You could do an IN LIST for the tag value to get the 001 and 035. If you only want the 035$a though that could be an issue (though you may not have many non subfield 'a's).
On Tue, Sep 13, 2016 at 5:22 PM, Walz, Jennifer <[email protected]> wrote: > All – > > > > One more follow up question. Or maybe two. J > > > > Is there a way to get the reports to spit out all items – including > those with a blank field? In other words, how to show all and not just > those that have data in that field. > > > > And second, is there a way to look for BOTH the 001 and the 035 and spit > out both in the results? > > > > Thanks! > > > > Jennifer > > > > *From:* Open-ils-general [mailto:open-ils-general- > [email protected]] *On Behalf Of *Chris Sharp > *Sent:* Tuesday, September 13, 2016 8:17 AM > *To:* Evergreen Discussion Group > *Subject:* Re: [OPEN-ILS-GENERAL] Getting OCLC numbers out of the Reports > > > > Jennifer, > > Just leave the Field Transform as "Raw Data" and the Operator as "Equals" > and it should work as you're expecting. For a MARC field with subfields, > you would want to add an additional filter of subfield as Rogan's example > suggests. > > Hope that helps! > > Chris > > > > On Mon, Sep 12, 2016 at 7:44 PM, Walz, Jennifer <[email protected]> wrote: > > Rogan, > > > > Do I have to do BOTH the tag and the subfield? And is 035 the only place > in the marc where the oclc number is? I was told it was in 001. And > this is how I have been doing it thus far, but getting weird results: > > > > > > (my results were at least to show me something from that field!) > Should I just do “raw data” and “equals” and “035” or “001”? When I did > that, it was giving me an error… > > > > Thanks! > > > > Jennifer > > > > *From:* Open-ils-general [mailto:open-ils-general- > [email protected]] *On Behalf Of *Rogan Hamby > *Sent:* Monday, September 12, 2016 7:11 PM > > > *To:* Evergreen Discussion Group > *Subject:* Re: [OPEN-ILS-GENERAL] Getting OCLC numbers out of the Reports > > > > Jennifer, > > > > There isn't much more to it. Use the flattened attributes as a filter and > filter by tag = '035' and subfield = 'a' in addition to the other filters > you use. Display the normalized value. That's it. Add that onto your > existing report for the others values to get the 035. One downside is that > if a record doesn't have a 035 it won't display though. > > > > On Mon, Sep 12, 2016 at 6:41 PM, Walz, Jennifer <[email protected]> wrote: > > Rogan, > > > > Thanks for the reply. I already figured that I should probably be > looking at the flattened MARC fields section, but how do I use those to > extract the OCLC number from the MARC field? Can I select a particular > MARC field to appear only in the output? How do I tell the system to show > me just that one field and not all of them? > > > > Specifics please. J > > > > Thanks! > > > > Jennifer > > -------------------------------------------------- > Jennifer Walz, MLS - Head of ILS confusion > Kinlaw Library - Asbury University > 1 Macklem Drive, Wilmore, KY 40390 > 859-858-3511 ext. 2269 > [email protected] > > > > > > > > *From:* Open-ils-general [mailto:open-ils-general- > [email protected]] *On Behalf Of *Rogan Hamby > *Sent:* Monday, September 12, 2016 6:34 PM > *To:* Evergreen Discussion Group > *Subject:* Re: [OPEN-ILS-GENERAL] Getting OCLC numbers out of the Reports > > > > From the Bibliographic Record data source if you go to Flattened MARC > Fields you can filter by Subfield / Tag etc... to get the 035 if you want. > The rest of what you mentioned (title, author, pub date) I would grab from > the Simple Record Extracts. > > > > > > > > On Mon, Sep 12, 2016 at 3:35 PM, Walz, Jennifer <[email protected]> wrote: > > All – > > > > I would like to run a report to get some basic bibliographic info (title, > author, pub date) PLUS the oclc number. Which source is best? And then > how to I get the OCLC number to show up in the output? I cannot seem to > find the right fields and such to get to that data. How do I get the > OCLC number to display in the output for each title? Can anyone point > me in the right direction? > > > > We would like to filter on shelving location and possibly include the > call number and barcode. > > > Thanks! > > > > Jennifer > > -------------------------------------------------- > Jennifer Walz, MLS - Head of Research & Distance Services > Kinlaw Library - *Asbury University* > One Macklem Drive, Wilmore, KY 40390 > 859-858-3511 ext. 2269 > [email protected] > > > > > > > > -- > > -------------------------------------------------------------- > > Rogan R. Hamby, Data and Project Analyst > > Equinox - Open Your Library > > [email protected] > > 1-877-OPEN-ILS | www.esilibrary.com > > > > > > > > -- > > -------------------------------------------------------------- > > Rogan R. Hamby, Data and Project Analyst > > Equinox - Open Your Library > > [email protected] > > 1-877-OPEN-ILS | www.esilibrary.com > > > > > > > -- > > Chris Sharp > > PINES System Administrator > > Georgia Public Library Service > > 1800 Century Place, Suite 150 > > Atlanta, Georgia 30345 > (404) 235-7147 > -- -------------------------------------------------------------- Rogan R. Hamby, Data and Project Analyst Equinox - Open Your Library [email protected] 1-877-OPEN-ILS | www.esilibrary.com
