Custom metadata per database

Just adding my support for improved custom metadata.

My tuppence-worth:

  • allow metadata to be defined at the global, database, or defined group levels

  • my use-case would prefer a defined group that could be used everywhere. I already utilise metadata for referencing sources, but I also have a separate database to store receipts of large purchases. One custom metadata field I defined was Warranty Expiry along with the Store Name and Purchase price. Ideally I’d like to have a custom metadata group that just hold these three items, rather than cluttering up my other metadata fields.

  • also, I’m unable to see any metadata within DTTG - myst be there somewhere! Any clues, anyone?

1 Like

While I see where the requests for local metadata are coming from I am not sure this is the right way to go.

What the requests seem to imply is that all databases are strictly separated from each other. But what if they are not or won’t be anymore in the future? What happens if an item from database A is moved to database B. And database A has custom metadata B does not have. Will the moving strip the A-only metadata from the item or does the local custom metadata of database B get a silent update? Neither might be intended.

Having DEVONthink ask for what to do every time does not seem very practical either. Just imagine a bigger number of moved items and lots of custom metadata exclusively in database A. And maybe the user only wants some of them to get stripped from the items.

Both databases might even have custom metadata with the same names but different formats. What then?

From my point of view a better approach would be to keep all metadata global, like tags, but to allow to customize their visibility. And not only of custom but all metadata.

What I am suggesting is no less than full modularity of DT’s right pane(s). (And by the way, why stop at the right pane?) ((But please, Christian, if ever, this could only be part of a major for-pay upgrade and not some point-point-point update!))

The visibility of the modules should be customizable per database (and Workspace?). So, say, in a database with photos the geolocation might be interesting and therefore visible. For a database with bills geolocation might be of no interest but a due date and the paid status instead.

3 Likes

That will certainly guarantee a steady flow of interesting and panicky questions in the forum :wink:

Seriously: while I like the idea, I’m afraid it will create a UI and support nightmare. Imagine someone seeing data in one database and not in another…

3 Likes

I have largely stopped using custom metadata precisely because of the visibly cluttered nature of global custom metadata.

Global custom metadata that has controlled visibility per database (or group) makes the most sense. Data isn’t lost when moving items from database to database, but what is visible in the inspector pane is controlled and, therefore, potentially less cluttered.

This scenario may lead to additional support questions (e.g. “Where is my data?”) but the questions are quickly and easily resolved (e.g. toggle on your custom metadata fields that have been toggled off).

Database A has custom metadata Author.
Database B does not.

  • Document with Author attribute is moved to database B. So Author is added to the database’s metadata?
  • Document with Author is deleted from the database. Author is left behind in the metadata?

Database A has custom metadata Publication Date set as a Date data type.
Database A has custom metadata Publication Date set as a Single-line Text data type.

When a document from database A moves to database B, what happens to the custom metadata in B to resolve the conflict?


Things aren’t as simple as they may appear to you.

2 Likes

I agree this is complex

Is there a way that “hidden fields” could resolve this?

Database-specific visibility of global custom metadata is indeed planned, this won’t affect the actual metadata. And it’s not complex at all, just user interface stuff.

4 Likes

Excellent - I suspect that can make everyone happy

Is database-specific visibility of custom metadata still being planned? This would be a very practical and elegant solution to improving workflow and reducing confusion for users with several unrelated databases containing large amounts of metadata.

There are many things on our list of possibilities. :slight_smile:
However, there are also questions of inter-operability we need to consider with some features.

It is still planned.

5 Likes

I really need this too. I am increasingly relying on custom metadata but it is always specific to a database. Setting the items up globally would be fine but per database control of visibility would be such a massive improvement. Is really annoying having to view completely irrelevant fields when working across a number of completely unrelated databases.

3 Likes

I just came to ask about this exact thing!

I thought as long as I created a database for each “set” of columns/metadata, I could see the columns I need in the document list, but it seems that this is impossible?

Is the only alternative to turn on irrelevant custom metadata columns for every database? It quickly becomes unmanageable visually.

I’d like to add a vote for development on this feature. While I am not a DT dev, the idea behind it seems like you’d just store the selected columns per database instead of globally? I understand if priorities are on more important/critical issues.

Currently, custom metadata is still global, not per-data database. This may change in the future but as you rightly guessed, there are more critical issues at hand right now.