Make affiliation filter in datacite api case insenstive

[borsna]

What is the problem that your suggestion solves?

When filtering in the affiliation string it is now case sensitive. e.g:
https://api.datacite.org/dois?query=creators.affiliation.name:DataCite 1367 results
https://api.datacite.org/dois?query=creators.affiliation.name:Datacite 6 results
https://api.datacite.org/dois?query=creators.affiliation.name:datacite 2 results

This makes it hard to do all possible combinations when trying to get a list with a certain affiliation when ROR-id is not provided.

What solution might meet your needs?

It would be good to be able to do a case insensitive filter (with wildcard characters) to get results independent how the affiliation is written with Upper/Lower case.

Your name

Olof Olsson

Your organization

Swedish National Data Service

What alternatives have you tried or considered?

Doing a OR-search with common upper/lowercase combination for the affiliation we look for.

Is there anything else you would like to share?

No response

What group(s) would benefit from your suggestion?

• DataCite members registering DOIs and metadata and administering accounts
• Developers building integrations with DataCite services
• Harvesters who index DataCite DOIs and metadata
• Individuals or institutions analyzing DataCite DOIs and metadata
• DataCite staff
• Other

If other group(s), please describe.

No response

[codycooperross]

Hi @borsna ! Thank you for this suggestion. More flexible querying for affiliation names is on our radar—we'll keep you updated as we work on this! Are there any other fields where more flexible querying would be useful to you?

[borsna]

Hi!
I think publisher.name already is case insenstive but another fields i think case insenstitive filtering would be useful for is fundingReferences.funderName

[codycooperross]

Hi @borsna ! With your feedback in mind, we made changes to a few fields in the REST API so that they can be queried case insensitively and more flexibly. These include:

• creators.affiliation.name
• contributors.affiliation.name
• relatedItems.publisher
• fundingReferences.funderName
• types.resourceType
• subjects.subject

For example, the following all now return the same number of results:

• https://api.datacite.org/dois?query=creators.affiliation.name:DataCite
• https://api.datacite.org/dois?query=creators.affiliation.name:Datacite
• https://api.datacite.org/dois?query=creators.affiliation.name:datacite

And queries like the following will return more flexibly-matched results:

• https://api.datacite.org/dois?query=creators.affiliation.name:university\%20of\%20washington

The above query for university of washington, for example, matches creator affiliation names like University of Washington, University of Washington, Seattle, WA, USA, and University of Washington Cooperative Institute for Climate, Ocean and Ecosystem Studies (CICOES).

We hope this is helpful. Please let us know if you have any further feedback or suggestions.

[borsna]

Hi @codycooperross !
Thank you for resolving this so quickly!
This makes it a lot easier to query for free text affiliation strings where ROR-id is not yet available.

Thanks again for reporting back, great work!