Filtering JSON Columns for Job Titles in Find Companies Table

Hi! When working with a JSON-like column (that includes multiple fields, for example up to 10 open jobs), what's the best way to filter one field within this column? Specifically, I'm working with a Find Companies table, and I want to filter it to companies hiring for a given position. I'm struggling to filter on "Title" within the "Find Open Jobs" column Table here https://app.clay.com/workspaces/195674/tables/t_MpVxUrcraPPA/views/gv_Kg3off7wMovb

👀1

7 comments

Channeled
APP
·
·
To filter for companies hiring specific positions, you can use the "Filter for Job Title" parameter when setting up your Find Open Jobs search. Simply enter the specific job titles you want to filter for, separated by commas (e.g., "Engineer, Marketing, Accountant").For more accurate results, it's recommended to:1. First select relevant departments 2. Then add your specific job title filters 3. Optionally, you can also filter by: • Days since posted • Location-specific jobs • Job description keywords Sources: Find Open Jobs with PredictLeads Find Active Job Openings with Companies, People, Jobs
Channeled
APP
·
·
Hi Laurent B.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thank you so much for sharing your feedback Laurent B.!
Arturo O.
·
·
Hey Laurent, thanks for reaching out. Happy to help! There should be a way to filter using formulas, depending on what the goal is, you could ask it to check for certain words and return true/false, or return the words, url to the job post, etc. Feel free to share more if you have something specific in mind, and would like some additional eyes on setting that up. https://downloads.intercomcdn.com/i/o/w28k1kwz/1324950927/c42f727588ff757fde102fb0e029/chrome_IztsSWKgzF.png?expires=1736276400&signature=9ff5c28e8a6ae1f71342d944db95b77c56bb180f154eb8f0215b3b91edb7d730&req=dSMlEsB7nYhdXvMW1HO4zSO%2Bfrx8jOCdXXojmtjuKA12DW4tcoRYhIHRPzaK%0Altfp%0A
Laurent B.
·
·
thank you!
Channeled
APP
·
·
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
Channeled
APP
·
·
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!