nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Is it possible to query data with SQL directly?

alex_chew

Hi,

I have created many customized models in Alfresco. Now I want to generate report from these models with Pentaho report engine. Is it possible to query business data record from Alfresco by customized SQL?

Any advice will be appreciated.

Thanks and regards,
Alex

Find more posts tagged with

Comments

jpotts

Definitely not recommended. The Alfresco schema is not public and can change without warning.

If you must, at least build your reports against a replica of the data to avoid potential performance problems.

Jeff

carlos_miguens

As a further suggestion once you have exported the data I'd suggest you build some views and report on those, the Alfresco model is not very obvious and if it changes it means that you will need to just change your views rather than your report queries.

Carlos