Adding New metadata field

Hi,

We have created a new metadata field "Expiration_Date" as "datetime" data type. But datetime is taking a default value. We don't want that to happen. Otherwise we will use string and we will enter the date in the string field that is not a problem. We made the new field as editable field. We want to add this new metadata field to the assets table as Expiration_date, because we have "photography" which we need expiration date. Right now when I have created a new metadata field the value is going into the "metadatacatalog" table. Can somebody through some light on it as how we can acheive this?

If you want to look at how we have done this, I can setup a live meeting.

Find more posts tagged with

Comments

msrinivas

Is this a script that you are writing or just through one of the clients?

I would highly recommend NOT changing the schema of the OOTB database. If you need to create custom stuff create a new DB and write it to that. When you do an upgrade in the future you will lose or have issues if you change the DB schema.

What version of MB?

lyman

From the description, I presume they mean they added a field via the clients which is perfectly acceptable.

I am not positive what the problem is exactly with defaults. If a field is added by the user, it does not exist for an asset unless specifically added. Therefore "not present" is, in that sense the default.

Also, one popular method of adding metadata to assets is by means of the metadata adder primitive using runtime parameters. This makes the inserting user enter a value when an asset is ingested. By making this runtime parameter required, no default will be displayed by the client and the user will have to come up with a value.

Please let me knoe if this would resolve your use case.

Cheers,

Lyman Hurd