This is the query I put into Zapier and for some reason it is not pulling back the organization name. This lives in a different data table so I used JOIN. This query works no problem in heroku data clip but in Zapier its missing all the fields associated to the JOINs. How do you prevent this?
SELECT organization.name, test_test, concat('Unique URL’) AS url, test_id.name, test_status, test.created_at
FROM test_plan_spec
JOIN user_account ON user_account.id = test_plan_spec.user_account_id
JOIN organization ON organization.id = user_account.organization_id
WHERE tps_status = 'ACTIVE'
ORDER BY test_plan_spec.created_at ASC
Best answer by Derrek Hennessy
View original
