Skip to Content
This question has been flagged
attachmentimageurlbinaryfield
3 Replies
22520 Views
Avatar
Bienvenido Villabroza

I am using Odoo 13 and I have a file stored in a fields.Binary with attachment=True (Odoo's default value). How do I obtain the url to that file given a record? I want to store the url to a computed fields.Html so that I can display it on my form view.
This is the code I have at the moment in my py file (models):

class Image(models.Model):
    def _get_image_html(self):
        for elem in self:
            image_url = self.env['ir.attachment'].search([('res_id', '=', str(self.image))], limit=1).url
            elem.image_loc = '<img src="%s"/>' % image_url

    image = fields.Binary(string="Image")
    image_loc = fields.Html(string='Preview 2', compute="_get_image_html")


So far, my code has only been returning a link to /False.

Any help with be much appreciated.

Avatar
Discard
Avatar
Sudhir Arya (ERP Harbor Consulting Services)
Best Answer

Odoo does not store the URL for the attachments stored at the physical location (filestore).
But there is a way to create a URL to show the image in the report/website based on the attachment record.

Ex:

attachment = self.env['ir.attachment'].search([('res_model', '=', 'my.custom_model'), ('res_id', '=', self.id)], limit=1)

img_url = "/web/image/ir.attachment/%s/datas" % attachment.id

# For website/report
<img t-att-src="/web/image/ir.attachment/attachment.id/datas"/>
Avatar
Discard
Bienvenido Villabroza
Author

Thank you for the response. However, I do not know why but it keeps returning False: 127.0.0.1:8069/web/image/ir.attachment/False/datas

This is what my actual model looks like:

class Image(models.Model):

_name = 'gov_bene_phils.sss_image'

def _get_image_html(self):

for elem in self:

attachment = self.env['ir.attachment'].search(

[('res_model', '=', 'gov_bene_phils.sss_image'),

('res_id', '=', self.id)], limit=1

)

image_url = "/web/image/ir.attachment/%s/datas" % attachment.id

image = fields.Binary(string="Image")

image_loc = fields.Html(string='Preview 2', compute="_get_image_html")

In my xml file, I just place it in my form view with <field name="image_loc" />

* I have other attributes for the gov_bene_phils.sss_image model but they do not have anything to do with the document being attached. Any thoughts on what's wrong with my code?

Avatar
Ravi Gadhia
Best Answer

If your aim is to dispaly image on view, then there is no need to declare other field(image_loc) to privew it 

in model

    image = fields.Binary(string="Image")

in view(XML) define it with widget="image" like

<field name="image" widget="image"/>


Avatar
Discard
Bienvenido Villabroza
Author

That works for images and I have tried that. However, I also want to embed a pdf as well. I will eventually change the img tag to embed to make it work. I also tried the following code:

self.env['ir.attachment'].search(

[('res_model', '=', 'my.custom_model'),

('res_id', '=', self.id)], limit=1

).url

It keeps returning http://127.0.0.1:8069/False

I'm not sure how to manipulate the ir.attachment model properly.

Related Posts Replies Views Activity
How to search attachment with orm?
attachment image
Avatar
0
Mar 25
234
TypeError: Cannot read properties of undefined (reading 'url')
image url
Avatar
Avatar
Avatar
2
Jul 22
11104
Moving database to other server - some website images do not display
image move url
Avatar
Avatar
2
Jul 23
2867
migrate binary field to attachment when attachment=True added later in field Solved
attachment binaryfield v10.0
Avatar
Avatar
1
Jul 22
19247
Contact image via url Solved
image url odoo11.0
Avatar
Avatar
Avatar
2
Sep 21
7651