[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > SHUFFLE < SKIP 5500 > < TAKE 1000
No result. See details below for possible causes
Contains, in addition to result, also log information about execution of API query
WHERE DimCurrency.AlternateKey EQ 'GBP'/SHUFFLE/SKIP 5500/TAKE 1000
Individual query expressions are:
WHERE DimCurrency.AlternateKey EQ 'GBP'
SHUFFLE
SKIP 5500
TAKE 1000
Note that the ordinary result (from an ordinary exceution of query) is stored in -Result- which is 'invisible' from ordinary -PropertyAccess-.
ExecuteOne/_/39/Start = 2025-11-07 12:42:13.537
ExecuteOne/_/39/Query = WHERE DimCurrency.AlternateKey EQ 'GBP'
ExecuteOne/_/39/CountBefore = 60855
ExecuteOne/_/39/CountAfter = 3520
ExecuteOne/_/39/Finish = 2025-11-07 12:42:13.879
ExecuteOne/_/39/ElapsedTime = 00:00:00.342
ExecuteOne/_/39/Text = ------------------------------------------------------
ExecuteOne/_/39/Start = 2025-11-07 12:42:13.879
ExecuteOne/_/39/Query = SHUFFLE
ExecuteOne/_/39/CountBefore = 3520
ExecuteOne/_/39/CountAfter = 3520
ExecuteOne/_/39/Finish = 2025-11-07 12:42:13.879
ExecuteOne/_/39/ElapsedTime = 00:00:00.000
ExecuteOne/_/39/Text = ------------------------------------------------------
ExecuteOne/_/39/Start = 2025-11-07 12:42:13.879
ExecuteOne/_/39/Query = SKIP 5500
ExecuteOne/_/39/CountBefore = 3520
ExecuteOne/_/39/CountAfter = 0
ExecuteOne/_/39/Finish = 2025-11-07 12:42:13.879
ExecuteOne/_/39/ElapsedTime = 00:00:00.000
ExecuteOne/_/39/Text = ------------------------------------------------------
ExecuteOne/_/39/Start = 2025-11-07 12:42:13.879
ExecuteOne/_/39/Query = TAKE 1000
ExecuteOne/_/39/CountBefore = 0
ExecuteOne/_/39/CountAfter = 0
ExecuteOne/_/39/Finish = 2025-11-07 12:42:13.879
ExecuteOne/_/39/ElapsedTime = 00:00:00.000
ExecuteOne/_/39/Text = ------------------------------------------------------
| FactResellerSaleId |
|---|
Generated 2025-11-07 12:42:13.880 UTC