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

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.



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-forum+un...@googlegroups.com.

To post to this group, send email to er...@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.

 

 

Column names for those fields are listed below:

Created By: owner
Modified By: modified_by


On 25-May-2013, at 8:54 AM, Addy wrote:

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.



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-forum+un…@googlegroups.com.

To post to this group, send email to er…@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.

 

 




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-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

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.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

1 Like
Thanks Nabin.


On Sat, May 25, 2013 at 10:56 AM, Nabin Hait <na...@gmail.com> wrote:
Column names for those fields are listed below:

Created By: owner
Modified By: modified_by


On 25-May-2013, at 8:54 AM, Addy wrote:

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.




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-forum+un…@googlegroups.com.

To post to this group, send email to er…@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.








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-forum+un…@googlegroups.com.

To post to this group, send email to er…@googlegroups.com.

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.

For more options, visit https://groups.google.com/groups/opt_out.








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-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/CAEmKBHzFsi0FBpnRiJba8O00_FfO3Bx7GAbFNNa%2B%2BEoDKL%3Dcdw%40mail.gmail.com?hl=en.

For more options, visit https://groups.google.com/groups/opt_out.