Within views, when you setup a relationship that uses a multi-valued field, you can set the "delta" to make the relationship match on an item in a particular position, or you can set the "delta" to "All" to match on an item regardless of position. This is awesome. It would be cool if this delta dropdown also allowed matching on the "last" position, "second to last" position, etc. Perhaps something like adding "-1" .. "-n" options to the dropdown.

While I first noticed the "delta" feature for relationships, I'm guessing it exists elsewhere within views integration as well, and adding this negative feature to those places as well would be sweet.

Comments

yched’s picture

yched commented

Note that this 'select delta to use for relationship' feature is the only workaround we could find to prevent lots of duplicates when using 'use all deltas'.
I'd be surprised if there was an easy way to do 'use greater delta available' 'or use greater -3', because it means the JOIN for the relationship would need to vary node by node.

I'll let markus chime, but for me it's a 'by design'

markus_petrux’s picture

markus_petrux commented
Status: Active » Closed (works as designed)

Agreed. I think this is not easily doable from a relationship handler.

@effulgentsia: If you can figure out how it can be done with pure SQL, we would also need to know if this can be applied to a relationship handler. Meanwhile, I also would say "by design".