Jreviews GeoMaps Module with Custom WHERE (help with sintax)

[Konstantin_ru]

I want make Jreviews GeoMaps Module with markers of places that field jr_sample coincides with "text text.text"

But I can't properly fill in the Custom WHERE - (Field.jr_sample LIKE '%text text.text%') does not work

 

Module setting:

Functionality Mode: Normal

BASIC FILTERS

No

No

No

Show listing marker only

Directory IDs: 4

Custom WHERE - (Listing.state = 1 AND Field.jr_sample LIKE '%text text.text%') or, as a variant (Listing.state = 1 AND Field.jr_sample = '*text text.text*')

or without "Listing.state = 1"

 

Field jr_sample type "text field"

In module I see Pacific Ocean

help me, please, with the syntax of the query

 

 

sorry  :)

after 10 min waiting answer I see what (Listing.state = 1 AND Field.jr_sample LIKE '%text text.text%') work right  :)