topic Re: How can i get document list excluding pwc version? in Alfresco Forum

How can i get document list excluding pwc version?

hs_j — Mon, 04 Mar 2019 09:37:06 GMT

I am using the alfresco repository with cmis and Alfresco Content Services REST API in my web application. Executing a select query statement will get two documents, including the pwc version. I want to get a list of documents except the pwc version.I do not want to remove the pwc document from the

Re: How can i get document list excluding pwc version?

hs_j — Wed, 06 Mar 2019 00:06:30 GMT

The problem was solved by removing pwc from the query result statement.

There was no need to worry about this problem in the paging process.

Re: How can i get document list excluding pwc version?

devor — Fri, 05 Jun 2020 09:04:42 GMT

Hello

I got same issue, how did you remove pwc in the cmis query ?

I am using Alfresco 5 and Apache chemistry java api.

thank you.

Re: How can i get document list excluding pwc version?

EddieMay — Fri, 05 Jun 2020 09:36:00 GMT

Hi @devor,

Have you looked at this documentation? It's deprecated but explains that pwc is to get the "private working copy".

Gets the specified information for the private working copy (for checking out & working with versions I believe).

GET /alfresco/service/cmis/pwc/i/{id}?filter={filter?}&includeAllowableActions={includeAllowableActions?...

Gets the specified information for the object (Folder or Document).

GET /alfresco/service/cmis/i/{id}?filter={filter?}&returnVersion={returnVersion?}&includeAllowableAction...

So, is it just a case of removing pwc from the query call?

HTH

Re: How can i get document list excluding pwc version?

devor — Fri, 05 Jun 2020 10:21:24 GMT

Thanks for your reply.

yes I looked this documentation.

I buid a document explorer, using paging feature of api.

// exemple

final String query = this.createQuery(props, gedProperties, sortingCriteria, orderBy); // createQuery method exemple return -> SELECT * FROM mw:doc WHERE mw:entiteId='103861' ORDER BY cmis:name ASC

ItemIterable<QueryResult> result = session.query(query, false); // with false I return only last version of documents

final long totalItems = result.getTotalNumItems();

final ItemIterable<QueryResult> pageQueryResult = result.skipTo(0).getPage(5);

--------------------------

-without checkout any document

My result query, return 5 items , and my pageQueryResult return 5 , this case is ok.

- after checkout one of this 5 documents

totalItems return now 6 items ( 5 items + 1 pwc)

and my pageQueryResult return only 4 and the fifth is now in second page.

so I want to exclude pwc from the result.