Skip to Content
Odoo Menu
  • Log ind
  • Prøv gratis
  • Apps
    Økonomi
    • Bogføring
    • Fakturering
    • Udgifter
    • Regneark (BI)
    • Dokumenter
    • e-Signatur
    Salg
    • CRM
    • Salg
    • POS Butik
    • POS Restaurant
    • Abonnementer
    • Udlejning
    Hjemmeside
    • Hjemmesidebygger
    • e-Handel
    • Blog
    • Forum
    • LiveChat
    • e-Læring
    Forsyningskæde
    • Lagerbeholdning
    • Produktion
    • PLM
    • Indkøb
    • Vedligeholdelse
    • Kvalitet
    HR
    • Medarbejdere
    • Rekruttering
    • Fravær
    • Medarbejdersamtaler
    • Anbefalinger
    • Flåde
    Marketing
    • Markedsføring på sociale medier
    • E-mailmarketing
    • SMS-marketing
    • Arrangementer
    • Automatiseret marketing
    • Spørgeundersøgelser
    Tjenester
    • Projekt
    • Timesedler
    • Udkørende Service
    • Kundeservice
    • Planlægning
    • Aftaler
    Produktivitet
    • Dialog
    • Godkendelser
    • IoT
    • VoIP
    • Vidensdeling
    • WhatsApp
    Tredjepartsapps Odoo Studio Odoo Cloud-platform
  • Brancher
    Detailhandel
    • Boghandel
    • Tøjforretning
    • Møbelforretning
    • Dagligvarebutik
    • Byggemarked
    • Legetøjsforretning
    Mad og værtsskab
    • Bar og pub
    • Restaurant
    • Fastfood
    • Gæstehus
    • Drikkevareforhandler
    • Hotel
    Ejendom
    • Ejendomsmægler
    • Arkitektfirma
    • Byggeri
    • Ejendomsadministration
    • Havearbejde
    • Boligejerforening
    Rådgivning
    • Regnskabsfirma
    • Odoo-partner
    • Marketingbureau
    • Advokatfirma
    • Rekruttering
    • Audit & certificering
    Produktion
    • Tekstil
    • Metal
    • Møbler
    • Fødevareproduktion
    • Bryggeri
    • Firmagave
    Heldbred & Fitness
    • Sportsklub
    • Optiker
    • Fitnesscenter
    • Kosmetolog
    • Apotek
    • Frisør
    Håndværk
    • Handyman
    • IT-hardware og support
    • Solenergisystemer
    • Skomager
    • Rengøringsservicer
    • VVS- og ventilationsservice
    Andet
    • Nonprofitorganisation
    • Miljøagentur
    • Udlejning af billboards
    • Fotografi
    • Cykeludlejning
    • Softwareforhandler
    Gennemse alle brancher
  • Community
    Få mere at vide
    • Tutorials
    • Dokumentation
    • Certificeringer
    • Oplæring
    • Blog
    • Podcast
    Bliv klogere
    • Udannelselsesprogram
    • Scale Up!-virksomhedsspillet
    • Besøg Odoo
    Få softwaren
    • Download
    • Sammenlign versioner
    • Udgaver
    Samarbejde
    • Github
    • Forum
    • Arrangementer
    • Oversættelser
    • Bliv partner
    • Tjenester til partnere
    • Registrér dit regnskabsfirma
    Modtag tjenester
    • Find en partner
    • Find en bogholder
    • Kontakt en rådgiver
    • Implementeringstjenester
    • Kundereferencer
    • Support
    • Opgraderinger
    Github Youtube Twitter LinkedIn Instagram Facebook Spotify
    +1 (650) 691-3277
    Få en demo
  • Prissætning
  • Hjælp

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Bogføring
  • Lager
  • PoS
  • Projekt
  • MRP
All apps
Du skal være registreret for at interagere med fællesskabet.
All Posts People Emblemer
Tags (View all)
odoo accounting v14 pos v15
Om dette forum
Du skal være registreret for at interagere med fællesskabet.
All Posts People Emblemer
Tags (View all)
odoo accounting v14 pos v15
Om dette forum
Hjælp

