Query list not returning items checked out to others

Hi,

is the query or the check in the problem? I mean does your query receive all checked out items or only the ones checked out by you?

I'd love to test this myself but my dev license has expired once again =

Seems like your queries "<Eq>" filters for the current userID. Could work if you remove this filter.

Regards

Philipp

It's actually the query list. It only returns items checked out by me. I'll try removing the current userID filter and see if that works.

If you provide the "<UserID />" it always filter for the ID of the user running the workflow, which in this case is yourself. But since you want to check in everything no matter who checked it out, this filter has to be removed.

Keep us informed on how it's working.

Regards

Philipp

So, I changed the filter in the query list to return all where checked out is not null. Nothing came back but there are items currently checked out in this library.

Removing the UserID filter did not resolve. I'm still unable to query items checked out to others.

That's odd, the query looks good. I would need to test this myself to see what's not working there. Maybe tomorrow I will find some time.

I let you know if i find something.

crossc,

There are two behaviors about the Checkin process/action that I'm aware of:

1. The "Override Check Out" permission is required to check-in another's documents.
2. Within a workflow, the Check-In action tends to only function on items that have been Checked-out by the corresponding workflow action.

Hope this helps,

Gerard

I have full control and can manually check in other's documents.

Using this same workflow, I was able to check in documents I manually uploaded to the library.

However, when attempting to check in all on another library I could see other's documents currently checked out.

I tried this on my dev machine and it worked without a problem. I used the same filter you did (Checked Out to != null) and received all items that were checked out, no matter if i checked them out myself or any other user.

I would recommend to create a test list on some dev site and test the same workflow there. Sorry, but can't help you any further.

Maybe someone else has an idea...

Regards

Philipp

Does it matter that the file has not been checked in initially?

I ran a small test and uploaded an item without checking it in. It was checked out to me though.

Can you display the "Checked out to" column in your library and see if there is any information in this column? This is the column you are using in your filter.

edit: Sorry, just saw the screenshot you provided earlier. Seems like the column stores the info correctly but your query isn't working. Can you try to replicate the issue on another site collection? Please also double check the parameters in your "query list" action. Don't get me wrong but sometimes it is the most obvious things causing trouble (like querying the wrong list).

I've queried different libraries with the same scenario and can only see my files. I will open a ticket.

Just curious. Are you running a site workflow?

Yes. I opened a ticket with Nintex last week to look into this issue. The last update I received was that a bug had been opened with their development team for the Query List action failing to detect items with no checked in version.

Per Nintex Support, there is an issue that occurs inside the Sharepoint architecture and how the "Query List" action works inside that architecture that prevents the files with no checked in version from being returned by accounts that do not own the checkout of the item.  Due to this there is not a method for returning the information inside Nintex Workflow.

There is an alternate method to accomplish the required task outside of the Nintex Program. The following link shows an example of a powershell script that can be run to take over the checkout and then check in items.

https://shipoint.com/2012/09/24/taking-ownership-and-checking-in-documents-with-no-checked-in-versions-in-sharepoint-2007-using-powershell/