Hello

BB 6.2.3 Enterprise

I was hoping that someone may help with a request that i have received 
from a manager?
The manager would like to know if there is a way of finding out who 
uploaded a particular document into BB?

I have looked at running this query to find the document id

SELECT * FROM COURSE_CONTENTS_FILES
 WHERE FILES_PK1 = (SELECT PK1 
 		      FROM FILES
		     WHERE FILE_NAME LIKE '%filename.doc%')

This returns the file id or if there is more than one occurrence then the 
partial search in the brackets should be run!

Once the id has been found i then try and run a query on the activity 
accumulator to see who uploaded the document looking for the user id of 
the person, this is what i run

SELECT USER_ID
  FROM USERS
 WHERE PK1 IN (SELECT USER_PK1 
 	         FROM ACTIVITY_ACCUMULATOR
	        WHERE CONTENT_PK1 = *****)

This where i come stuck, the query runs ok but returns no results.  I have 
uploaded a document recently using a temp student account to see if i can 
pick this up using the scripts but the query still returns no results?

Can anyone assist or see what i am doing wrong or have had to do this 
before and would like to share their knowledge?

Would this be a good project for some Java developer using NetBeans as a 
Building Block?

Paul
VLE Administrator / Developer
Doncaster College