How to Show image in datalist?

3 answers

1.  

   1

   0

   -1

   • Matthew King
   • Aug 06, 2020

   Hi Zhen Jian Toh
   Check out Image Datalist Formatter from Joget Marketplace.

   •  Comment

   CommentAdd your comment...
2.  

   1

   0

   -1

   • iman maryadi
   • Oct 12, 2016

   hi matthew king,

   thanks for your answer, i'm to try this solution. 

   •  Comment

   CommentAdd your comment...
3.  

   1

   0

   -1

   • Matthew King
   • Oct 07, 2016

   Hi Iman Maryadi

   In Datalist>Source>Configure JDBC Datalist Binder, you can compose the SQL query example below (for MySQL) to display images in datalist listing, do ensure you tick "Yes" in column properties for "Render value as HTML". Do ensure that the:

   1. Path to the image download folder is correct
   2. The "fieldId" storing the image's filename is correct, example  "c_Picture"
   3. Size the image height and width accordingly
   4. If the image needs to be a clickable link, add the required <a> tag in the CONCAT query
   5. Do amend to suit your database brand (SQL Server, Oracle etc.)

   SELECT CONCAT("<img src='/jw/web/client/app/MyApp/latest/form/download/MyApp/",id,"/",c_Picture,".' height='100' width='100' align='middle' alt='",c_Desc,"'>","<br/>","<b>",c_AppName) AS AppName,

   FROM app_fd_MyApp;

   •  Comment

   1. Zhen Jian Toh

      • Aug 06, 2020

      Hi Matthew, I try the code but it still shows error Fail to retrieve column list. Please check your configuration.

   CommentAdd your comment...