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.

Get backend SQL Query of CMIS Query

jigir_shah

Hello All,

We have ACS 6.2.1 version without Solr or search services. We are using CMIS queries to search documents. When I am executing CMIS Queries, in back-end, Alfresco DB query should be hitting.

I would like to get equivalent SQL Query of my CMIS Query. How can I get that? What all Loggers should I need to enable in log4j.properties?

Can anyone please help me out here?

Find more posts tagged with

Alfresco Content Services

Comments

EddieMay

Hi @jigir_shah

Here is something about CMIS queries that should help you. And from the same author I think this blog might prove pretty useful too.

HTH,

cesarista

Hi:

When you say that you are using ACS 6.2.1 version without Solr or search services sounds quite odd. First not all CMIS queries must be solved directly with the database (just put a TEXT or IN_TREE operator for example) , so not all CMIS queries are transactional. Besides, search subsystem must be configured this way, try first database if possible.

https://docs.alfresco.com/5.2/concepts/intrans-metadata-query.html

If you use some kind of SQL profiler in your database you may have this type of info. It is only useful if by performance considerations, when you have to add additional indexes in your database.

https://hub.alfresco.com/t5/alfresco-content-services-blog/alfresco-6-profiling-with-docker/ba-p/295846

If loggers are not enough, I remember a jdbc profiler too:

https://github.com/p6spy/p6spy

Regards.

--C.

P.S: Thanks Eddie for the links.