Incomplete list displaying student profiles

Hi Ross,

I’m referring to q=/modules/Students/student_view.php.

The table displays 4 columns: Name, Year Group, Roll Group and Actions.

If a activate the “All Student” box, data in Year Group and Roll Group don’t show anymore. I think there is a bug in the sql statement.

Kind regards,
Roman

Roman,

Sorry for the delay in replying: I am still on leave with intermittent Internet access.

This is not so much a bug, just perhaps a non-optimal approach to coding the SQL. The attempt was to have less strain on the database server by using a more efficient SQL statement that shows less information. It would be possible to show more information, with All Students checked, but it would be more database intensive.

Most of the time, in this mode, you are searching for students who are not registered in the current year, and so in my experience it is a non-issue. Is this causing serious problems for you?

Thanks,

Ross

Hi Ross,

I wouldn’t say that this causes serious problems for me. I didn’t understand, why the data was not showing. To have Year Group and Roll Group displayed helps a lot in selecting the right entry. If the entry is missing also helps identifying the right record.

Let me try and see how the complete sql statement works for me. Can you paste it?

Kind regards,
Roman