Searching on the Object Number Field

Put questions about your cataloguing projects to our panel of experts and the wider community.
Lisa Harris
Posts: 3
Joined: Mon Sep 10, 2012 10:27 pm

Searching on the Object Number Field

Postby Lisa Harris » Sat Nov 10, 2012 1:57 am

Hi, (apologies for originally posting this on the wrong bit of the forum!)

We have a large collection of objects relating to a hospital that start with the object number STMEA:1991-20 followed by the relevant sub numbers.

We need to find a way to bring up this selection only so that we can work on them before making them accessible online - as our first publicly accessible collection.

There should be about 150 records but we can't find a way to bring up just those that include this complete number in the object number field. We have tried the following:

1991-20 - this brings up over a 1000 records

1991 + 20 - this brings up 837 records

Each of the following say that the search returned no results:
object_number: 1991-20
object_number: "1991-20"
object_number: +1991-20

We have tried so many variations I've lost track.

Can anyone give me any guidance as this is something we need to do regularly?

Many thanks,


Posts: 193
Joined: Thu May 08, 2008 10:31 am
Location: Auckland

Re: Searching on the Object Number Field

Postby paul » Wed Nov 14, 2012 10:01 am

Hi Lisa,
There's a couple of catches here that are making it a bit more difficult. Firstly, the ":" character is one of a limited number of reserved characters in the text search software we use (SOLR / Apache Lucene). Secondly, the object numbers are indexed as a single word, so you need to use wildcards or ranges to pick up parts of numbers.

We can solve the clash with the colon by using quotes around the object number. This does a phrase search, which allows any punctuation, but the record text has to exactly match the search.

So, to search for a individual record all of the following are valid:

Note: no is a short alias for object_number so I'll just use this in the rest of the examples.

SOLR doesn't allow phrase searches with wildcards, so if you use wildcards, you can't include the portion of the number with the colon. eHive checks if the search is on object_number (the no and object_number prefixes) and do so extra work to cope with the wildcards.

So, the following example is valid:

Your original question about searching for a range of object numbers can be answered using this option:
(any object number with the text 1991-20. in the middle)


Lisa Harris
Posts: 3
Joined: Mon Sep 10, 2012 10:27 pm

Re: Searching on the Object Number Field

Postby Lisa Harris » Wed Nov 14, 2012 10:09 pm

Hi Paul,

Woohoo - it works! Thanks for your reply.


Return to “Cataloguing Questions”

Who is online

Users browsing this forum: No registered users and 1 guest