I have a Query tag to output Matrix data for various entries. One of the Matrix fields is an Assets field, which is linked to files stored on Amazon S3.
Within the Assets database, this fields data does not hold the full Amazon S3 path. This path seems to be stored within a JSON encoded array in the field Settings in exp_assets_sources.
So therefore I am stuck as to how to get the full S3 path within my Query to link to the Amazon file. Anyone know?