How to query your custom table

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Rahul_Mittal

fileTags id fileTags java:/nxsqldirectory directories/nature.csv fileTagsDirectory-cache always fileTagsDirectory-cache-without-ref I have created the above vocabulary. I am getting below log 2019-12-24T13:26:44,232 DEBUG [main] [org.nuxeo.ecm.directory.sql.SQLHelper] setting up table 'fileTags', policy='on_missing_columns' 2019-12-24T13:26:44,234 DEBUG [main] [org.nuxeo.ecm.directory.sql.SQLHelper] checking if table fileTags exists: true 2019-12-24T13:26:44,237 DEBUG [main] [org.nuxeo.ecm.directory.sql.SQLHelper] all fields matched for table 'fileTags'

I have tried getting select * from fileTags in nuxeo Dev Tools chrome extension or in nuxeo home NXSQL serach. But i am not getting anything. please let me know how to check the records.

Rodri_

Hello,

using NXQL you only can search for documents. In nuxeo, documents include files, folders, users and groups. However, vocabularies are not considered as documents, so you cannot search for them using NXQL.

I recommend you to read the following documentation in order to understand how directories (vocabularies) work:

• Vocabularies: https://doc.nuxeo.com/studio/vocabularies/
• Data Lists and Directories: https://doc.nuxeo.com/nxdoc/data-lists-and-directories/

Anyway, what's the aim of retrieving the vocabulary entries? Depending on it, there are several ways of retrieving that information, like directly seeing them in the Web UI, using the REST API or even with SDK clients.

Regards.