taxonomy_select_nodes() no longer supports multiple terms [#607492]

taxonomy_select_nodes() would be a more useful API function if if supported the multi-term arguments from older versions of Drupal.

I'd like to see $tids = array(), $operator = 'or' restored to the arguments of the D7 version.

Issue fork drupal-607492

Show commands

Start within a Git clone of the project using the version control instructions.

Add & fetch this issue fork’s repository

Or, if you do not have SSH keys set up on git.drupalcode.org:

Add & fetch this issue fork’s repository

607492-taxonomyselectnodes-no-longer compare
Check out this branch

About issue forks

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

jweowu CreditAttribution: jweowu commented 18 October 2009 at 00:33

I'm struggling with the new DB abstraction with this one. Perhaps someone more knowledgeable could have a look?

It seems that $query = db_select('taxonomy_index', 't'); in taxonomy_select_nodes() creates a SelectQuery object, and the constructor for that explicitly sets the conjunction for its DatabaseCondition to 'AND' with $this->where = new DatabaseCondition('AND');

So although we could call $query->condition('tid', $tid); repeatedly for multiple term IDs, we'd need the conjunction to be 'OR' for it to return any values (as no row in the taxonomy_index table can have multiple different terms).

I don't see any API for replacing the DatabaseCondition (SelectQuery's private property $where) with another one with a different conjunction.

At this point, I'm wanting to resort to a normal SQL query to do this, so some help would be much appreciated.