[ROOT] dt DimCustomer SELECT Name, PostalCode, City, StateOrProvince, Country ORDER BY City DESC > TITLE Customer with addresses. Shows use of EntityMethodKey through methods like TryGetCity SKIP 614 < SKIP 3000 > < TAKE 1000
No result. See details below for possible causes
Contains, in addition to result, also log information about execution of API query
SELECT Name, PostalCode, City, StateOrProvince, Country/ORDER BY City DESC/TITLE Customer with addresses. Shows use of EntityMethodKey through methods like TryGetCity/SKIP 614/SKIP 3000/TAKE 1000
Individual query expressions are:
SELECT Name, PostalCode, City, StateOrProvince, Country
ORDER BY City DESC
TITLE Customer with addresses. Shows use of EntityMethodKey through methods like TryGetCity
SKIP 614
SKIP 3000
TAKE 1000
Note that the ordinary result (from an ordinary exceution of query) is stored in -Result- which is 'invisible' from ordinary -PropertyAccess-.
ExecuteOne/_/4/Start = 2025-07-19 03:05:03.346
ExecuteOne/_/4/Query = SELECT Name, PostalCode, City, StateOrProvince, Country
ExecuteOne/_/4/CountBefore = 2160
ExecuteOne/_/4/CountAfter = 2160
ExecuteOne/_/4/Finish = 2025-07-19 03:05:03.365
ExecuteOne/_/4/ElapsedTime = 00:00:00.018
ExecuteOne/_/4/Text = ------------------------------------------------------
ExecuteOne/_/4/Start = 2025-07-19 03:05:03.365
ExecuteOne/_/4/Query = ORDER BY City DESC
ExecuteOne/_/4/CountBefore = 2160
ExecuteOne/_/4/CountAfter = 2160
ExecuteOne/_/4/Finish = 2025-07-19 03:05:03.365
ExecuteOne/_/4/ElapsedTime = 00:00:00.000
ExecuteOne/_/4/Text = ------------------------------------------------------
ExecuteOne/_/4/Start = 2025-07-19 03:05:03.365
ExecuteOne/_/4/Query = TITLE Customer with addresses. Shows use of EntityMethodKey through methods like TryGetCity
ExecuteOne/_/4/CountBefore = 2160
Title = Customer with addresses. Shows use of EntityMethodKey through methods like TryGetCity
ExecuteOne/_/4/CountAfter = 2160
ExecuteOne/_/4/Finish = 2025-07-19 03:05:03.365
ExecuteOne/_/4/ElapsedTime = 00:00:00.000
ExecuteOne/_/4/Text = ------------------------------------------------------
ExecuteOne/_/4/Start = 2025-07-19 03:05:03.365
ExecuteOne/_/4/Query = SKIP 614
ExecuteOne/_/4/CountBefore = 2160
ExecuteOne/_/4/CountAfter = 1546
ExecuteOne/_/4/Finish = 2025-07-19 03:05:03.366
ExecuteOne/_/4/ElapsedTime = 00:00:00.000
ExecuteOne/_/4/Text = ------------------------------------------------------
ExecuteOne/_/4/Start = 2025-07-19 03:05:03.366
ExecuteOne/_/4/Query = SKIP 3000
ExecuteOne/_/4/CountBefore = 1546
ExecuteOne/_/4/CountAfter = 0
ExecuteOne/_/4/Finish = 2025-07-19 03:05:03.366
ExecuteOne/_/4/ElapsedTime = 00:00:00.000
ExecuteOne/_/4/Text = ------------------------------------------------------
ExecuteOne/_/4/Start = 2025-07-19 03:05:03.366
ExecuteOne/_/4/Query = TAKE 1000
ExecuteOne/_/4/CountBefore = 0
ExecuteOne/_/4/CountAfter = 0
ExecuteOne/_/4/Finish = 2025-07-19 03:05:03.366
ExecuteOne/_/4/ElapsedTime = 00:00:00.000
ExecuteOne/_/4/Text = ------------------------------------------------------
| DimCustomerId |
|---|
WARNING: -TimestampIsOld-. Possible cause: API is currently initializing.
Generated 2025-07-19 03:05:03.366 UTC