Counting records - items

[nsid]

Hi all,

Is there any easy way to count the total number of:

1) the records
2) items

in the database?

Maybe an SQL query?

Thank you.

[Verus Open Source Support]

Get count of items
select count(*) from document;

Count of titles
select count(*) from cataloguerecord;

Count of volumes
select count(*) from cat_volume;

On 09/20/2011 12:54 PM, nsid [via NewGenLib] wrote:

Hi all,

Is there any easy way to count the total number of:

1) the records
2) items

in the database?

Maybe an SQL query?

Thank you.

---

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

http://newgenlib.2944635.n2.nabble.com/Counting-records-items-tp6811195p6811195.html

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

[pedroparkero]

Hi!
May I inquire if the difference between items & volumes that I have in mind is the same as yours? For example, if we have 2 copies of an encyclopedia 10-volume set, then:
Number of items: 20 (2x10)
Number of titles: 1 (title of encyclopedia)
Number of volumes: 10

Is this how it is counted? Thanks for the clarification...

[Verus Open Source Support]

Yes, that is right
On 09/20/2011 07:06 PM, pedroparkero [via NewGenLib] wrote:

Hi!
May I inquire if the difference between items & volumes that I have in mind is the same as yours? For example, if we have 2 copies of an encyclopedia 10-volume set, then:
Number of items: 20 (2x10)
Number of titles: 1 (title of encyclopedia)
Number of volumes: 10

Is this how it is counted? Thanks for the clarification...

---

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

http://newgenlib.2944635.n2.nabble.com/Counting-records-items-tp6811195p6812299.html

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

[pedroparkero]

How about a count per accession series?

[pedroparkero]

Also, can unaccessioned issues (virtual holdings) of serials and their titles be counted too?

[Verus Open Source Support]

Hi,

Currently the Accession series are only used to generate the next accession number. We would say there is a loose couple between the accession number and the series it belongs to. Most of your earlier queries are also related to the same. In the upcoming major update we will provide a relationship between the accession number and its series.

Regards
NewGenLib Open Source Team

On 11/03/2011 09:05 AM, pedroparkero [via NewGenLib] wrote:

Also, can unaccessioned issues (virtual holdings) of serials and their titles be counted too?

---

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

http://newgenlib.2944635.n2.nabble.com/Counting-records-items-tp6811195p6957815.html

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

[pedroparkero]

Good day!

What about virtual holdings (journal issues listed in the system but not accessioned). Can we be able to count them as well?


Also, in the subject of accessioning: Currently, the automatic accession number generator picks the lowest number not yet used in an accession series. For example, if '11329' is the last accessioned used, but for some reason I wanted to skip and use '12001' in my next accession number. After this, if I want to give another item an accession, the system will recommend '11330'. I hope you can also create an option that instead of filling the gaps, the accession generator will search for the highest number and just add 1 to it. (In this instance, give me '12002'.)

[pedroparkero]

Related to the query above, I notice there is an option "auto-number generation" in the Configure system module. What is it for? Is it for accessioning?

[Verus Open Source Support]

This is for Auto-number generation in Patron.
You can use F3 to auto generate patron id in Administration->Configure System->Patron(New)

On 11/09/2011 02:19 PM, pedroparkero [via NewGenLib] wrote:

Related to the query above, I notice there is an option "auto-number generation" in the Configure system module. What is it for? Is it for accessioning?

---

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

http://newgenlib.2944635.n2.nabble.com/Counting-records-items-tp6811195p6977255.html

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

[pedroparkero]

Good day! Can we now count titles/volumes per accession series? Or is the major update for it not ready yet?

[Verus Open Source Support]

The functionality for relating Accession series to the numbers is planned for 3.0.4
The requested functionality will be part of 3.0.4

On Tuesday 31 January 2012 07:09 AM, pedroparkero [via NewGenLib] wrote:

Good day! Can we now count titles/volumes per accession series? Or is the major update for it not ready yet?

---

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

http://newgenlib.2944635.n2.nabble.com/Counting-records-items-tp6811195p7238690.html

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

[pedroparkero]

Good day! Can we count items & titles now by accession series? How can this be done? Thanks in advance...

[Verus Open Source Support]

Hi,
Before 3.0.4 final update this facility will be included.
Regards
NewGenLib Open Source Support Team
On 05/11/2012 10:57 AM, pedroparkero [via NewGenLib] wrote:

Good day! Can we count items & titles now by accession series? How can this be done? Thanks in advance...

---

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

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

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

[pedroparkero]

Good day! I'd like to know how we can count items & volumes by sublocation please.

[Verus Open Source Support]

Hi,
There is no such report currently in NewGenLib. However, will the SQL
Queries(To get only the count) help you?

On 05/31/2012 10:42 AM, pedroparkero [via NewGenLib] wrote:

Good day! I'd like to know how we can count items & volumes by sublocation please.

---

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

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

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

[pedroparkero]

Yes, an SQL query will do fine.

[Verus Open Source Support]

Query 1:
To know the sub locations and their ids

select * from catalogue_sublocation;

Query 2:
To know number of titles under a sub location

select count(*) from library_holdings where sublocation_id=1

In above query replace 1 with a id of the sub location desired

Query 3:
Items under a sub locations

select count(*) from document a, cat_volume b, library_holdings c where a.volume_id=b.volume_id and b.cataloguerecordid=c.cataloguerecordid and b.owner_library_id=c.owner_library_id and a.library_id=c.holdings_library_id and c.sublocation_id=1



On 05/31/2012 03:38 PM, pedroparkero [via NewGenLib] wrote:

Yes, an SQL query will do fine.

---

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

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

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

[pedroparkero]

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.

[Verus Open Source Support]

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