| commit | 92c768972ff4cdce051328b1c66a8ff10bff5168 | [log] [tgz] |
|---|---|---|
| author | Hussain Nagaria <hussainbhaitech@gmail.com> | Wed Mar 31 12:26:37 2021 +0530 |
| committer | Hussain Nagaria <hussainbhaitech@gmail.com> | Wed Mar 31 12:26:37 2021 +0530 |
| tree | dd375b637394e826205e98db44f7219535de38b3 | |
| parent | f5576d67dd4723d5f8be4aa83aa6a70174ccd2f5 [diff] |
fix: Missing quotation marks in SQL query
diff --git a/erpnext/projects/report/employee_hours_utilisation_based_on_timesheet/employee_hours_utilisation_based_on_timesheet.py b/erpnext/projects/report/employee_hours_utilisation_based_on_timesheet/employee_hours_utilisation_based_on_timesheet.py index 702c85a..e3d6b9b 100644 --- a/erpnext/projects/report/employee_hours_utilisation_based_on_timesheet/employee_hours_utilisation_based_on_timesheet.py +++ b/erpnext/projects/report/employee_hours_utilisation_based_on_timesheet/employee_hours_utilisation_based_on_timesheet.py
@@ -91,10 +91,10 @@ additional_filters = '' if self.filters.employee: - additional_filters += f'AND tt.employee = {self.filters.employee}' + additional_filters += f"AND tt.employee = '{self.filters.employee}'" if self.filters.project: - additional_filters += f'AND ttd.project = {self.filters.project}' + additional_filters += f"AND ttd.project = '{self.filters.project}'" self.filtered_time_logs = frappe.db.sql(''' SELECT tt.employee AS employee, ttd.hours AS hours, ttd.billable AS billable, ttd.project AS project