How to download or open attachments from Iview

How to download or open attachments from Iview

Files or images attached in a transaction can be viewed through iview hyperlink

It uses two columns to achieve the functionality.

  1. Column1  –  display the hyperlink  ( it’s the regular iview column. Eg: Attachment as column name)
  2. Column2   –  have path and file details (column name should be as  first ColumnName_hlink (eg:  Attachment_hlink)

Note: There is no specific order in the columns. They can appear anywhere.

Attachment_hlink can have below details.

  1. @r:=  -> Recordid
  2. @p:=  -> Pathname
  3. @t:=  -> Tablename
  4. @f:=  -> Filename

If defined as image field that is storing as blob in table, use like @r=:recordid@t:tablename

If defined as image field along with AxpImagePath variable, use like @r:=recordid@p:=pathname

If defined as grid attachment with dcname_image along with AxpImagePath variable, use @r:=recordid@p:=pathname@f:=list of files(comma separated) 

If defined as grid attachment with dcname_image along with dcname_imagepath,  use @p:=pathname@f:=filename

Multiple details can be given as ‘^’ separated string.

Eg:

@p=e:axpertimg\details\cust\sup\item @f=file1.bmp,file2.txt ^@p=e:\axpertimg\product\cust\sup\item @f=pfile1.bmp, pfile2.doc