I applied this on my grafana query when I select multiple / All on the status field then I face this problem Query failed. Please inspect the Grafana server log for details
IF ( $status = ‘Present’ ) THEN
Call usp_HeadOfficeAttendance("{designation:csv}" ,"{employment_type:csv}" ,"{branch_name:csv}" ,"{department_name:csv}","{pick_date:csv}", "{status:csv}");
ELSEIF (($status = ‘Absent’) OR ($status = ‘On Leave’)) THEN
Call usp_HeadOfficeDailyAbsentLeave("{designation:csv}" ,"{employment_type:csv}" ,"{branch_name:csv}" ,"{department_name:csv}","{pick_date:csv}", "{status:csv}");
ELSE
Call usp_HeadOfficeAttendance("{designation:csv}" ,"{employment_type:csv}" ,"{branch_name:csv}" ,"{department_name:csv}","{pick_date:csv}", "{status:csv}");
END IF;