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

[Creighton Barrett]

Hello,

I've been looking at the docs for advanced search and ElasticSearch fields: https://www.accesstomemory.org/en/docs/2.5/user-manual/access-content/advanced-search/#expert-searching-and-indexed-elasticsearch-fields

And playing around with searches that target linked entities. The docs provide a great list: 

creators.i18n.%LANG%.authorizedFormOfName
creators.otherNames.i18n.%LANG%.name
creators.parallelNames.i18n.%LANG%.name
creators.standardizedNames.i18n.%LANG%.name
genres.i18n.%LANG%.name
names.i18n.%LANG%.authorizedFormOfName
names.otherNames.i18n.%LANG%.name
names.parallelNames.i18n.%LANG%.name
names.standardizedNames.i18n.%LANG%.name
places.i18n.%LANG%.name
repository.i18n.%LANG%.authorizedFormOfName
subjects.i18n.%LANG%.name

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:

!_exists_:creators.corporateBody.i18n.en.name

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:

_exists_:creators.corporateBody.i18n.en.name

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?

Thanks,

Creighton

[Dan Gillean]

Hi Creighton, 

It's worth looking over the full list of indexed fields for authority records, here in the docs: 

• https://www.accesstomemory.org/docs/latest/user-manual/access-content/search-atom/#es-fields-actor  
  

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. 

Cheers, 

Dan Gillean, MAS, MLIS
AtoM Program Manager
Artefactual Systems, Inc.
604-527-2056

@accesstomemory

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]

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!

Creighton

To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/CAC1FhZ%2BHozF_%3DVHZ94bpeMeQu5SKb44xr5CU_ZHPXXhLoKxd-g%40mail.gmail.com.