[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 15770 < SKIP 2750 > < 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 15770/SKIP 2750/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 15770
SKIP 2750
TAKE 500
Note that the ordinary result (from an ordinary exceution of query) is stored in -Result- which is 'invisible' from ordinary -PropertyAccess-.
ExecuteOne/_/24/Start = 2025-07-22 12:57:27.408
ExecuteOne/_/24/Query = SELECT Name, PostalCode, City, StateOrProvince, Country
ExecuteOne/_/24/CountBefore = 18484
ExecuteOne/_/24/CountAfter = 18484
ExecuteOne/_/24/Finish = 2025-07-22 12:57:27.644
ExecuteOne/_/24/ElapsedTime = 00:00:00.235
ExecuteOne/_/24/Text = ------------------------------------------------------
ExecuteOne/_/24/Start = 2025-07-22 12:57:27.644
ExecuteOne/_/24/Query = ORDER BY City
ExecuteOne/_/24/CountBefore = 18484
ExecuteOne/_/24/CountAfter = 18484
ExecuteOne/_/24/Finish = 2025-07-22 12:57:27.644
ExecuteOne/_/24/ElapsedTime = 00:00:00.000
ExecuteOne/_/24/Text = ------------------------------------------------------
ExecuteOne/_/24/Start = 2025-07-22 12:57:27.644
ExecuteOne/_/24/Query = TITLE Customer with addresses. Shows use of EntityMethodKey through methods like TryGetCity
ExecuteOne/_/24/CountBefore = 18484
Title = Customer with addresses. Shows use of EntityMethodKey through methods like TryGetCity
ExecuteOne/_/24/CountAfter = 18484
ExecuteOne/_/24/Finish = 2025-07-22 12:57:27.644
ExecuteOne/_/24/ElapsedTime = 00:00:00.000
ExecuteOne/_/24/Text = ------------------------------------------------------
ExecuteOne/_/24/Start = 2025-07-22 12:57:27.644
ExecuteOne/_/24/Query = SKIP 15770
ExecuteOne/_/24/CountBefore = 18484
ExecuteOne/_/24/CountAfter = 2714
ExecuteOne/_/24/Finish = 2025-07-22 12:57:27.664
ExecuteOne/_/24/ElapsedTime = 00:00:00.020
ExecuteOne/_/24/Text = ------------------------------------------------------
ExecuteOne/_/24/Start = 2025-07-22 12:57:27.664
ExecuteOne/_/24/Query = SKIP 2750
ExecuteOne/_/24/CountBefore = 2714
ExecuteOne/_/24/CountAfter = 0
ExecuteOne/_/24/Finish = 2025-07-22 12:57:27.664
ExecuteOne/_/24/ElapsedTime = 00:00:00.000
ExecuteOne/_/24/Text = ------------------------------------------------------
ExecuteOne/_/24/Start = 2025-07-22 12:57:27.664
ExecuteOne/_/24/Query = TAKE 500
ExecuteOne/_/24/CountBefore = 0
ExecuteOne/_/24/CountAfter = 0
ExecuteOne/_/24/Finish = 2025-07-22 12:57:27.664
ExecuteOne/_/24/ElapsedTime = 00:00:00.000
ExecuteOne/_/24/Text = ------------------------------------------------------
| DimCustomerId |
|---|
Generated 2025-07-22 12:57:27.665 UTC