we have installed Alfresco community v.5.2.0. A colleague of mine told me that a document which he was sure to have uploaded is disappeared from Alfresco. Is there a way to check if Alfresco has lost an updated document? And how can we check if uploaded documents are always in the folders?
Although the questions are somehow general and they may speak about trust in your content management system, the simplest could be just to check the logs, when the user updated the document, to see errors related or many errors in the time the user assures to do the update. To check sites activity may help to check the update (if it was updated in sites). If having audit enabled you could track user actions too. All of this will be a starting point, but only if you trust in the correct work of your Alfresco system.
for Sepgs2004: the document has been uploaded about two months ago using the standard button "upload" on the top.
for Cesarista: so, you suggest to check logs and to enable audit. I'm new to this, could you give me some information on how to check logs and how to enable audit? Our Alfresco site is collaborative type.
Thank you for your replies. For me is very important this matter. I cannot continue to trust in Alfresco, if documents disappear from the folders.
thank you for your accurate reply. Following your suggestion, I've installed CMIS Workbench client. This sw is new to me, so now I've to learn how to use it and how to make the queries. Hoping not to disturb you so much, could you tell me which is the sintax for the query you mentioned? Is there a guide somewhere?
Once you get a short overview on the queries, it is not that difficult to write them. CMIS queries can be written and called from CMIS API's in languages like Java, Python, etc. Also, you can directly write queries using the CMIS workbench for debugging and learning.
You might have already found some related resources online
On the other hand, if you can get a hold of this book PDF - CMIS and Apache Chemistry in Action,
then it contains a dedicated chapter at least on queries.
This CMIS and all looks like a deviation from resolving your original issue. However I hope this will help your Alfresco work in some way or other.
One custom example
Here we have our own custom type (slo) extending the cmis:content, which contains our custom aspect (slo:documentProperties) as mandatory. documentProperties is our custom aspect of several properties Trying to query with where clause containing conditions on our custom aspect properties (lo_link, lo_category)
SELECT doc.*, SLOALIAS.* FROM cmis:document AS doc JOIN slo:documentProperties AS SLOALIAS ON doc.cmisbjectId = SLOALIAS.cmisbjectId WHERE IN_TREE(doc, 'workspace://SpacesStore/0a813931-e5d4-4a4a-82ad-8ccbbd1c2405') AND (SLOALIAS.slo:lo_link = 10) AND (SLOALIAS.slo:lo_category = 'Comp')
SELECT * FROM cmisbook:text where cmisbook:author IN ('Jane Taylor', 'Geoffrey Chaucer')
String: SELECT * FROM cmisbook:text where cmisbook:author IN ('Jane Taylor', 'Geoffrey Chaucer')
DateTime: SELECT * FROM cmisbook:image WHERE cmis:creationDate NOT IN ( TIMESTAMP '2011-06-30T12:00:00.000Z', TIMESTAMP '2012-06-30T12:00:00.000+00:00')
ID: SELECT * FROM cmis:document WHERE cmisbjectId IN ('130','131','132','133')
Integer: SELECT * FROM cmisbook:audio WHERE cmisbook:year NOT IN (1988, 1990)
Decimal: SELECT * FROM cmisbook:video WHERE cmisbook:videoDuration NOT IN (0, 60.0, 120.0)
To match a percent sign or underscore in a LIKE predicate, the escape character backslash (\) must precede the % or _. This example returns all of the lyrics for song titles that start with “Sacred_”: SELECT cmisbook:songtitle FROM cmisbook:lyrics WHERE cmisbook:songtitle LIKE 'Sacred\_%'
This example returns all of the lyrics in which the author name ends with “%Bleu”: SELECT cmisbook:author FROM cmisbook:lyrics WHERE cmisbook:author LIKE '%\%Bleu'
The following two examples should both work to return all of the lyrics for documents where the song titles start with “David’s”: SELECT cmisbook:songtitle FROM cmisbook:lyrics WHERE cmisbook:songtitle LIKE 'David''s%' SELECT cmisbook:songtitle FROM cmisbook:lyrics WHERE cmisbook:songtitle LIKE 'David\'s%'
Finally, if you want to match the backslash character itself, add another backslash. This example matches “back\slash” in the song title: SELECT cmisbook:songtitle FROM cmisbook:lyrics WHERE cmisbook:songtitle LIKE 'back\\slash%'
Try testing a Boolean property for FALSE, or not set at all: SELECT * from cmisbook:note where cmis:isVersionSeriesCheckedOut is null OR cmis:isVersionSeriesCheckedOut = FALSE
SELECT * FROM cmisbook:note WHERE ANY cmisbook:noteLinks NOT IN ( 'resource.txt' , 'test.txt') OR cmisbook:noteLinks IS NULL