Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

Postgres Row Lookup: Need Help with Output Column for Filtering | Clay

Postgres Row Lookup: Need Help with Output Column for Filtering

·

·

Hey team, I'm running a postgres row lookup column and I need it to output a result column that I can use to filter the rest of my table. Right now there doesn't seem to be any output column variables available. Any insight on this?

Loading attachments

8 comments

· Sorted by Oldest

Bruno R.
·
·
Hi Clark, thanks for reaching out. Do you mind sending the link to the table so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1730991600&signature=f942949e9185af048282743da8ed995c12bb80d433d3c5993c34189a819c2a38&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSv1D5YQ2BKsam%2FhVPsZ8Q%3D%3D%0A
Clark G.
·
·
https://app.clay.com/workspaces/369580/tables/t_adhmacZdt8CP/views/gv_Pc2gQt7JKCs6
Bruno R.
·
·
Looks like this sql query is not returning any values. Can you try running this sample query in postgres (it simulates the query for row 1) and see if you're able to return any records? SELECT * FROM "User" u WHERE (u."email" = 'ayush@syntra.com' OR u."linkedinUrl" = 'https://www.linkedin.com/in/ayushjain04') AND (u."email" IS NOT NULL AND u."email" <> '' OR u."linkedinUrl" IS NOT NULL AND u."linkedinUrl" <> '') LIMIT 1;
Clark G.
·
·
I'll try that, but to clarify, there shoudn't be many results in general. You can see in the original screenshot 1 returned found out of most.
Bruno R.
·
·
I see sorry about the confusion here Clark, the issue you're having is related to parsing out the json object's arrays into individual columns here, I recorded a quick video to show you how you may be able to do this, but let me know if I'm still missing context on the error here: https://www.loom.com/share/ad27234dd1cf42e78a3708b85374bdc7?sid=2d963913-1cac-491e-b49a-0ff62e92eaa5
Clark G.
·
·
Amazing! Thanks for your help!
Bruno R.
·
·
Happy to help here Clark!
Channeled
APP
·
·
Hi Clark G.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: