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

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

manikandaprabus — Tue, 14 Aug 2018 09:11:13 GMT

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

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

cesarista — Tue, 14 Aug 2018 18:56:05 GMT

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.

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

afaust — Wed, 15 Aug 2018 08:57:42 GMT

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

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

manikandaprabus — Thu, 16 Aug 2018 11:19:59 GMT

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

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

manikandaprabus — Thu, 16 Aug 2018 11:31:27 GMT

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.

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

afaust — Thu, 16 Aug 2018 13:11:10 GMT

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).