<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
<font style="font-size:10pt" color="#366092" face="Arial" size="2">Hello,<br><br><font style="font-size: 10pt;" size="2"><font style="font-size: 10pt;" size="2"><font style="font-size: 10pt;" size="2">I've <font style="font-size: 10pt;" size="2"><font style="font-size: 10pt;" size="2">been</font> testing <font style="font-size: 10pt;" size="2">FS <font style="font-size: 10pt;" size="2">with G<font style="font-size: 10pt;" size="2">A and </font></font></font></font></font></font></font>fou<font style="font-size: 10pt;" size="2">nd somethi<font style="font-size: 10pt;" size="2">ng that don't get how to pu<font style="font-size: 10pt;" size="2">t it.<br><br>For instance, this call works very well in FS:<br><br><font style="font-size: 10pt;" size="2">F<font style="font-size: 10pt;" size="2">irst example:</font></font><br>[code]<br>in FS<font style="font-size: 10pt;" size="2">: </font>http://www.myweb.web/fs/Boreholes?format=GeoJSON&source__ilike=ODP&queryable=source<br>in SQL: <font style="font-size: 10pt;" size="2">SELECT * <font style="font-size: 10pt;" size="2">FROM bor<font style="font-size: 10pt;" size="2">e<font style="font-size: 10pt;" size="2">holes_table <font style="font-size: 10pt;" size="2">wh<font style="font-size: 10pt;" size="2">e<font style="font-size: 10pt;" size="2">re source ilike '%ODP%'<br><font style="font-size: 10pt;" size="2"><font style="font-size: 10pt;" size="2"></font></font><font style="font-size: 10pt;" size="2">[/code]<br><br>and<font style="font-size: 10pt;" size="2"> what I'm looking f<font style="font-size: 10pt;" size="2">or <font style="font-size: 10pt;" size="2">is quer<font style="font-size: 10pt;" size="2">ying this table but using the t<font style="font-size: 10pt;" size="2">svector column,<font style="font-size: 10pt;" size="2"> so</font></font></font></font></font></font> this works in SQL but don't know how to <font style="font-size: 10pt;" size="2">put it in FS:<br><br><font style="font-size: 10pt;" size="2">Second example:</font><br><font style="font-size: 10pt;" size="2"><font style="font-size: 10pt;" size="2"></font>[code]<br><font style="font-size: 10pt;" size="2">in<font style="font-size: 10pt;" size="2"> FS: ??<br><font style="font-size: 10pt;" size="2">in SQL: select * from boreholes_<font style="font-size: 10pt;" size="2">table</font> where tsvector @@ plainto_tsquery('ODP');<br><font style="font-size: 10pt;" size="2"><font style="font-size: 10pt;" size="2">(in an<font style="font-size: 10pt;" size="2">y cas<font style="font-size: 10pt;" size="2">e this is for</font></font></font><font style="font-size: 10pt;" size="2"> GA: "</font></font>session.query(Boreholes).filter(Boreholes.tsvector.op('@@')(func.to_tsquery("ODP"))).all()<font style="font-size: 10pt;" size="2">"</font></font>)<br><font style="font-size: 10pt;" size="2">[<font style="font-size: 10pt;" size="2">/code]<br><br><font style="font-size: 10pt;" size="2"><font style="font-size: 10pt;" size="2"><font style="font-size: 10pt;" size="2">based on the first SQL (and FS) </font></font></font>example, how co<font style="font-size: 10pt;" size="2">uld I put<font style="font-size: 10pt;" size="2"> it for the second </font></font>SQL exa<font style="font-size: 10pt;" size="2">mple?</font><br><br><font style="font-size: 10pt;" size="2">Any hint <font style="font-size: 10pt;" size="2">is apprec<font style="font-size: 10pt;" size="2">iated, <font style="font-size: 10pt;" size="2">t</font></font></font>hanks in advance</font>,<br><br><font style="font-size: 10pt;" size="2">Best regards,<br><br><br></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font><font style="font-size:10pt" color="#1F497D" face="Arial" size="2">__________________________________________________________________________________________<br>Piensa en el medio ambie<font style="" face="Arial">nte - mantenlo en la pantalla. NO lo imprimas si NO es necesario.</font></font><font style="font-size:10pt" color="#1F497D" face="Arial" size="2"><br></font><font style="font-size:10pt" color="#1F497D" face="Arial" size="2">Think green - keep it on the screen. Do NOT print if it is NOT necessary.</font><font style="font-size:10pt" color="#1F497D" face="Arial" size="2"><br></font><font style="font-size:10pt" color="#1F497D" face="Arial" size="2"><span id="ecxresult_box" class="ecxshort_text" lang="de"><span class="ecxhps">Denken Sie an</span> <span class="ecxhps">die Umwelt</span></span></font><font style="font-size:10pt" color="#1F497D" face="Arial" size="2"><span id="ecxresult_box" lang="de"><span class="ecxhps"></span> <span class="ecxhps">-</span> <span class="ecxhps">bewahren Sie es</span> <span class="ecxhps">auf dem Bildschirm.</span> <span class="ecxhps">Drucken Sie NICHT</span><span>, wenn</span> <span class="ecxhps">es NICHT notwendig ist</span><span>.</span></span></font><br> </div></body>
</html>