hledání podle slova v listingu

pokud v GeoGetu postrádáte funkci hledání podle výskytu určitého slova v listingu, tak je VELICE jednoduché ji GeoGet naučit jednoduchoučkou dávkou v Combine!

medwyn vymyslel SQL dotaz, a jak se ukázalo, tak vše potřebné Combine umí 🙂

[Group]
Name=Listing fulltext
Comment=Prohleda listingy na vyskyt zadaneho slova
Icon=Qk02BQAAAAAAADYEAAAoAAAAEAAAABAAAAABAAgAAAAAAAAAAAASCwAAEgsAAAABAAAAAQAAGxsb/xwcHP8lJSX/Nzc3/0NDQ/9ISEj/TU1N/09PT/9TU1P/XFxc/11dXf9eXl7/YGBg/2JiYv9nZ2f/ampq/2xsbP9ubm7/d3d3/3t7e//cAP//gICA/4GBgf+FhYX/hoaG/4mJif+NjY3/kJCQ/5eXl/+ampr/nJyc/6SkpP+np6f/qamp/6qqqv+rq6v/sbGx/7Oxsf+zs7P/t7Ow/7W1tf+8ubf/vr6+/8LCwv/Hx8f/ysbB/8vGwf/NxMT/yMjI/8rKyv/c3Nz/39/f/+3dy//m19f/7t/R/+/i1P/y59v/9vDq//fw6f/48+//8fHx//T09P/19fX/9vb2//j08P//////AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/wAAAP8AAAD/AAAA/xQUFBQUFBQoFRQUFBQUFBQUFBQUFBQUIDUaFBQUFBQUFBQUFBQUFBQkLxwUFBQUFBQFAAASFBQSAQIlEBcXKBQUHR49BhQUBj08BCc7QCkuFBQLQRsDAxhBKwk3Ojo4IxQUDTJBQUFBQRMbNjQ0NyYUFB8fPgcHPj4KLi05OS4uFBQUD0EWFkEsFhQuKiouFBQUFBEzMDBBFxQUFBQUFBQUFBQiIj8/Pw4UFBQUFBQUFBQUFBVBQTEZFBQUFBQUFBQUFBQhCAgMFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQ=
CMT=Autorem SQL dotazu je medwyn
CMD=VarGetText|TEXT|Zadejte hledaný text v listingu:
CMD=VarTest|"%TEXT%"|""|=|Str
CMD=+Stop
CMD=-SQLAdd|SELECT id FROM geolist WHERE unzlib(longdesc) LIKE '%%TEXT%%';|1

do složky script/combine2/Batches nebo si naklikat přímo v pluginu combine.

mikrom

Roman Mikulka aka mikrom. Ajťák, opravář, programátor samouk, elektrotechnik, koloběžkář a geocacher. Více na samostatné stránce O mně.

Mohlo by se vám líbit...