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

Is it possible to have view fields without storing into the database?

Subscribe

Get notified when there's activity on this post

This question has been flagged
fieldsdatabaseview
1 Reply
5858 Views
Avatar
Chris

I need to add a field in my saler order view and use the on_change function on that field, but I do not want to be a relationship between this view field and a data base field.

I just need this field to do some calculations,

thanks in advance for your help

regards. Naitsir

0
Avatar
Discard
Avatar
Zahin
Best Answer

OpenERP Functional field.

Functional field do calculation and you can make it store=False.

Also visit openerp documents.

def _compute_day(self, cr, uid, ids, context=None):
    ....
    .....
'day_open': fields.function(_compute_day, string='Days to Open', \
                                multi='day_open', type="float", store=False),

See more example in addons.

Hope with will be helpful to you.

:)

2
Avatar
Discard
Chris
Author

thanks for you help :)

I have another question, I hope you can help me. Is there a way to "add an item" on a view on the client? I mean, I have the sale order for and we can add products by click "add an item" link, I need a way to add items just click on a buttom.

in OpenERP 6.0 this is possible by creating a new sale.order.line using the "create" function. but in OpenERO 7.0 the all the "create" functions are executed at the moment of save the order. How can I do to add items?? should be generally for any item (not necessarlly for lines of a sale order) thank you in advance

Zahin

Sorry I am not getting, Please explore your problem with simple work or by posting images ?

Chris
Author

thanks, I created a new threat for this question :)

Sampath Kumar S

hii...Zahin I'm new to OpenERP and even I'm facing a similar problem, I need a add a image to my report which is not stored in my database can u please help me out...! Thanks in advance

Zahin

#Sampath: From URL image convert to base64 image then pass to report.

Sampath Kumar S

Hii.... Zahin i tried it but its not working the image is not getting printed

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
delete fields from database without uninstall? Solved
fields database
Avatar
Avatar
Avatar
Avatar
4
Dec 24
32555
Why in Selection Field Only Key is Store in Database Not the Value ? Solved
fields database selection
Avatar
Avatar
1
Dec 24
2598
v17: why Model is not created,
database view v17
Avatar
Avatar
1
Feb 24
2843
Wrong object when creating a dynamic view in OpenERP
views fields view
Avatar
Avatar
2
Sep 23
9390
Share custom field between sale order to invoice
fields database customize
Avatar
Avatar
1
Jul 19
5371
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