ElasticSearch query for archival descriptions linked to authority records with an Identifier for Corporate Bodies

Skip to first unread message

Creighton Barrett

May 21, 2020, 12:27:31 PM5/21/20
to ica-ato...@googlegroups.com

And playing around with searches that target linked entities. The docs provide a great list: 
I am wondering if there is a search that can target the "Identifiers for corporate bodies" field in the Identity Area (ISAAR 5.1.6). I've tried out a few things and noticed that this query:

Returns the total number of archival descriptions in our data entry site. Which might be accurate because I don't think we have any authority records with these identifiers. But this query:

Returns zero results, even after I added a test value to an authority record. The job scheduler says the update is complete, so if the ES query syntax is correct, I'd expect a result for the second query.

I'm not sure if this linked field is just not indexed and there is no ES query to do what I want, or if indexing is ongoing after the job is complete. Or maybe this field is indexed and I just have the wrong query?


Dan Gillean

May 21, 2020, 12:39:51 PM5/21/20
to ICA-AtoM Users
Hi Creighton, 

It's worth looking over the full list of indexed fields for authority records, here in the docs: 
You'll note that, within the authority records index, the Identifiers for Corporate bodies field is indexed as: corporateBodyIdentifiers. This is not being included as a foreign type on the archival descriptions at the moment, so attempting a global search like: 
  • _exists_:corporateBodyIdentifiers
Will likely return 0 results. However, the same query run in the dedicated authority record search box should return records that have a corporate identifier

Because it's not indexed as a foreign type on descriptions, I'm not sure I can provide you with an ES query that will return, for example, all descriptions that are linked to an authority that has a corporate identifier. It may be possible to craft something like that with SQL - that would take a bit more investigation. 

However, the fields you are trying to search on, as far as I can tell, don't actually exist in the index - which is why you are getting either all results or no results. 


Dan Gillean, MAS, MLIS
AtoM Program Manager
Artefactual Systems, Inc.
he / him

You received this message because you are subscribed to the Google Groups "AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/CAHueW_UN-%2Bc3nTHXAfDX_HHpvD4iRnz6jf0VFW9m7hQX6ZBh2A%40mail.gmail.com.

Creighton Barrett

May 21, 2020, 1:25:33 PM5/21/20
to ica-ato...@googlegroups.com
Ahh, perfect, thanks Dan. I grabbed that list from the docs on ES queries and archival descriptions, hadn't made my way to the authority record page yet. Sorry about that oversight!

Even knowing that we can search for the presence of this identifier in the authority record search box is helpful. Thanks!


Reply all
Reply to author
0 new messages