How to display many2one fields within form view

Tilmeld

Få besked, når der er aktivitet på dette indlæg

Dette spørgsmål er blevet anmeldt
viewone2manyv7mergepurchase_order
8 Besvarelser
17819 Visninger
Avatar
xiaolong97427

Hi,

I have the field:

'merged_porder_id' : fields.many2one('purchase.order', 'purchase_id'),

And display this field with:

<field name="merged_porder_id"/>

How can I tell the system that I want to input several values ? The UI control is a simple Textbox, do the user have to separate the Purchase_id by some separator ? if yes which one ?

1
Avatar
Kassér
Vasiliy Birukov

May be you need "fields.one2many" ?

Avatar
Andreas Brueckl
Bedste svar

If you want to attach more than one purchase order you have to use a field of type many2many or one2many.

The difference is:

  • If you use many2many then every purchase order can be assigned more than once in the field merged_porder_id. A separate relation table is used in the background.
  • If you use one2many then every purchase order can only be assigned to one field merged_porder_id. In this case you also have to create a many2one field in the purchase order for the relation to the model of field merged_porder_id.
1
Avatar
Kassér
xiaolong97427
Forfatter

Thank you for your comment, makes more clear the way the design the relation. Therefore I added a one2many: 'sourceOfMerged' : fields.many2one('purchase.order', 'purchase_id'). Trying to display it with <field name="syongOne2Many"> <tree string="Notes" editable="bottom"> <field name="name"/> </tree> </field>, I have an error : ProgrammingError: operator does not exist: character varying = integer LINE 1: ...M "purchase_order" WHERE ("purchase_order"."name" in (16)) O...

xiaolong97427
Forfatter

Full error message: ProgrammingError: operator does not exist: character varying = integer LINE 1: ...M "purchase_order" WHERE ("purchase_order"."name" in (16)) O... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

Andreas Brueckl

in model purchase.order you need a many2one field and in your new model needs a one2many field

xiaolong97427
Forfatter

I created both field: one2many and many2one on PurchaseOrder. Andreas you mean I should create another object for instance: MergedFrom, and this object would contains the one2many field ?

Andreas Brueckl

See have the relation between purchase.order and purchase.order.line is handled here: http://bazaar.launchpad.net/~openerp/openobject-addons/trunk/view/head:/purchase/purchase.py

Avatar
subbarao
Bedste svar

Many2many field better for this.

0
Avatar
Kassér
Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Tilmeld dig
Related Posts Besvarelser Visninger Aktivitet
forbid addition in one2many widget but permit edition of lines Løst
view one2many v7
Avatar
Avatar
Avatar
2
maj 24
9913
How to include origin RFQ doc into merged PO PDF
v7 merge purchase_order
Avatar
0
mar. 15
5343
How to merge identical quotation order lines when merging purchase orders (through the scheduler)? Løst
scheduler v7 merge purchase_order
Avatar
1
mar. 15
12200
How to open the record form when clicking on one2many tree line?
development view one2many v7 tree
Avatar
Avatar
1
jan. 16
15602
How To: Add Internal Reference (code) on purchase orders Løst
v7 purchase_order
Avatar
Avatar
Avatar
Avatar
3
apr. 24
16401
Community
  • Tutorials
  • Dokumentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Oversættelser
Tjenester
  • Odoo.sh-hosting
  • Support
  • Opgradere
  • Individuelt tilpasset udvikling
  • Uddannelse
  • Find en bogholder
  • Find en partner
  • Bliv partner
Om os
  • Vores virksomhed
  • Brandaktiver
  • Kontakt os
  • Stillinger
  • Arrangementer
  • Podcast
  • Blog
  • Kunder
  • Juridiske dokumenter • Privatlivspolitik
  • Sikkerhedspolitik
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo er en samling open source-forretningsapps, der dækker alle dine virksomhedsbehov – lige fra CRM, e-handel og bogføring til lagerstyring, POS, projektledelse og meget mere.

Det unikke ved Odoo er, at systemet både er brugervenligt og fuldt integreret.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now