SQL Query Report contains Columns which are of Image Attachments Data Type hence not VIEWABLE

ERPNext Reports
1

Dear Awesome Team,

I have written a sql query to give access to Image Attachments to particular User ONLY.
Results is very simple but Image Attachments are not VIEWABLE and we can see the mere LINKS in the Columns in the sql query results.

image
image1077Ă—628 66.6 KB

How we shall access those ATTACHMENTS as well in the SQL Query Report?

Best Regards.

1 Like
2

Can you see TWO columns - BANK NOC and AADHAR, these files are not VIEWABLE/Clickable

3

image view is not possible in any report view but maybe, clickable is possible.

Please check the example, here we make clickable link for image.

SELECT 
    name, 
    CONCAT('<a href="', image, '" target="_blank">', image, '</a>') AS 'Image::500'
FROM 
    `tabItem`

image
image1758Ă—486 54.5 KB

4

Can you pls provide your advise in this query.
select name as “1. PI No”, supplier as “2. Seller”, posting_date as “3. Pur Date”, custom_bank_noc_proof as “4. Bank NOC”, custom_aadhar_card “5. Aadhar”, custom_tto_form “6. TTO”, custom_rc_book “7. RC”, custom_pan_card “8. PAN”, custom_insurance “9. Insurance” from tabPurchase Invoice

custom_bank_noc_proof is one such column with image data type, how shall I make the image clickable. ?

Pls thanks so much

5 
CONCAT('<a href="', custom_bank_noc_proof, '" target="_blank">', custom_bank_noc_proof, '</a>') AS "4. Bank NOC",

Follow the example I provided. If you don’t understand, create a new query report, paste the same query, and check how it works.

3 Likes
6

@NCP Awesome thanks so much, it worked