+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, Sims Assessment Missing Marks in Technical; I made a report in sims that looked up an aspect name and returns all the pupils and their results. ...
  1. #1

    Join Date
    Nov 2009
    Posts
    19
    Thank Post
    1
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Sims Assessment Missing Marks

    I made a report in sims that looked up an aspect name and returns all the pupils and their results. I then tried to run a similar report but to return all pupils with the aspect name but with result set to IS Null, and although I know of pupils with no result Sims does not return any records.

    When I first set this report up, it worked fine but since updates have been done, it does not work.

    Any ideas???

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,528
    Thank Post
    1,460
    Thanked 1,214 Times in 823 Posts
    Rep Power
    724
    This is a reply by TimH from when you previously asked a similar question in this thread.

    I think it's basically impossible using standard SIMS/reports, I spent ages trying and ended up raising a Supportnet ticket which agreed !

    We were running progress checks and wanted to know who had incomplete sets but you can't do this, if Johnny is doing French he should have French grades, if not doing Spanish he would show as having Spanish grades missing (which is useless).

    It needs some way of know what is missing from what the individual student should have, I'm waiting for response to an escalation of the ticket.

    tim
    seems it's not currently possible to create the report you're trying to

  3. #3

    Join Date
    Nov 2009
    Posts
    19
    Thank Post
    1
    Thanked 1 Time in 1 Post
    Rep Power
    0
    my report runs and finds by aspect name the students who have a grade so it should, in theory just mean seting result to is Null, it works and returns pupils if result is set to is not null, therefore logic of database would suggest that the problem is within the coding of Sims.

  4. #4

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,528
    Thank Post
    1,460
    Thanked 1,214 Times in 823 Posts
    Rep Power
    724
    I agree with you, it makes no sense when looking at it from the standard POV of how a database works, and yes it has something to do with Sims, which I'm afraid leaves the only option of raising a ticket at SupportNet as TimH did and hoping for the best

  5. #5

    Join Date
    Nov 2009
    Posts
    19
    Thank Post
    1
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Will do, thanks very much.

  6. #6

    Join Date
    May 2009
    Location
    Sheffield
    Posts
    258
    Thank Post
    23
    Thanked 38 Times in 29 Posts
    Rep Power
    20
    Quote Originally Posted by JoshJohnson View Post
    I agree with you, it makes no sense when looking at it from the standard POV of how a database works, and yes it has something to do with Sims, which I'm afraid leaves the only option of raising a ticket at SupportNet as TimH did and hoping for the best
    There's not really a way to do it! I think you're imagining a query like this:
    Code:
    SELECT s.studentname, s.reg
    FROM studentsview AS s
    WHERE NOT EXISTS
    (SELECT resultvalue FROM resultsview AS R
    WHERE r.aspectid="Some Aspect Id"
    AND r.studentid=s.studentid);
    whereas what's actually happening is more like this:
    Code:
    SELECT s.studentname, s.reg, r
    FROM studentsview AS s LEFT JOIN resultsview2 AS r
    ON (s.studentid=r.studentid);
    
    resultsview2:
    SELECT * FROM resultsview
    WHERE resultsview.aspectid="Some Aspect Id"
    AND resultsview.resultvalue IS NULL;
    There are no null result values! So all that happens is you get a list of all the students matching the criteria you want, along with a blank result.

    The way round it, is not to filter on a null value! You can filter the result for aspect name, resultset, etc.; after that, either just display a count of results, or select the result value, and then you can sort the output afterwards to display either students with 0 results, or with a blank value (depending on how you've set up the report).

    It might be that the new reporting engine changes all this, but we'll see!

    Doing it the other way round is much easier - you can untick the "Include records with no such results" box, but there's no equivalent to get the disjoint set.

SHARE:
+ Post New Thread

Similar Threads

  1. Missing marks in Sims Assessment Manager
    By MACIT in forum MIS Systems
    Replies: 16
    Last Post: 9th February 2010, 05:29 AM
  2. Sims Assessment Report
    By Ecalpemos2000 in forum MIS Systems
    Replies: 2
    Last Post: 9th December 2009, 03:45 PM
  3. Example Assessment Reports in SIMS
    By garethedmondson in forum MIS Systems
    Replies: 5
    Last Post: 7th November 2009, 11:47 AM
  4. SIMS Attedance Marks Deleted
    By unmode in forum MIS Systems
    Replies: 16
    Last Post: 14th July 2009, 11:29 AM
  5. Moodle and Assessment Manager/Sims
    By Mintsoft in forum Web Development
    Replies: 33
    Last Post: 15th May 2006, 01:49 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •