topic Re: Add additional table in nuxeo database in Nuxeo Forum

Add additional table in nuxeo database

gaosh — Fri, 17 Jan 2025 02:57:29 GMT

In the custom addons ， i want to record some info in the db and read them later。 i want to add new table (in vcs) or new collection (in dbs)。 How can i achieve this？

Are there any references or demos? Or a thought or a step?

Re: Add additional table in nuxeo database

Josh-F-Hyland — Fri, 17 Jan 2025 17:40:12 GMT

This isn't really how you're meant to use Nuxeo. VCS and DBS are abstraction layers. You shouldn't need to mess with them directly and, in this way, the backend database is fully pluggable. It's certainly *possible* for you to customize the platform and do whatever you want, but not recommended 🙂 I suppose you'd like to have some kind of simple key-value store? I would say there are a couple of options:

Create a "settings" Document Type. You can simply store your "settings" using the data model. You can store each setting as a separate document or even using a single document (with a complex multi-valued field).
Store "settings" in nuxeo.conf; you can retrieve them in Automation, for example, using the Env[] object, e.g. Env["my.cool.setting"]

Re: Add additional table in nuxeo database

gaosh — Sat, 18 Jan 2025 14:41:34 GMT

Much thanks for your kindly reply ❤️.

To be more specific, for example, I want to store a list of documents that one user has edited and a list of documents that one user has been opened and the relative newest opened time and the newest edited time for each document. I need to retrieve these lists when needed.

Where can I store this information and retrieve it later? My idea is to create a separate table to store this information asdescribed in the previous question, but I don’t know how to do it.

Like you mentioned above, creating a new document type for this purpose? Is any other method and how?

Re: Add additional table in nuxeo database

Josh-F-Hyland — Tue, 21 Jan 2025 19:31:01 GMT

You can alternatively use local storage a la the "Recently Viewed" list that you see on the Web UI Dashboard (and to be clear I mean you'll need to investigate this widget using dev tools, there's no documentation that I'm aware of but it at least provides an example).

If the lists must be server side, it's a good use case for Collections IMO (https://doc.nuxeo.com/n/Rai).