[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 11211 SHUFFLE < SKIP 7500 > < TAKE 500 >
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 11211/SHUFFLE/SKIP 7500/TAKE 500
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 11211
SHUFFLE
SKIP 7500
TAKE 500
Note that the ordinary result (from an ordinary exceution of query) is stored in -Result- which is 'invisible' from ordinary -PropertyAccess-.
ExecuteOne/_/30/Start = 2025-07-22 12:30:04.161
ExecuteOne/_/30/Query = SELECT Name, PostalCode, City, StateOrProvince, Country
ExecuteOne/_/30/CountBefore = 18484
ExecuteOne/_/30/CountAfter = 18484
ExecuteOne/_/30/Finish = 2025-07-22 12:30:04.834
ExecuteOne/_/30/ElapsedTime = 00:00:00.673
ExecuteOne/_/30/Text = ------------------------------------------------------
ExecuteOne/_/30/Start = 2025-07-22 12:30:04.834
ExecuteOne/_/30/Query = ORDER BY City
ExecuteOne/_/30/CountBefore = 18484
ExecuteOne/_/30/CountAfter = 18484
ExecuteOne/_/30/Finish = 2025-07-22 12:30:04.834
ExecuteOne/_/30/ElapsedTime = 00:00:00.000
ExecuteOne/_/30/Text = ------------------------------------------------------
ExecuteOne/_/30/Start = 2025-07-22 12:30:04.834
ExecuteOne/_/30/Query = TITLE Customer with addresses. Shows use of EntityMethodKey through methods like TryGetCity
ExecuteOne/_/30/CountBefore = 18484
Title = Customer with addresses. Shows use of EntityMethodKey through methods like TryGetCity
ExecuteOne/_/30/CountAfter = 18484
ExecuteOne/_/30/Finish = 2025-07-22 12:30:04.834
ExecuteOne/_/30/ElapsedTime = 00:00:00.000
ExecuteOne/_/30/Text = ------------------------------------------------------
ExecuteOne/_/30/Start = 2025-07-22 12:30:04.834
ExecuteOne/_/30/Query = SKIP 11211
ExecuteOne/_/30/CountBefore = 18484
ExecuteOne/_/30/CountAfter = 7273
ExecuteOne/_/30/Finish = 2025-07-22 12:30:04.848
ExecuteOne/_/30/ElapsedTime = 00:00:00.014
ExecuteOne/_/30/Text = ------------------------------------------------------
ExecuteOne/_/30/Start = 2025-07-22 12:30:04.848
ExecuteOne/_/30/Query = SHUFFLE
ExecuteOne/_/30/CountBefore = 7273
ExecuteOne/_/30/CountAfter = 7273
ExecuteOne/_/30/Finish = 2025-07-22 12:30:04.849
ExecuteOne/_/30/ElapsedTime = 00:00:00.000
ExecuteOne/_/30/Text = ------------------------------------------------------
ExecuteOne/_/30/Start = 2025-07-22 12:30:04.849
ExecuteOne/_/30/Query = SKIP 7500
ExecuteOne/_/30/CountBefore = 7273
ExecuteOne/_/30/CountAfter = 0
ExecuteOne/_/30/Finish = 2025-07-22 12:30:04.849
ExecuteOne/_/30/ElapsedTime = 00:00:00.000
ExecuteOne/_/30/Text = ------------------------------------------------------
ExecuteOne/_/30/Start = 2025-07-22 12:30:04.849
ExecuteOne/_/30/Query = TAKE 500
ExecuteOne/_/30/CountBefore = 0
ExecuteOne/_/30/CountAfter = 0
ExecuteOne/_/30/Finish = 2025-07-22 12:30:04.849
ExecuteOne/_/30/ElapsedTime = 00:00:00.000
ExecuteOne/_/30/Text = ------------------------------------------------------
| DimCustomerId |
|---|
Generated 2025-07-22 12:30:04.849 UTC