How to query a custom model document by property from version store in alfresco?

[manikandaprabus]

I want to query old version document by search service. I have used store ref as "workspace://version2Store" in alfresco webscript. But it not working. By default , we can search latest document using fts-alfresco which is available in spacesstore. That same thing , i need in version store also. How to query using webscript? Please guide me.  

[cesarista]

Hi:

You may try in node browser for example (selecting the corresponding store), or via Javascript API in JS Console too:

query | Alfresco Documentation 

Regards.

--C.

[afaust]

Bear in mind that the version store is by default not indexed using SOLR, so the only queries you will be able to make need to be compatible with TMQ (transactional metadata query), i.e. executable against the database. This is also dependent on the Alfresco version, with initial support added in 4.2, and further enhancements in 5.1

[manikandaprabus]

Yes. I have tried by using alfresco Node Browser and using webscript also. But I not get any result by that service.

[manikandaprabus]

Yes. By default version store is not indexed by SOLR. How to achieve index version store using TMQ in alfresco?  I need version store index for some specific custom model only. I am using 5.2 community edition. Kinldy help me.

[afaust]

You do not need an index for TMQ - that is the whole point. Simply write a query that can be executed against the DB. Read up in the documentation what that means, or take a look at a presentation of mine from BeeCon (video / slides).