Does anyone have a CRP for finding files created by a certain user?
I am also looking for a CRP that finds all the files that were last checked-in by a certain user.
I am not an SQL guy and do not have direct access to the database.
Very disappointing that something this simple does not have an easy solution. Obviously it is not that simple....
I will put a EH in and see if our SQL guy can help.
Bill Stadler - Don't give up too quick, good chance the right people didn't see this yet..
Artem Taturevych - is this possible?
Check this out
or you can hijack SQL
Without a CRP, you can use PDM with built in default query:
For the first search, you can use the Workflow search from the 'Complete Search card':
This will give you all the files that have ever been in the initial state as a result of that user adding them to the vault.
The 'Complete Search' search card also includes 'Version Data' tab that allows you to search for versions created by a given user. If the user in question has checked in lots of files created by others, then this search will yield a lot of extra files that weren't created by the user.
I'll have to think a bit for the second search.
Retrieving data ...