How we take dynamic parameter in custom query while writing custom query?
FOR EXAMPLE
I want add dynamic parameter instead of 'shared_referrals.shared_ounit_id =21 ’
SELECT assessments.,shared_referrals.shared_ounit_id ’
FROM shared_referrals
LEFT JOIN assessments ON shared_referrals.ounit_id = assessments.ounit_id
WHERE assessments.created >= shared_referrals.start_date AND assessments.created <= shared_referrals.end_date
AND shared_referrals.shared_ounit_id =21
GROUP BY assessments.id
UNION
SELECT assessments.,assessments.ounit_id from assessments
Where assessments.ounit_id = 21