Thanks Andy - I'll pass it on to the person who was
asking.
--------------------------------------------------
Gary Clay
Learning Development
Manager
Learning Development and
Innovation
Staffordshire University
Beaconside Campus
Stafford ST18 0AD
Telephone +44 (0) 1785
353648
Try this for a specific student
select
f.file_name,f.link_name,u.status_ind,u.upload_date,u.dtmodified
from
bb_bb60.files f , bb_bb60.course_user_uploads u , bb_bb60.course_users c,
bb_bb60.users s
where
f.pk1=u.files_pk1 and u.course_users_pk1=c.pk1 and c.users_pk1=s.pk1 and
s.user_id='u0870483'
order by
u.upload_date asc
Note, The STATUS_IND column represents the following :
a = Added
s = Sent
r = Received
Hope this
helps
Andy
Raistrick
Email: [log in to unmask]
Tel: (01484) 471315
The University of
Huddersfield
Computing and Library Services
PO Box No.
341
Huddersfield
HD1 3DH
... obtaining details
of Student work submission
into Blackboard (via dropbox/assignment/turnitin) - per
student/module?
--------------------------------------------------
Gary Clay
Learning Development
Manager
Learning Development and
Innovation
Staffordshire University
Beaconside Campus
Stafford ST18 0AD
Telephone +44 (0) 1785
353648
The
information in this email is confidential and is intended solely for the
addressee. Access to this email by anyone else is unauthorised.
If you
are not the intended recipient, any disclosure, copying, distribution or any
action taken or omitted to be taken in reliance on it, except for the purpose of
delivery to the addressee, is prohibited and may be unlawful. Kindly notify the
sender and delete the message and any attachment from your computer.
This transmission is confidential and may be legally
privileged. If you receive it in error, please notify us immediately by e-mail
and remove it from your system. If the content of this e-mail does not relate to
the business of the University of Huddersfield, then we do not endorse it and
will accept no liability.