The file_usage table has no join coupling to file_managed.

One negative consequence is that in the File entity module, where we add the type field to the entity file, we cannot use file usage relationships in Views because of the error "Integrity constraint violation: Column 'type' in field list is ambiguous".

CommentFileSizeAuthor
#1 join_file_usage_to-2316989-1.patch636 bytesArla
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Arla’s picture

Status: Needs work » Needs review
FileSize
636 bytes

Like this.

dawehner’s picture

Status: Needs review » Reviewed & tested by the community
Issue tags: +VDC

Perfect!

alexpott’s picture

Status: Reviewed & tested by the community » Fixed

Committed 8ca9d2a and pushed to 8.0.x. Thanks!

  • alexpott committed 8ca9d2a on 8.0.x
    Issue #2316989 by Arla: Fixed Join file_usage to file_managed for Views.
    

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.