gistfile1.txt

select * from `blah`.`DataCapturePropertyInfo` 
where `dataCaptureFormInfoID` = ? and exists 
(select * from `blah`.`DataCapturePropertiesFields` 
where `blah`.`DataCapturePropertyInfo`.`dataCapturePropertiesFieldID` = `blah`.`DataCapturePropertiesFields`.`dataCapturePropertiesFieldID` 
and `fieldName` = ?)


   public function apply($model, RepositoryInterface $repository)
    {
        $query = $model->whereHas('dataCapturePropertiesField', function($query)
        {
            $query->where("fieldName", "=", $this->section);
            if ($this->section === FindByReportTypes::$ADDITIONAL_INFO)
            {
                $query->whereIn("section", $this->propertyReport);
            }
        });
        return $query;
       
    }