Search for the node just created JAVA

alfresco_one — Fri, 17 Mar 2017 14:25:39 GMT

Hi All,In one requirement I need to query just created document. If I use lucene search then it will take few seconds to do the indexing and may not come in the search result.The query should be executing from some alfresco webscript or a scheduler which runs every 5 seconds.Right now I am doing it

Re: Search for the node just created JAVA

afaust — Thu, 23 Mar 2017 19:31:14 GMT

If you are using Alfresco 5.0 or above, there is no more Lucene. If you mean you are using the "search query language" Lucene, then you should stop doing that - it is a legacy language. Use Alfresco FTS or CMIS queries instead. These query languages are also capable of using a direct DB query if the query is simple enough (look for transactional metadata query in the documentation). In that case there is no delay for indexing at all. If your query is too complex to execute against the DB, you will always have to deal with the asynchronous indexing that SOLR performs.

Since I don't really know what other conditions you want to query for ("just created" is a bit too vague) it is difficult to suggest an alternative to looking up nodes via the NodeService. If you don't care about the type and/or other metadata on the document(s), and really want to look up "any" document "just created", you can do a simple CMIS query like:

SELECT * from cmis:document D where D.cmis:creationDate > TIMESTAMP '2017-03-23T19:30:00.000Z'

The above query selects all documents that have been created after the specified timestamp. Obviously you would have to dynamically create the query to adjust the timestamp to the meaning of "just created" you need to handle.

topic Re: Search for the node just created JAVA in Alfresco Forum

Search for the node just created JAVA

Re: Search for the node just created JAVA