Odoo Help

1
1
Muniswaran
On 12/6/18, 8:41 AM

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))

1
Sehrish
On 12/6/18, 11:30 PM

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)+""")
"""


About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)

Stats

Asked: 12/6/18, 6:56 AM
Seen: 88 times
Last updated: 12/7/18, 5:25 AM