CMIS cannot retrive checkedOut documents using Queries.

[Pratyush Sinha <pr...@gmail.com>]

Hi everyone.

I am creating CMIS webApplication .

I trying to search document using Query.

In a simple Search.

SELECT * FROM cmis:document WHERE cmis:name LIKE'prog%'

It gives all the documents  name start with prog  except the document
(prog.txt  )which is checked out.

In Content Engine
 When i execute similar query it gives me all the document name prog and
isCheckedOut..

In a workbench I execute 2 queries

SELECT * FROM cmis:document WHERE cmis:name LIKE'prog%' and (cmis:createdBy
='p8admin') and
(cmis:isVersionSeriesCheckedOut =false)

above query is working fine
Got outPut : all the Document starts with prog and is created by p8admin
and is not checkedOut.


But when i execute

SELECT * FROM cmis:document WHERE cmis:name LIKE'prog%' and (cmis:createdBy
='p8admin') and
(cmis:isVersionSeriesCheckedOut =true)

Is doesnt gives me any file , but in a Content Engine i have file starting
with prog and created by P8admin and cmis:isVersionSeriesCheckedOut =true.


Can any one please this.


Thank You

Regards
PratZ

Re: CMIS cannot retrive checkedOut documents using Queries.

[Dave Sanders <da...@gmail.com>]

Check the "search all versions" box on Workbench's query panel.  Until it
is checked in, a PWC must not be considered the latest version in the
version series.

If query with searchAllVersions=true does not resolve the issue, please
post to the CMIS for FileNet forum [1] since this does not sound like a
Chemistry issue.

[1]  http://www.ibm.com/developerworks/forums/forum.jspa?forumID=2334



On Thu, Aug 2, 2012 at 10:48 AM, Pratyush Sinha <
pratyush.sinha2511@gmail.com> wrote:

> Hi everyone.
>
> I am creating CMIS webApplication .
>
> I trying to search document using Query.
>
> In a simple Search.
>
> SELECT * FROM cmis:document WHERE cmis:name LIKE'prog%'
>
> It gives all the documents  name start with prog  except the document
> (prog.txt  )which is checked out.
>
> In Content Engine
>  When i execute similar query it gives me all the document name prog and
> isCheckedOut..
>
> In a workbench I execute 2 queries
>
> SELECT * FROM cmis:document WHERE cmis:name LIKE'prog%' and (cmis:createdBy
> ='p8admin') and
> (cmis:isVersionSeriesCheckedOut =false)
>
> above query is working fine
> Got outPut : all the Document starts with prog and is created by p8admin
> and is not checkedOut.
>
>
> But when i execute
>
> SELECT * FROM cmis:document WHERE cmis:name LIKE'prog%' and (cmis:createdBy
> ='p8admin') and
> (cmis:isVersionSeriesCheckedOut =true)
>
> Is doesnt gives me any file , but in a Content Engine i have file starting
> with prog and created by P8admin and cmis:isVersionSeriesCheckedOut =true.
>
>
> Can any one please this.
>
>
> Thank You
>
> Regards
> PratZ
>