How to access the Created By and Last Updated By Fields in Query Report for a Table?

[Addy]

Hi,

I tried to access the above mentioned fields by using this command in the query report:

`tabProduction Order`.created_by as "Created::200"

and I was presented with this error:

 OperationalError: (1054, "Unknown column 'tabProduction Order.created_by' in 'field list'")

Showing that the column is not there in the table and as we all know this is there but somehow I am unable to find the name of the field defined. Could someone please let me know how could I add the created by field in my query reports.

[Nabin Hait]

Column names for those fields are listed below:

Created By: owner

Modified By: modified_by

--
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer...@googlegroups.com.
To post to this group, send email to erpnext-dev...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/aa648bae-2a11-4156-af94-607e852de2f9%40googlegroups.com?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Aditya Duggal]

Thanks Nabin.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/B4CA5334-8544-4B05-A584-61F6BE7C4C09%40gmail.com?hl=en.