SQL Queries in csv Spanish translation

ERPNext
1

I am testing healthcare domain,

I have an error when I use the spanish language and I found 2 SQL sentences that are translated.

I think this issue is happenning in some csv files, like spanish (In translate.erpnext.com I search “select” and 3 queries are translated).

select * from tabVital Signs where patient=‘{0}’ order by signs_date desc limit 1

is translated by

seleccione * de ‘tabVital Signs` donde patient =’ {0} 'ordenar por signs_date desc limit 1

select * from tabPatient where name=‘{0}’

by

seleccione * de tabPatient donde name = ‘{0}’

select cp.name, cp.test_code, cp.parent, cp.invoice, ct.physician, ct.consultation_date from tabConsultation ct, tabLab Prescription cp where ct.patient=‘{0}’ and cp.parent=ct.name and cp.test_created=0

by

seleccione cp.name, cp.test_code, cp.parent, cp.invoice, ct.physician, ct.consultation_date de tabConsultation ct, tabLab Prescription cp donde ct.patient = ‘{0}’ y cp.parent = ct. nombre y cp.test_created = 0

I wanted to delete those verified translations but I dont have enough “Karma” in the erpnext.translate page. I made an issue Spanish Translation. · Issue #11194 · frappe/erpnext · GitHub ,

I am very noob at this. Let me know if this is the correct way to proceed.
regards.

2

searching queries like UPDATE I found others.

update tabConsultation set invoice=‘{0}’ where name=‘{1}’

by

update tabConsultation set invoice = ‘{0}’ donde nombre = ‘{1}’

update tabPatient Appointment set sales_invoice=‘{0}’ where name=‘{1}’

by

update tabPatient Appointment set sales_invoice = ‘{0}’ donde nombre = ‘{1}’