Avatar of Steve Bink
Steve Bink
Flag for United States of America

asked on 

Finding Drupal nodes by combinations of field values

In a Drupal 7 site, we have a node entity type for stored documents.  This type has two custom fields - year and reference - which uniquely identify the node.  These values look something like shown below, with the format being "<reference><hyphen><year>".

Open in new window

I'm receiving a list of these document references (perhaps hundreds at a time) and need an efficient way to find the corresponding node IDs.  What's the best way to do this?
MySQL ServerDrupalSQL

Avatar of undefined
Last Comment
Steve Bink

8/22/2022 - Mon