Serial Number is not visible in Query Report

ERPNext
1

Hello,

image

How to add column name serial number in query report.

Below is my Query.

SELECT employee as "Employee ID:Link/Employee:200", employee_name as "Employee Name:Data:200", time as "Date and Time:Datetime:200"
FROM `tabEmployee Checkin`
WHERE DATE(time) = DATE(NOW()) 
GROUP BY employee
2

try this

SELECT 
    ROW_NUMBER() OVER (ORDER BY checkin_time) as `Serial Number`,
    employee as `Employee ID:Link/Employee:200`, 
    employee_name as `Employee Name:Data:200`, 
    checkin_time as `Date and Time:Datetime:200`
FROM `tabEmployee Checkin`
WHERE DATE(checkin_time) = DATE(NOW()) 
GROUP BY employee
ORDER BY checkin_time;
1 Like