Closed (fixed)
Project:
Drupal core
Version:
8.0.x-dev
Component:
documentation
Priority:
Normal
Category:
Task
Assigned:
Issue tags:
Reporter:
Created:
15 Aug 2014 at 14:16 UTC
Updated:
2 Mar 2016 at 07:24 UTC
Jump to comment: Most recent, Most recent file
Comments
Comment #1
jhodgdonSome notes:
- in that other issue we're adding the ability to use 'left_field' instead of 'value' in "extra" in joins
- I do not think %alias works in "extra" in joins as documented in the Advanced help. Use 'left_field' instead.
Comment #2
jhodgdonHere's a patch. It is not actually true until #2218065: Need to join fields to the entity field data tables, not entity tables, or filtering increases number of results and its change adding the 'left_field' syntax to 'extra' gets in. I guess we could roll it into that other patch, but even if that never gets in we should I think document the rest.
Comment #6
jhodgdonHere's a new patch. Since no one reviewed this yet, I did not bother with an interdiff. I hope that's OK.
Comment #10
jhodgdonAmazingly enough, this patch still apparently applies. Would be nice to get a review sometime...
Comment #11
dawehnerLooks pretty solid for me.
Should we replace the 'extra' here with 'additional'?
Comment #12
jhodgdonSure. Fixed this in two places.
Uck. Due to patch fuzz, interdiff didn't work. Anyway I only changed two comments to say:
and everything else is the same.
Comment #13
dawehner+1 for the general part. What about adding an example how the resulting SQL query would look like then?
Comment #14
jhodgdonOK. The previous join stuff didn't have an example of the SQL, so I added that to both parts of the docs.
And... well this example doesn't work any more, because the base table for joining to nodes is now node_field_data, not node. So I made up a fictitious example instead.
And I noticed the comments on the first join information were saying 'node' but the join was to 'node_field_data' ... wasn't fully updated.
So there are a few diffs.
Comment #15
dawehnerGreat observation!
IMHO this is a good step forward, so let's get it in.
Comment #16
catchCommitted/pushed to 8.1.x and cherry-picked to 8.0.x. Thanks!