Metadata and MySQL

(Clementoke) #1

Hi there,

Is it possible to link a metadata field to a datasource? Say I had a list of organisations in a database and I wanted to add that information to the metadata on a page by using a specific field, is that doable?

I currently use a list in the metadata but adding another organisation (in alphabetical order) would affect existing pages using the schema. I'm trying to avoid that so any suggestions welcome.

C

(Nic Hubbard) #2

You could use a DB Datasource and then list the shadow assets using an Asset listing. Then in the metadata field use the globals_asset_contents_raw keyword.

(Clementoke) #3

Would that give me a select list in the metadata field to pick one of the items to display in the front end?

(Nic Hubbard) #4

Would that give me a select list in the metadata field to pick one of the items to display in the front end?

 

No, you would have to do something tricky like save the selected option to another metadata field.