[sims] Report to show titles of linked documents

[pubgrub277]

I'm wanting a report to show me details of documents linked to students in the DMS.

I cant for the life of me find the right fields.

 

If it can be done i would like: Document name, Date added.

 

Anyone have any ideas?

[LosOjos]

I'd love to be proven wrong, but I don't think there is any way to run such a report from SIMS' reporting engine, at least I've never found it.

 

On a related note, I've been trying to gain access to the infamous Business Objects to run reports outside of SIMS' capabilities for some months now, still hasn't happened.

[vikpaw]

Do you have access to the SQL via management studio?

I haven't used this for a long time, but i still think it's valid, though i haven't double checked, it ran okay:

use sims
select dm.attachment_name,
dm.last_modification_date,
dm.last_modified_by,
dm.note,
dm.summary,
dm.entity_id,
dm.created_by_id,
per.surname,
per.forename,
stud.latest_adno
from sims.stud_student stud join sims.dm_document_710 dm on dm.entity_id = stud.person_id
join sims.sims_person per on dm.entity_id = per.person_id
where stud.latest_adno = '001234' AND dm.attachment_name IS NOT NULL

 

Will give you the latest modification date, which is for us normally when they get uploaded.

All you have to do is fill in the admission number for the student. Or remove that clause and you'll get all students.

The name might not be too usable as it includes what look like random characters at the start.