Two relations from content revisions to content look identical

Created on 24 December 2017, about 7 years ago
Updated 31 December 2024, 22 days ago

Problem/Motivation

Create a new view of "Content revisions", open the "Advanced" section, and Add a relationship.

Two of the options have title "Content", category "Content revision", and no description:

The two options are different: one joins on the content ID (nid) and the other joins on the revision ID (vid).

Proposed resolution

Add descriptions that distinguish between the two options:

  • Joining on the nid always gives some result, so add the description "Content associated to this revision".
  • Joining on the vid gives NULL except for the current revision, so add the description "Associated content for the current revision, NULL otherwise".

Remaining tasks

  • Review (wordsmith) the new text.

User interface changes

Change the "Add relationships" dialogue.

API changes

None

Data model changes

None

πŸ› Bug report
Status

Closed: outdated

Version

11.0 πŸ”₯

Component

user interface text

Created by

πŸ‡ΊπŸ‡ΈUnited States benjifisher Boston area

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • πŸ‡ΊπŸ‡ΈUnited States benjifisher Boston area

    I ran across this old issue while looking for something else.

    I am closing this issue as outdated. In πŸ“Œ Provide a relationship from the revision table to the main table Fixed , along with replacing the node-specific relationship with a more generic one, the labels were updated. Here is a screenshot:

    The description does not explain exactly what the difference is, but it is clear that these are two different options. With a little experimentation, anyone building a view should be able to figure out which one to use.

Production build 0.71.5 2024