AnsweredAssumed Answered

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

Question asked by disabled_Luna.media on Jan 31, 2015
Latest reply on Jan 31, 2015 by disabled_Luna.media

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. ???

Outcomes