First off: this is a neat module. I was anxious when starting to search "Drupal Views Pivot", about what I'd find and how deep a rabbit hole it would end me up in... but after

  • dowloading and enabling this one
  • Seeing the new "Crosstab table" format and checking / tweaking some settings
  • ..and then enabling "Show SQL query" in the Views settings and checking the preview output for a doublecheck...

I thought: A-ha! Now I get it, and this is exactly what I need. (Unlike the Views Pivot module which I'm sure is great for some other use cases but I didn't "get it" so far.)

However...

My query doesn't have just 3 fields. (Imagine the query on the module page, where the user is not just one field, but has a first name, last name and department field.) But... all those extra fields show up as columns, but the cells (query results) are completely empty.

After some debugging, that turns out to be easy to fix. Views skips those fields because 'aggregate' is set, and IMHO it shouldn't be. (While I'm sure I don't have a full overview of the kinds of queries this should support... I can't imagine this being necessary.)

CommentFileSizeAuthor
#2 3173306-2.patch533 bytesroderik

Comments

roderik created an issue. See original summary.

roderik’s picture

Status: Active » Needs review
StatusFileSize
new533 bytes