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.

Metadat From Database

sulyman_korj

I am trying to find and way that allow me to create reports for Metadata, I don't know if I can get the Metadata data from alfresco database but I already checked all the database table but I didn't find them, so can any one inform me if they are in database how I can find them?

Please any way that can help me to create the Metadata reports.

Find more posts tagged with

Comments

mrogers

Yes the document metadata is in the database. But it's considered private to alfresco's implementation and you probably shouldn't try to use it directly.

You don't say what sort of "reports" you want, there are different approaches depending upon your requirements for reporting.

You may also like to look at Alfresco's reporting and analytics module.

sulyman_korj

thank you for your reply,

I have 10 custom type ( Invoice - MRf - LPO ….) for each one I have some Metadata now I need a report for example to get all the invoice that status metadata is Approve, but I need it as report ( Name of file - Metadata Status - Metadata Value - Metadata Date -.. )

can you please give the table that has the metadata in alfresco database.

mrogers

That sounds like that can be done by a single Alfresco FTS query. No need to mess around with the database.

There is no single "table". If you really want to do your query via sql then it's going to be a fairly ugly join between five or so tables. The alfresco schema is not big or complicated, but equally its designed for performance and flexibility, not simple reporting.

sulyman_korj

Thanks, it is clear that mean I can do the report from database. I mean I can find all the data that I need in database please can you give me the tables that I can use