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

[fouada]

Hi  All,

I want run following URL and I am using Alfresco 4.1

Below 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&nodeid=3&aclid=4

I don't know how to get txid,acltxid,nodeid and aclid of a node. Please let me know the process to get these IDs.

Thanks,

Fouad

[ycoulon]

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.

[fouada]

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?

[afaust · Accepted solution]

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.

[fouada]

Thanks a lot Axel it was really accurate and helpful.