topic Re: How to know txid,acltxid,nodeid,aclid of document or node in Alfresco Archive

How to know txid,acltxid,nodeid,aclid of document or node

fouada — Fri, 04 Nov 2016 09:18:34 GMT

Hi All,I want run following URL and I am using Alfresco 4.1Below is used remove transactions, acl transactions, nodes and acls from the index. It can also be used for testing wrong transactions and then to fix them.http://localhost:8080/solr/admin/cores?action=PURGE&txid=1&acltxid=2&nod

Re: How to know txid,acltxid,nodeid,aclid of document or node

ycoulon — Fri, 04 Nov 2016 09:57:32 GMT

Hi,

Node dbid can be found using the node-browser. Look the sys:node-dbid property.

For the txid, acltxid and aclid I think you would have to query the database.

Re: How to know txid,acltxid,nodeid,aclid of document or node

fouada — Fri, 04 Nov 2016 10:16:24 GMT

Thank for Your quick reply Yann,

I am new to alfresco so please tell which table contains txid, acltxid and aclid of node.

And do i have to query using CMIS browser or in postgres client UI?

Re: How to know txid,acltxid,nodeid,aclid of document or node

afaust — Fri, 04 Nov 2016 10:21:52 GMT

You would have to query using database client UI, e.g pgadmin. The tables in question are alf_node, alf_transaction and alf_access_control_list.

But normally, you do not have to query for this. The SOLR URL parameters are designed to be used from results of REPORT actions, which typically already contain relevant ID values and do the heavy lifting (DB analysis) for you. You also do not need all parameters - they are only listed as examples what IDs you can use. Any one of them would be fine.

Re: How to know txid,acltxid,nodeid,aclid of document or node

fouada — Fri, 04 Nov 2016 10:42:24 GMT

Thanks a lot Axel it was really accurate and helpful.