[ROOT] dt DimCustomer SELECT Name, PostalCode, City, StateOrProvince, Country < ORDER BY City TITLE Customer with addresses. Shows use of EntityMethodKey through methods like TryGetCity SKIP 250 SHUFFLE < SKIP 6393 > < TAKE 30 >
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/TITLE Customer with addresses. Shows use of EntityMethodKey through methods like TryGetCity/SKIP 250/SHUFFLE/SKIP 6393/TAKE 30
Individual query expressions are:
SELECT Name, PostalCode, City, StateOrProvince, Country
ORDER BY City
TITLE Customer with addresses. Shows use of EntityMethodKey through methods like TryGetCity
SKIP 250
SHUFFLE
SKIP 6393
TAKE 30
Note that the ordinary result (from an ordinary exceution of query) is stored in -Result- which is 'invisible' from ordinary -PropertyAccess-.
ExecuteOne/_/14/Start = 2025-07-15 03:05:04.498
ExecuteOne/_/14/Query = SELECT Name, PostalCode, City, StateOrProvince, Country
ExecuteOne/_/14/CountBefore = 4962
ExecuteOne/_/14/CountAfter = 4962
ExecuteOne/_/14/Finish = 2025-07-15 03:05:04.551
ExecuteOne/_/14/ElapsedTime = 00:00:00.052
ExecuteOne/_/14/Text = ------------------------------------------------------
ExecuteOne/_/14/Start = 2025-07-15 03:05:04.551
ExecuteOne/_/14/Query = ORDER BY City
ExecuteOne/_/14/CountBefore = 4962
ExecuteOne/_/14/CountAfter = 4962
ExecuteOne/_/14/Finish = 2025-07-15 03:05:04.552
ExecuteOne/_/14/ElapsedTime = 00:00:00.000
ExecuteOne/_/14/Text = ------------------------------------------------------
ExecuteOne/_/14/Start = 2025-07-15 03:05:04.552
ExecuteOne/_/14/Query = TITLE Customer with addresses. Shows use of EntityMethodKey through methods like TryGetCity
ExecuteOne/_/14/CountBefore = 4962
Title = Customer with addresses. Shows use of EntityMethodKey through methods like TryGetCity
ExecuteOne/_/14/CountAfter = 4962
ExecuteOne/_/14/Finish = 2025-07-15 03:05:04.552
ExecuteOne/_/14/ElapsedTime = 00:00:00.000
ExecuteOne/_/14/Text = ------------------------------------------------------
ExecuteOne/_/14/Start = 2025-07-15 03:05:04.552
ExecuteOne/_/14/Query = SKIP 250
ExecuteOne/_/14/CountBefore = 4962
ExecuteOne/_/14/CountAfter = 4712
ExecuteOne/_/14/Finish = 2025-07-15 03:05:04.554
ExecuteOne/_/14/ElapsedTime = 00:00:00.001
ExecuteOne/_/14/Text = ------------------------------------------------------
ExecuteOne/_/14/Start = 2025-07-15 03:05:04.554
ExecuteOne/_/14/Query = SHUFFLE
ExecuteOne/_/14/CountBefore = 4712
ExecuteOne/_/14/CountAfter = 4712
ExecuteOne/_/14/Finish = 2025-07-15 03:05:04.554
ExecuteOne/_/14/ElapsedTime = 00:00:00.000
ExecuteOne/_/14/Text = ------------------------------------------------------
ExecuteOne/_/14/Start = 2025-07-15 03:05:04.554
ExecuteOne/_/14/Query = SKIP 6393
ExecuteOne/_/14/CountBefore = 4712
ExecuteOne/_/14/CountAfter = 0
ExecuteOne/_/14/Finish = 2025-07-15 03:05:04.554
ExecuteOne/_/14/ElapsedTime = 00:00:00.000
ExecuteOne/_/14/Text = ------------------------------------------------------
ExecuteOne/_/14/Start = 2025-07-15 03:05:04.554
ExecuteOne/_/14/Query = TAKE 30
ExecuteOne/_/14/CountBefore = 0
ExecuteOne/_/14/CountAfter = 0
ExecuteOne/_/14/Finish = 2025-07-15 03:05:04.554
ExecuteOne/_/14/ElapsedTime = 00:00:00.000
ExecuteOne/_/14/Text = ------------------------------------------------------
| DimCustomerId |
|---|
WARNING: -TimestampIsOld-. Possible cause: API is currently initializing.
Generated 2025-07-15 03:05:04.555 UTC