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 <jlw...@asbury.edu> 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- > boun...@list.georgialibraries.org] *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 <jlw...@asbury.edu> 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 > jlw...@asbury.edu > > > > > > > > *From:* Open-ils-general [mailto:open-ils-general- > boun...@list.georgialibraries.org] *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 <jlw...@asbury.edu> 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 > jlw...@asbury.edu > > > > > > > > -- > > -------------------------------------------------------------- > > Rogan R. Hamby, Data and Project Analyst > > Equinox - Open Your Library > > ro...@esilibrary.com > > 1-877-OPEN-ILS | www.esilibrary.com > > > > > > > > -- > > -------------------------------------------------------------- > > Rogan R. Hamby, Data and Project Analyst > > Equinox - Open Your Library > > ro...@esilibrary.com > > 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
