Bug 5908 - Cataloguing itemtypes/biblios: books containing DVD cataloging
Summary: Cataloguing itemtypes/biblios: books containing DVD cataloging
Status: CLOSED INVALID
Alias: None
Product: Koha
Classification: Unclassified
Component: Cataloging (show other bugs)
Version: 3.4
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Galen Charlton
QA Contact: Bugs List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-03-20 22:37 UTC by Shelley
Modified: 2012-10-26 00:40 UTC (History)
2 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Shelley 2011-03-20 22:37:56 UTC
For cataloguing itemtypes/biblios: books containing DVD cataloguing

Creating a list of biblios which have itemtypes beginning with 'B' but which contain 'motion picture' or 'performance' or 'television programme' in their subject field.

Cannot be done in SQL as subject information is stored in MARC record
Comment 1 Nicole C. Engard 2011-03-22 20:42:19 UTC
This kind of seems like a support request more than a Koha bug. You should send this to the Koha mailing list so I'm closing this bug.  I can tell you that you can actually query the Marc record and tips for that are on the wiki: http://wiki.koha-community.org/wiki/SQL_Reports_Library