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.
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.
Bill Stadler - Don't give up too quick, good chance the right people didn't see this yet..
Artem Taturevych - is this possible?
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.
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.