Can't get translated report

ERPNext Reports
1

hi all ,
I had created a custom query report , and there is some output that I need translated into another language .
the output not changed based on language that I used .

I need to find a way to translate the query response based on user default language.

2

@Rashed_Omar you have to put the text in translate function like this:

_(text)

3

inside the sql query !

4

no, you should do it after getting the data from the query.
but you have to import the function like this:

from frappe import _