Content URL of Document

[generic1]

Hi,

I work with SELECT statements to query document informations like:

SELECT * FROM cmis:document c where c.cmisbjectId = '372f68cb-d72d-4694-bb4f-abcdefef09a5'

and it works fine.

Now I also need the property "content URL" of the document (like https://Host_Port/alfresco/api/-default-/public/cmis/versions/1.1/atom/content/file.xml?id=3abcdefb-...)

My question now would be which tables to join in order to get the content URL of the document.
Thanks a lot!
Generic1

[mrogers]

What you do is construct the appropriate URL to call a webscript.    No faffing with "tables" is allowed or required.

[generic1]

Thanks for the response,
So as I understood I shoud not construct a SELECT statement in order to get the content url.
My problem is that I only should have one request because I make the request from an ESB.

If any suggestion is possible I would be thankeful for an advice.
Thanks a lot!
Generic1