Oracle and lucene query on modification date about alfresco-business-reporting HOT 3 OPEN

Hi Tjarda,

I've solved setting the query in harvestingMoreFrequent using \\

folder=TYPE:"cm:folder" AND NOT TYPE:"st:site" AND NOT TYPE:"dl:dataList" AND 
NOT TYPE:"bpm:package" AND NOT TYPE:"cm:systemfolder" AND NOT TYPE:"fm:forum" 
AND NOT TYPE:"fm:post" AND NOT TYPE:"fm:topic" AND NOT @cm:\\name:emplo* AND 
NOT @cm:\\name:persn* AND NOT @cm\\:creator:System

BR
Vincenzo

Vincenzo,

Thanks for the question. And the answer :-)

Does it work for you to change the query as displayed? Or is the 
'modified-query' getting you in trouble anyway?

(The 'modified query' part is needed to be able to find only incremental 
changes since last successful Harvesting run...)

Hi Tjarda,

Initially I thinked that the modified-query was the cause but I see that change 
the query adding \\ solve the problem.

However I see that there is a difference between DB. In MySQL, using 0.8.0.3 
version all work fine with just \. Starting from 1.0.1.4 I and in Oracle I see 
that need \\

BR
Vincenzo