Re: Counting records - items

Posted by Verus Open Source Support on
URL: http://ngl.70.s1.nabble.com/Counting-records-items-tp6811195p7572894.html

Count of titles that are only Books
select count(*) from cataloguerecord where bibiliographic_level_id=3 and material_type_id=1;

Count of Volumes that are only books
select count(*) from cataloguerecord a, cat_volume b where b.cataloguerecordid=a.cataloguerecordid and b.owner_library_id=a.owner_library_id and a.bibiliographic_level_id=3 and a.material_type_id=1;


Count of items that are only books
select count(*) from cataloguerecord a, cat_volume b, document c where b.cataloguerecordid=a.cataloguerecordid and b.owner_library_id=a.owner_library_id and c.volume_id=b.volume_id and a.bibiliographic_level_id=3 and a.material_type_id=1;

On 06/18/2012 12:35 PM, pedroparkero [via NewGenLib] wrote:

Good day! The sql query for counting items will also include the nonbook materials (journals, brochures, etc.) recorded into NGL, isn't it not? How do I make sure it only counts titles, volumes or items just for books? Thank you.

---

If you reply to this email, your message will be added to the discussion below:

http://forums.newgenlib.org/Counting-records-items-tp6811195p7572893.html

To start a new topic under NewGenLib, email [hidden email]
To unsubscribe from NewGenLib, click here.
NAML