Filtering Rows in SQL: Multiple Conditions for Lookup Queries

Hi Clay Team! Good day to you! I hope you had a great day today! I just want to ask, if there's a way to filter the search for "Lookup Multiple Rows in Other Table", Like I just want to fetch certain rows, if "owner_id" is equals to "something" AND date between "today" and "next friday"

8 comments

Clay
APP
·
·
The "Lookup Multiple Rows in Other Table" enrichment only supports filtering by one column at a time. You cannot apply multiple conditions like "owner_id" equals something AND date between specific values in a single lookup. The lookup inputs are: ** Table to Search ** Target Column (only one column) ** Filter Operator ** Row Value ** *Limit (Optional) To achieve your filtering needs, you'd need to either: 1. Use the lookup with one condition first, then apply additional filtering to the results 2. Pre-filter your source table using table filters before running the lookup
Sources: Lookup Rows | Documentation | Clay University Lookup Rows | Documentation | Clay University Lookup Multiple Rows in Other Table with Clay
Christopher O.
·
·
is there a way to search from another table using its view?
Clay
APP
·
·
No, the Lookup Rows feature searches the entire table, not specific views. The lookup inputs are: ** Table to Search (the full table) ** Target Column ** Filter Operator ** Row Value ** *Limit (Optional) Views are display filters that don't affect how lookups work - they search all data in the source table regardless of any view settings.
Sources: Lookup Rows | Documentation | Clay University Lookup Rows | Documentation | Clay University Lookup Rows | Documentation | Clay University Lookup Single Row in Other Table with Clay Lookup Multiple Rows in Other Table with Clay
Christopher O.
·
·
hmm, wondering how could Achieve that
Christopher O.
·
·
thank you! I already created a work around. I just used SalesForce's SOQL
Clay
APP
·
·
Hi Christopher! Happy Tuesday, and I'm glad to hear that you created a workaround! Is there anything else I can help with?
❤️1
Christopher O.
·
·
its okay now! thank you! ❤️
Clay
APP
·
·
Thanks for letting me know! I'll go ahead and close out the ticket then. 🙏 We are always here to help, feel free to start a new ticket if you ever have more questions!
1
1

Filtering Rows in SQL: Multiple Conditions for Lookup Queries | Clay