List of values in a metadata text field

(Keith Bolland) #1

I'm trying to figure out how to display a list of all the unique values that have been entered in a metadata text field. I thought I could use a Search List asset to do this for me, but it seems to only operate on a word-by-word level, so if the values that have been used in assets are:

  • Red Seminar Series
  • Blue Seminar Series
  • Blue Lectures

What I get back from the search list is:

  • red
  • seminar
  • series
  • blue
  • lectures

Is there a way to get the search list to treat the whole field value as a single term? Or some other way to get this listing? I also tried setting up an asset listing and grouping by the value of this field, but it chokes and dies with the number of assets involved, whereas the Search List renders in under 2s.

#2

They will return the whole string, whatever you entered in meta fields  ..... If you entered "Red Seminar Series", it will return the full string i.e. Red Seminar Series.

 

We mostly access metadata (using meta keywords) in paint layouts .....

 

You can use something like %asset_metadata_description% (where description is the name of the meta field)

 

For more info, plz see https://manuals.matrix.squizsuite.net/keyword-replacements/chapters/metadata

 

Cheers...!

(Keith Bolland) #3

We mostly access metadata (using meta keywords) in paint layouts .....

 

You can use something like %asset_metadata_description% (where description is the name of the meta field)

 

Yes, this works for getting an individual asset's values, but if I have 2000 Single Calendar Events (for example) and I want a list of all the different things entered in a metadata field on those events, de-duplicated, %asset_metadata_% keywords aren't any use at all.

 

Like I mentioned, I tried using an Asset Listing instead, and it does work with some fiddling, but a Search List (note: not search page) renders in a couple of seconds; the asset listing takes 20+.