Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
i want to check the value of jobsheet field with database. When i run my code it gives syntax errors
self._cr.execute("""
CREATE OR REPLACE VIEW jobsheet_overview AS (
SELECT
row_number() over (ORDER BY move.name) AS id,
move.name as product,
move.product_uom_qty as quantity,
pick.id as picking_id
from stock_move move,stock_picking pick where move.picking_id = pick.id and pick.jobsheet_no=%s)""",(self.jobsheet))
it says "%s" syntax is not correct
Hi Mike
in that last you should pass value as %(self.jobsheet) below i corrected
self._cr.execute("""
CREATE OR REPLACE VIEW jobsheet_overview AS (
SELECT
row_number() over (ORDER BY move.name) AS id,
move.name as product,
move.product_uom_qty as quantity,
pick.id as picking_id
from stock_move move,stock_picking pick where move.picking_id = pick.id and pick.jobsheet_no=%s)""" %(self.jobsheet))
Try this one
self._cr.execute("""
CREATE OR REPLACE VIEW jobsheet_overview AS (
SELECT
row_number() over (ORDER BY move.name) AS id,
move.name as product,
move.product_uom_qty as quantity,
pick.id as picking_id
from stock_move move,stock_picking pick where move.picking_id = pick.id and pick.jobsheet_no="""+str(self.jobsheet)+""")
"""
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
