Custom Where with variable

April 9, 2019 at 02:25 PM

We are trying to perform a 'custom where' that is efficient so that we don't have to create more than one geomap module we have embedded in a layout. The module is already filtered to match a specified option of a specified field: Field.jr_facilitytype LIKE '%skilled-labor%' , this gets us half way there. Next we need to further filter using that 'custom where' to include a variable but we are not sure how to do this. This is ultimately what we are trying to achieve:

Field.jr_facilitytype LIKE '%skilled-labor%' AND jr_referringfacility LIKE {$VARIABLE}

I understand the syntax is not correct but was the easiest way to communicate what we are trying to achieve. We could place the variable in the controller?

April 9, 2019 at 04:12 PM