Clarity

Expand all | Collapse all

How to pull attachment attribute in query.

  • 1.  How to pull attachment attribute in query.

    Posted 10-24-2016 03:03 AM

    Hello All,

    I created a attachment attribute on Project Object. How to pull attachment attribute in SQL Query?

    Regards,
    Santosh.



  • 2.  Re: How to pull attachment attribute in query.

    Posted 10-24-2016 03:23 AM


  • 3.  Re: How to pull attachment attribute in query.

    Posted 10-26-2016 03:18 AM

    Hello,

     

    Can we access Clarity Filesystem? In the Link CA Clarity Tuesday Tip: Attachment Attribute  it was given an example on Test file.
    The files will be stored either in a filestore or in Clarity database depending on what is configured in NSA/CSA,for instance if the Image is stored in    niku/clarity/filestore/files/ can we access this Image and can I show it in Jasper report?

    Regards,
    Santosh



  • 4.  Re: How to pull attachment attribute in query.

    Posted 10-27-2016 02:56 AM

    Hi Santosh,

     

    If you are running ondemand you can create a ticket and request sftp access to the filestore. Regarding Jaspersoft I do not know how the files are store there but my guess will be that you must upload the image file to Jaspersoft repository before you can use it in reports.

     

    BR

    Davor



  • 5.  Re: How to pull attachment attribute in query.

    Posted 10-27-2016 03:19 AM

    Thanks a lot Davor.