ERPNext Foundation ERPNext Cloud User Manual Blog Discuss Frappé* Donate

Issues Querying Table with name Containing Spaces




I am having issues with simple SQL Statement where we have spaces in the names.

For Example “tabPayment Entry”, “tabStock Entry”.

I am currently running my script in terminal.

Any help who encounterd this.



Hi @mahima98,
When you want to query a table who contain spaces, you need to use backtick ` (not the same thing as: ’ )
so your query would look like this:

`tabPayment Entry`
`tabPayment Entry`.name

Hope this helps!