I'd like to add an entry for the table name at which an order was served in the 'Orders Analysis' table report. This will be in addition to the existing categories available, like product name, point of sale, company name, etc.
Can someone give me a clue as to how to go about doing this?
What I've found so far: pos_order.table_id has the table info; I just need this data in the view.
addons/point_of_sale/report/pos_order_report.py has the necessary code, but I can't figure out how to make the changes I need. I'm getting some programmingerror errors when I try something. Any clues will be appreciated.
Please send your code and error .
Changes I've made to try this out:
http://pastebin.com/0nbkxfCy
Errors I'm getting:
http://pastebin.com/Smtn82ej
2nd error:
http://pastebin.com/123KHPih
The 2nd error pops up when I press 'OK' on the 1st one.
Note that I only want the view to change, not the databases. I think what my changes are doing are trying to modify the db itself? That's not the effect I want. My python and postgresql skills are pretty basic, so I can't say what I'm doing wrong.