Faceted browse: how to show values of related items?

Omeka S Modules
1

Hi everyone :slight_smile:

I have 2 related Item types, of which I would like to display selected values from both in the faceted browse columns.

Example:

  1. ItemType1 = Physical Object (values: title, product type)
  2. ItemType2 = Measurement Event (values: material1, material2)

I can select and display both Item types on faceted browse, but it doesn’t seem to relate them to each other.

I want like “select * from ItemType1 which has ItemType2” - and then display values from ItemType1 /and/ its related values from ItemType2.

To get this column list in the end:

| title | product type | material 1 | material 2 |

Is that possible?
Many many thanks in advance :sunflower:

2

You can get the filtering part. Put a “has any value” search on the property that links to the Measurement Event into the category’s query, or add a Value facet with the “Has any value” query type so visitors can toggle it themselves.

The columns won’t work. A column shows values belonging to the item in that row, so you can show “title” and “product type”, and a column on the linking property gives you a link to the Measurement Event labeled with its title, but there’s no way to pull “material 1” and “material 2” into that row.

I’ve opened an issue for the column part. It’s on record now, though I can’t say if or when we’ll get to it.

1 Like
3

Thank you so much for your reply!
…and even more for considering making an issue so it might become a feature. :cake:

I understand that it’s tricky pulling values from one entity/table through, but I somehow was silently hoping that the RDF nature of Omeka S allowed this… ? :blush:

I’m experienced with classical SQL, and only very very little SPARQL: Would such a query be possible there?

4

Omeka does not natively use SPARQL, but its data model is RDF. That’s why the proposed feature will work.