troubleshooting Question

Finding Drupal nodes by combinations of field values

Avatar of Steve Bink
Steve BinkFlag for United States of America asked on
MySQL ServerDrupalSQL
8 Comments1 Solution327 ViewsLast Modified:
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>".
S123-2015
S456-2013
S1145-2015
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?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros