Product
| Applies To | |||
| Product(s): | eB Information Manager | ||
| Version(s): | 16.x.x | ||
| Environment: | N/A | ||
| Area: | Report | ||
| Subarea: | FTR | ||
| Original Author: | Dennis Chan, Bentley Product Advantage Team |
Problem Description:
User gets the following error when a report is run (in either eBweb or Director):
- The multi-part identifier "j12t0.pdm_file_id" could not be bound.
Cause:
Most likely the FTR (Document -> Fields -> Relationship -> Files -> FTR) field has been used as one of the search criteria (in the WHERE clause). The 'FTR' syntax was kept for backwards compatibility but should be considered obsolete.
Solution:
Use the Files.ContentData field (Document -> Fields -> Relationship -> ContentData) instead..
Workaround:
N/A