Question

Adding an image stored in database to an operational report

  • 9 June 2020
  • 2 replies
  • 408 views

Userlevel 2
Badge +3

Hi,

Can someone guide me on how to use an image stored in the database table in an operational report?
I have stored the image as a blob in the database.

And I was trying to fetch the image using a select statement.


But, it is not showing the image even though it shows the value of the string when trying to preview the report.

Therefore, any idea on how can we call an image stored in the database in the report?

Regards,

Sachinthani.


2 replies

Badge +1

Hi Sachinthani,

IFS does not use tables directly. You should use Views.

CREATE OR REPLACE VIEW WQ_COMPANY_LOGO_VW AS
SELECT COMPANY_ID,
       STAMP,
       IDENTITY_LABEL
  FROM WQ_COMPANY_LOGO
  WITH   READ ONLY;
COMMENT ON TABLE WQ_COMPANY_LOGO_VW  IS 'LU=SomethingUtil^PROMPT=Something All Media^MODULE=SMTHG^';
GRANT SELECT ON WQ_COMPANY_LOGO_VW TO "IFSSYS";

 

Sql Query Statement: SELECT STAMP FROM WQ_COMPANY_LOGO_VW WHERE COMPANY_ID=:1

Userlevel 2
Badge +5

Hi Sachinthani,

 

Maybe this can help you, I am not sure if you mean just one image on a specific report or a logotype...

 

Br

Karolina

Reply