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.

Limitations Search and insights engine?

hansdebal

Hi,

I think I'm stumbling upon some limitations of the insights engine. Is it somehow possible to:

* Execute a query with date-difference queries? Eg: I want to be able to create a query (in Zeppelin/Solr) which calculates how many days a certain document is active (suppose we have a custom aspect which defines an inactiveDate). So I want a query which calculates inActiveDate - cm:created and then groups the results accordong this datediff. so my result should be:

- There were x documents active for 5 days

- there were y documents active for 7 days

- ...

Possible?

Running on ACS 6.1 and insights engine 1.1.0.1

Find more posts tagged with

Alfresco Content Services

Comments

angelborroy

DATEDIFF sql function is not supported, as this cannot be achieved using Solr SQL.

The better approach is tu use a classic facet query for this use case.

hansdebal

Is it possible to do facet queries in Zeppelin? Because I would want to put the results in a pie-chart or something similar.

angelborroy

Did you try a GROUP BY clause?

hansdebal

Yes, but to do that I would first need a way to calcalute the date-difference, no?

If this is not possible, I would think this is a feature that should really be investigated. Common use cases you would want to report on is:

* average throughput time of a case (from open to closed)

* average throughtput of workflows

* all other date-related reports