Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

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

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

Print many2one field display "False" in odoo

Subscribe

Get notified when there's activity on this post

This question has been flagged
odooV8
6 Replies
522 Views
Avatar
Abdelwahed

Hi everybody!!!

Please, i have a many2one field defined like this:

'project_service' : fields.many2one('project_service', string= 'service'),


The problem is that when when i want to make print on this field i get "false" despite it was defined very well.

Is it empty or what please who can help

Thanks a lot in advance

-1
Avatar
Discard
scot77844

For a many2one field, if no value is selected, it will return False. If there is any value for it, it displays the id of the selected record at the print statement.

Solanki Shamji

I think syntax like 'project_service' : fields.many2one('project.service', string= 'service'), Try this one.

Avatar
Serpent Consulting Services Pvt. Ltd.
Best Answer

Abdelwahed,

You should first understand the important basics/conventions on Odoo/OpenERP.

When you use a many2one field,try doing this:

'project_service_id': fields.many2one('project.service', 'Service')

With whatever object/handle you print, are you sure you are browsing through the righ model and reaching to this field?

If this field has a value, then you must do this:

<YourObject>.project_service_id and <YourObject>.project_service_id.name or '' .

Hope this helps.

SerpentCS

(contact@serpentcs.com)


0
Avatar
Discard
Abdelwahed
Author

Thanks a lot you ave answered me ;) Look i have changed the field: 'project_service_id': fields.many2one ('project.service', string= 'Services'), An dwhen i want to print it i have done this: service = vals.get('project_service_id') print service

Serpent Consulting Services Pvt. Ltd.

Important thing is , where do you use it. You need a right container! If you use in create()/write() its vals! otherwise, its through object.

Avatar
Bole
Best Answer

first, i think that yur definition of a m2o field should be dot notated , not underscore... like:
'project_service': fields.many2one('project.service', string='service')

second... if that fields has no value (or it has Null value) it is interpreted as False. so in your report parser, you should check if the field value exists, and suggest some value for cases where it does not exist...

as noted in Tom's answer... in your report (rml or qweb) in part where you call a m2o field value 
(let's say it is o.project_service ) you should do something like:

if o.project_service != Null or o.project_service Is Not False:
    print o.project_service
else:
    print ''


to put it in short (pythonic form) jou can just write:

o.project_service and o.project_service or ''

(in human readable format it would read like: if there is a o.project_service value, write thta value othervise write '' or any other desired value/blank string...)

hope this will explain why and what you need to do in report:)

0
Avatar
Discard
Avatar
Tom
Best Answer

Hi,

I think you can ues the same example:

object.project_service and object.project_service.name or ''

0
Avatar
Discard
Abdelwahed
Author

thanks for the answer but i didnt understand you. in fact, why is my field.many2one is empty it returns False??

Enjoying the discussion? Don't just read, join in!

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

Sign up
Related Posts Replies Views Activity
CONFIGURACION DE CORREO PROPIO POR PRUMERA VEZ
odooV8
Avatar
0
Mar 25
2139
How to remove model if not in the py files anymore
odooV8
Avatar
0
Jan 25
4454
Start odoo server automatically in Ubuntu 14.04 on reboot Solved
odooV8
Avatar
Avatar
1
Aug 23
16080
change password Solved
odooV8
Avatar
Avatar
1
Aug 23
14743
Creating tables with %for and %endfor in email templates - Odoo is putting my loop outside the table, not inside.
odooV8
Avatar
Avatar
1
Jul 23
12011
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة 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 is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

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