"Field comparison" generates SQL that compares against the wrong field

Created on 18 November 2014, almost 10 years ago
Updated 11 June 2023, over 1 year ago

I created a view of my host nodes with a reference to the registration settings. I added two fields: slots total and spaces used.

When I add a "Global: Fields Comparison (capacity_used < capacity_total)" filter, I get no results returned and the WHERE clause in the SQL Views generates looks like this:

WHERE (node.nid < registration_entity_node.capacity)

I'm not sure why node.nid is being used instead of the capacity used, but that's definitely wrong.

πŸ› Bug report
Status

Closed: outdated

Version

1.0

Component

Registration Views

Created by

πŸ‡ΊπŸ‡ΈUnited States GuyPaddock

Live updates comments and jobs are added and updated live.
  • views

    Involves, uses, or integrates with views. In Drupal 8 core, use the β€œVDC” tag instead.

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.

Production build 0.71.5 2024