+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, Showing Behaviour Points in Registers in Technical; Hi all, perhaps I'm just having a bad morning but I can't see anyway to do this. If you add ...
  1. #1

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,432
    Thank Post
    1,432
    Thanked 1,160 Times in 794 Posts
    Rep Power
    705

    Showing Behaviour Points in Registers

    Hi all,

    perhaps I'm just having a bad morning but I can't see anyway to do this.

    If you add the "Behaviour today" column to a register, you get shown a count of behaviour incidents for each student. Whilst this is quite useful, it would be infinitely more useful if rather than a count of incidents, it actually showed total points.

    Is there any way of doing that, or am I going to have to raise a CR?

    Please vote for my change request:
    CR: 1309-1214005
    Last edited by LosOjos; 12th September 2013 at 02:17 PM.

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    CR - but i'd probably only +1 it, as it would cripple the system.
    Better off running a report, or using the conduct chart on homepage, though it doesn't apply to timetable subjects.

  3. #3

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,432
    Thank Post
    1,432
    Thanked 1,160 Times in 794 Posts
    Rep Power
    705
    Quote Originally Posted by vikpaw View Post
    CR - but i'd probably only +1 it, as it would cripple the system.
    I don't think so Vik - presumably it currently does something along the lines of "SELECT COUNT(*) FROM Table Where Date=Today", it'd simply need to be changed to return the sum of points which is presumably stored in the same table so simply "SELECT SUM(Points) FROM Table Where Date=Today"... shouldn't even notice a difference. [BTW - that's very much pseudo!]

    Quote Originally Posted by vikpaw View Post
    Better off running a report, or using the conduct chart on homepage, though it doesn't apply to timetable subjects.
    I hate to say it, but I have to agree with the teachers on this one, it'd be much more convenient to see it in the register. Certain Behaviour incidents here are merely for info and follow ups so carry zero points. Others are for fights or truancy and carry high points. As it stands, a student who has been warned for forgetting equipment will look exactly like one who has been had up for fighting until you drill down.

    Go on, gimme a +2

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    I've seen the SQL on some patches and procs and it wouldn't never be that straight forward, but yes the end result should be a switch from count to sum, but it's bad enough getting a report to collate that sort of info.
    All the same - i'm thinking it would be good so gimme a # and i'll give +2

  5. #5

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,432
    Thank Post
    1,432
    Thanked 1,160 Times in 794 Posts
    Rep Power
    705
    Cheers Vik

    1309-1214005

  6. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    Done.
    Of course, when we switch to the new SupportNet it will get washed away

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 0
    Last Post: 16th May 2013, 01:11 PM
  2. [SIMS] User Defined Fields and SHowing in Registers
    By TJIT in forum MIS Systems
    Replies: 5
    Last Post: 11th October 2010, 07:54 AM
  3. Showing hidden files in recycler
    By zag in forum Windows
    Replies: 5
    Last Post: 27th April 2010, 02:14 PM
  4. Show Desktop Icon in Taskbar missing
    By jgcracknell in forum Windows
    Replies: 4
    Last Post: 5th December 2009, 11:47 AM
  5. Test individual access points in a dense wireless network
    By monkey_boy in forum How do you do....it?
    Replies: 8
    Last Post: 6th February 2007, 07:49 PM

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

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