Issues Querying Table with name Containing Spaces

Frappe Framework Customization
1

Hi,

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.

Thanks

2

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`
or
`tabPayment Entry`.name

Hope this helps!

2 Likes
3

Thanks so much