topic Re: Finding a tenant name given the ID of a document in Alfresco Archive

Finding a tenant name given the ID of a document

leey522 — Mon, 28 Jul 2014 23:47:32 GMT

Given a document ID, is there a way to find out which tenant the document belongs to?Thanks in advanceLee

Re: Finding a tenant name given the ID of a document

mrogers — Tue, 29 Jul 2014 08:35:51 GMT

Dbid or node ref? Node ref requires tennant Id / repoid to be unique.

Dbid requires repoid to be unique.

So you may be able to find the tennant I'd from the dbid. (I.e. it's theoretically possible)

You can probably find some tennant ids from node ref however note that that's plural.

Re: Finding a tenant name given the ID of a document

leey522 — Tue, 29 Jul 2014 13:29:12 GMT

Both id and nodeRef properties of the document are available at the time.
Is there a SQL that I can run to find the tenant that the document belongs to?

Thanks.

Lee