Table name of custom DocType for Query Report

Ashton_Anchors · February 24, 2021, 5:17pm

How do I know the table name of my custom DocType Type? When I use the DocType name as table name, I get error. I tested with a simple query like below.

select tabSales.invoice as “Invoice::120”
from tabSales

smino · February 24, 2021, 5:30pm

bench mariadb , then show tables; Will list all the tables.

Ashton_Anchors · February 24, 2021, 10:11pm

thanks… apparently, i have set mine in docker. i am looking at moving it to the bench. still searching how.

Ashton_Anchors · February 26, 2021, 8:22am

So I managed to find the table and it is there, but i couldnt still get it to work. what am i missing

Here is my simple query

and here is the result when I click Show Report above.

smino · February 27, 2021, 1:39am

What column in ‘tabSales Invoice’ are you trying to SELECT? There are a number of tables in ERPNect with the name tabSales , none simply tabSales.

This may help: https://mariadb.com/kb/en/getting-data-from-mariadb/

Ashton_Anchors · February 27, 2021, 7:08am

Thanks for your reply. I was able to make it work. I noticed, it was my custom Module. I joined my tabSales table with tabEmployee and used HR module in my query report and that did the trick. Not sure why my custom module keeps giving my the Server Error.

here is my working query report

kimz03 · July 9, 2024, 12:11pm

hi how do you move to bench?