Moodle plugins directory: Attendance

Attendance
The Attendance activity allows teachers to maintain a record of attendance, replacing or supplementing a paper-based attendance register. It is primarily used in blended-learning environments where students are required to attend classes, lectures and tutorials and allows the teacher to track and optionally provide a grade for the students attendance. The instructor can set the frequency of their classes (# of days per week & length of course) or create specific sessions.
To take attendance, the instructor clicks on the "Update Attendance" button and is presented with a list of all the students in that course, along with configurable options and comments. The default options provided are: Present, Absent, Late & Excused. Instructors can download the attendance for their course in Excel format or text format.
Sessions can also be configured to allow students to record their own attendance and a range of different reports are available.
Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'LIMIT'.
SELECT * FROM mdl_attendance_rotate_passwords WHERE attendanceid = '10793' AND expirytime > '1585156464' ORDER BY expirytime ASC LIMIT 2
[array (
0 => 10793,
1 => 1585156464,
)]
I reported it in bug tracker in git Hub
I don't understand what you mean by the pull request.
I guess query should be something like the below for MS SQL, I will suggest that in the bug
SELECT * FROM (
SELECT *, ROW_NUMBER() OVER (ORDER BY expirytime ASC) AS RowNum FROM mdl_attendance_rotate_passwords WHERE attendanceid = ? AND expirytime > ?
) AS MyDerivedTable
WHERE MyDerivedTable.RowNum BETWEEN 1 and 2
A question, would it be possible for the attendance report to include the user's custom fields?
I would like to inform you that your plugin creates a perturbation in the box "Drag files here" with Moodle 3.9.
Please take the full text of any errors you are seeing and report them to the issues tracker: https://github.com/danmarsden/moodle-mod_attendance/issues
Good morning, would there be any way that the information from the report exported to excel could be added more information about the student, such as their cell phone number?
@Julver - that's not soemthing that is currently supported.
2019112500, which we have installed in Moodle 3.8.3 has an issue with columns switching locations and text being obscured when the browser window is resized or the Moodle Drawer is expanded or collapsed. Video here: https://www.loom.com/share/42a025faf0cc44818ccf11ba837330ec and Image here: https://www.dropbox.com/s/mxq2jblgfo21pn2/Screenshot%202020-08-03%2014.28.07.png?dl=0