Odoo Help


How to get the values of the drop down list using fetchone from database using postgresql query

Mashuk Khan
on 12/1/15, 1:23 AM 1,409 views

How to get the values of the drop-down list using fetchone from database using PostgreSQL query, something like JSON parsing? And show the fetched data in a different field or in a list. 

Axel Mendoza
On 12/1/15, 3:48 PM

Hi @Mashuk Khan

You could do it like this:

import simplejson
    def get_list(self, cr):
        cr. execute('select field_json from table where ...')
result = cr.fetchone()
data = simplejson.loads(result)
return data.items()

    json_list = fields.Selection(selection='get_list')

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


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

2 follower(s)


Asked: 12/1/15, 1:23 AM
Seen: 1409 times
Last updated: 12/13/15, 3:10 AM