You are right. SQL-2 returns correct results. Thank youI'm acknowledged that everything except SQL-2 is deprecated. (Practice shows that sometimes XPath is much faster than SQL-2 and SQL-2 joins are really slow. But that's not a subject of our discussion)That is not our code. The initiator of this r...

2 days ago I renamed some nodes on a production Author system. Now I've found out that a XPath query returns old paths results.For example a path /a/de_CH/c was renamed to /a/de_DE/c. Currently a XPath query returns /a/de_CH/c that does not exist anymoreInconsistency exists on Author where there are...

For example there are several services. One of services is very resource-intensive (makes high CPU load, IO). Respectively the service has big influence on the performance of other services. That is not acceptable because while resource-intensive background processing is taking place frontend-relate...

According to the doc the sesion's save() method can throw InvalidItemStateException exception.It means that some item that was modified in current session also was modified from other thread and already saved. The transient space of the session cannot be savedThe quesion is what is a best practice i...

How to add additional response header field? For example the request looks like this:http://example.com/content/dam/examples/ex.pdf?I want to add: Content-Disposition: attachment It will force a browser to download file, not showing a file in a browserThanks

XPath query:/a/b/asthrows an error: {results: [ ],total: 0,success: false,time: 0,errorMessage: "Encountered "as" at line 1, column 16. Was expecting one of: <IntegerLiteral> ... <DecimalLiteral> ... <DoubleLiteral> ... <StringLiteral> ... "<?" ... "<?" ... <AxisChild> ... <AxisDescendant> ... <Axis...

What's an example of SQL-2 query for content of a PDF file that was uploaded to DAM?I've checked all nodes and properties but cannot find property with file's contentThanks in advance

smacdonald2008 wrote...The JCR API does not support getSibiling(). That would be a good method for the API to have included.A workaround is to write a custom algorithm that calls  getParent() and then get all the children of that parent. Then you can figure out the nodes under that parent thereby de...

Sham HC wrote...W.r.t live copy requirement it should maintain order. Which version of CQ & are you losings order within child page of live copy. It maintains the order, for example, for geometrix. In my case I have a site with 4000 pages and after live copy creation, the order of the pages in the l...

smacdonald2008 wrote...Did you read this document: http://www.day.com/specs/jcr/2.0/22_Same-Name_Siblings.html ?  Yes, I saw this document. Although my question is not related with SNS because there are no siblings with the same name.For example there are nodes:- A- B- CHow to get the position of B?...