Hi Is there any way to perform filtering of the entity? Its like WHERE IN(), but dinamical. Let say, I have TOrder entity and want to filter (I have already TArray with order numbers). I tried at least add to Find method: .Where(Linq['orderid'].Contains( myArray )) .Where(Linq.contains('orderi…

It's not a Variant array. It's an array of Variant. This should work: var z: TArray<Variant>; begin SetLength(z, 2); for i := 0 to 1 do begin z[i] := IntToStr(i + 10); end;

Filtering the entity according to the list (possibly, _in function)

BIZ TMS Aurelius

vitali_Botz (Vitali Bzot) August 4, 2021, 7:00am 2

Forgot to mention "solution" so far, not the best but working:
.Where( Linq.sql( '{orderid} IN(''1'', "2")' ) )

Topic		Replies	Views
Using the Linq._In method TMS Aurelius	3	311	July 21, 2022
_In operator TMS Aurelius	1	182	December 24, 2022
SQL logic to Aurelius logic TMS Aurelius	4	273	March 11, 2021
FilterDef with Array TMS Aurelius	3	197	January 31, 2024
"SELECT WHERE IN" equivalent TMS Aurelius	4	502	August 6, 2019

Filtering the entity according to the list (possibly, _in function)

Related topics