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

aditya2 · May 25, 2013, 3:24am

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.

nabinhait · May 25, 2013, 5:26am

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.

aditya2 · May 25, 2013, 5:56am

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.