[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 5462 SHUFFLE < SKIP 881 > < TAKE 124 >
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 5462/SHUFFLE/SKIP 881/TAKE 124
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 5462
SHUFFLE
SKIP 881
TAKE 124
Note that the ordinary result (from an ordinary exceution of query) is stored in -Result- which is 'invisible' from ordinary -PropertyAccess-.
ExecuteOne/_/13/Start = 2025-07-20 03:05:03.074
ExecuteOne/_/13/Query = SELECT Name, PostalCode, City, StateOrProvince, Country
ExecuteOne/_/13/CountBefore = 4677
ExecuteOne/_/13/CountAfter = 4677
ExecuteOne/_/13/Finish = 2025-07-20 03:05:03.165
ExecuteOne/_/13/ElapsedTime = 00:00:00.090
ExecuteOne/_/13/Text = ------------------------------------------------------
ExecuteOne/_/13/Start = 2025-07-20 03:05:03.165
ExecuteOne/_/13/Query = ORDER BY City
ExecuteOne/_/13/CountBefore = 4677
ExecuteOne/_/13/CountAfter = 4677
ExecuteOne/_/13/Finish = 2025-07-20 03:05:03.166
ExecuteOne/_/13/ElapsedTime = 00:00:00.001
ExecuteOne/_/13/Text = ------------------------------------------------------
ExecuteOne/_/13/Start = 2025-07-20 03:05:03.166
ExecuteOne/_/13/Query = TITLE Customer with addresses. Shows use of EntityMethodKey through methods like TryGetCity
ExecuteOne/_/13/CountBefore = 4677
Title = Customer with addresses. Shows use of EntityMethodKey through methods like TryGetCity
ExecuteOne/_/13/CountAfter = 4677
ExecuteOne/_/13/Finish = 2025-07-20 03:05:03.166
ExecuteOne/_/13/ElapsedTime = 00:00:00.000
ExecuteOne/_/13/Text = ------------------------------------------------------
ExecuteOne/_/13/Start = 2025-07-20 03:05:03.166
ExecuteOne/_/13/Query = SKIP 5462
ExecuteOne/_/13/CountBefore = 4677
ExecuteOne/_/13/CountAfter = 0
ExecuteOne/_/13/Finish = 2025-07-20 03:05:03.166
ExecuteOne/_/13/ElapsedTime = 00:00:00.000
ExecuteOne/_/13/Text = ------------------------------------------------------
ExecuteOne/_/13/Start = 2025-07-20 03:05:03.166
ExecuteOne/_/13/Query = SHUFFLE
ExecuteOne/_/13/CountBefore = 0
ExecuteOne/_/13/CountAfter = 0
ExecuteOne/_/13/Finish = 2025-07-20 03:05:03.166
ExecuteOne/_/13/ElapsedTime = 00:00:00.000
ExecuteOne/_/13/Text = ------------------------------------------------------
ExecuteOne/_/13/Start = 2025-07-20 03:05:03.166
ExecuteOne/_/13/Query = SKIP 881
ExecuteOne/_/13/CountBefore = 0
ExecuteOne/_/13/CountAfter = 0
ExecuteOne/_/13/Finish = 2025-07-20 03:05:03.166
ExecuteOne/_/13/ElapsedTime = 00:00:00.000
ExecuteOne/_/13/Text = ------------------------------------------------------
ExecuteOne/_/13/Start = 2025-07-20 03:05:03.166
ExecuteOne/_/13/Query = TAKE 124
ExecuteOne/_/13/CountBefore = 0
ExecuteOne/_/13/CountAfter = 0
ExecuteOne/_/13/Finish = 2025-07-20 03:05:03.166
ExecuteOne/_/13/ElapsedTime = 00:00:00.000
ExecuteOne/_/13/Text = ------------------------------------------------------
| DimCustomerId |
|---|
WARNING: -TimestampIsOld-. Possible cause: API is currently initializing.
Generated 2025-07-20 03:05:03.167 UTC