Lookup Multiple Rows with Column Conditions in SQL Tables

·

is there any way to lookup multiple rows in another table and apply a variety of column value conditions/constraints on that lookup? for example lookup all rows in table X where Column Y equals/contains z AND Column W equals/contains p

👍

1

2 comments

· Sorted by Oldest

Mark L.
·
·
Nir, thanks for getting in touch. Today, there is no ability to do such lookups in Clay. You would need to complete the lookup, return the records as applicable, and then you could "post-process" them depending on the properties in each record. From what I understand, the product decision-makers will be exploring this further in the future. No specific timeline for that. But I did see a recent internal conversation on the same topic, so I've shared your feedback there. We'll evaluate and see what we can squeeze into the future product roadmap – thanks again for sharing this!
👍1
Channeled
APP
·
·
Hi Nir B.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

Mark L.
·
·
Nir, thanks for getting in touch. Today, there is no ability to do such lookups in Clay. You would need to complete the lookup, return the records as applicable, and then you could "post-process" them depending on the properties in each record. From what I understand, the product decision-makers will be exploring this further in the future. No specific timeline for that. But I did see a recent internal conversation on the same topic, so I've shared your feedback there. We'll evaluate and see what we can squeeze into the future product roadmap – thanks again for sharing this!
👍1
Channeled
APP
·
·
Hi Nir B.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: