7 Replies Latest reply on Jan 31, 2015 3:52 PM by disabled_Luna.media

    Why do I get different result sets when using portal filter vs. eSQL?

      Maybe I do not see the difference - but I do get different results sets when I use a portal filter

       

      • Wenn (MusterAnzahl ( Start | Firmenliste::cal_Firma_und_Firmenzusatz ; Start | Firmenliste::gString_Firmensuche ) > 0 ; 1 ; 0)

       

      or when I use a eSQL sript step:

       

      • SQLAusführen (  "SELECT ID FROM SQL_DT_Firmen WHERE cal_Firma_und_Firmenzusatz LIKE ? " ; "" ; "" ; "%"& SQL_DT_Firmen::gString_Firmensuche & "%" )

       

      where "SQL_DT_Firmen" is just another TO of "Start | Firmenliste". Sorry for bothering you with my naming conventions but I do not want to alter it for clarity to make sure that I do not the possible error away...

       

      The first finds more records, the later less or none. ???