[Using Sakai] sakai-user Digest, Vol 42, Issue 18

[Gregory Guthrie]

@holladay; thanks,
This is neat magic, but where can one find the details of how to do such queries? Table names, fields, schema, etc.

I'd like to make a query that would give the same results as a report that I have defined, so I could just do (automatically) externally from akai, but don't know how to make the repot onto a Sakai database query.

This may be a poor approach, since I read that it would be fragile as internal schema can change between releases, but it looks simpler than trying to write new Java code to do this, if I can find the right query(s).

Is there any source of examples of various queries like this that people use, perhaps for utility functions?

-------------------------------------------
> You need to find the submission in the database and set the forgrade column to true:
> 
> update SAM_ASSESSMENTGRADING_T ag
> set ag.FORGRADE = true
> WHERE ag.publishedassessmentid = :asessment_id and ag.ASSESSMENTGRADINGID = :submission_id