File upload fields can be added to report, but just display "File upload"

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Create a transaction with a document that as file upload field
2. Map the file upload field to a report field.
3. Run a report that uses that report field.

What is the expected output? What do you see instead?
We should see a report where you can click to see the files actually upload. 
Instead, it just says "File upload" in the column.

If file upload fields are not supposed to be part of the report, then they 
should be filtered out so they cannot be mapped to a report field. Otherwise, 
suggest we allow it to be a special field where the user is given the option to 
view the attached files right from the report.

Bug note: In mapping a File Upload field to a report field, it currently is 
mapping to a General (string) report field type, which is not right.

Original issue reported on code.google.com by yoz...@gmail.com on 18 Feb 2012 at 12:24

[GoogleCodeExporter]

This will require a new report field type and DB table to support it since it 
can have multiple values that are all TransactionFile objects.

Original comment by yoz...@gmail.com on 19 Feb 2012 at 1:05

• Changed state: Started
• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

If you have already mapping a File field to a report field, let us know and we 
can help. Basically, you need to remove the mapping from the package and the 
report field from any reports since the report field created is of type 
"General", suitable for strings, but not for a list of uploaded files.  

Then, in the DB, we need to remove the offending report field from the 
esf_report_field_template (or you can just update it's field_type from 'S' to 
'F'). 

Then with the new 12.3.* release, re-create the mapping and add back to your 
reports.

Original comment by yoz...@gmail.com on 20 Feb 2012 at 8:17

• Changed state: Fixed
• Added labels: ****
• Removed labels: ****