In our Omeka S most objects were submitted without registration. For this we used the Collection Module. Now I need a list with all email addresses and the IDs of the objects for whose submission they are responsible. There are 5000 objects and some submitters have submitted several objects. I have not found a way to filter for this in the backend. Also via the API I don’t get this information. Do I need to go directly to the database?
Okay, we use the mysql-backend. For us works this query (it’s with language code):
SELECT text, item_id, value FROM XXX.collecting_input INNER JOIN XXX.collecting_item ON collecting_input.collecting_item_id=collecting_item.id Inner JOIN XXX.value ON value.resource_id=collecting_input.collecting_item_id WHERE text REGEXP ‘@’ AND value = ‘de’