Mailing-List: contact dev-help@chemistry.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@chemistry.apache.org
Received-SPF: pass (nike.apache.org: domain of davesanders0@gmail.com
 designates 209.85.220.170 as permitted sender)
MIME-Version: 1.0
Sender: davesanders0@gmail.com
In-Reply-To: 
 <CA+h63SgWGremSM2vzVZa-Xv95QN_KJrHqCHwW7U27oCbujf7hw@mail.gmail.com>
References: 
 <CA+h63SgWGremSM2vzVZa-Xv95QN_KJrHqCHwW7U27oCbujf7hw@mail.gmail.com>
From: Dave Sanders <dave8435@gmail.com>
Date: Thu, 2 Aug 2012 16:11:54 -0700
Message-ID: 
 <CAMCSiznHfxEs_eQSSWTp+svCZ6EtZUE8y0CrdGj9z5X3OwZitA@mail.gmail.com>
Subject: Re: CMIS cannot retrive checkedOut documents using Queries.
To: dev@chemistry.apache.org
Content-Type: multipart/alternative; boundary=20cf307abdf5fbb03004c6508b18

--20cf307abdf5fbb03004c6508b18
Content-Type: text/plain; charset=UTF-8

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
>

--20cf307abdf5fbb03004c6508b18--