[ROOT]  doc  HLocation  SELECT Location, Filename   <  ORDER BY Location   <  LIMIT 512  >   SHUFFLE   <  SKIP 560  >   <  TAKE 16  >   <  SKIP 1390  >   <  TAKE 512   

No result. See details below for possible causes

_Description

Contains, in addition to result, also log information about execution of API query
SELECT Location, Filename/ORDER BY Location/LIMIT 512/SHUFFLE/SKIP 560/TAKE 16/SKIP 1390/TAKE 512

Individual query expressions are:
SELECT Location, Filename
ORDER BY Location
LIMIT 512
SHUFFLE
SKIP 560
TAKE 16
SKIP 1390
TAKE 512

Note that the ordinary result (from an ordinary exceution of query) is stored in -Result- which is 'invisible' from ordinary -PropertyAccess-.

AllLogEntriesForThisQuery

ExecuteOne/_/9/Start = 2025-06-29 14:38:10.906
ExecuteOne/_/9/Query = SELECT Location, Filename
ExecuteOne/_/9/CountBefore = 1193
ExecuteOne/_/9/CountAfter = 1193
ExecuteOne/_/9/Finish = 2025-06-29 14:38:10.907
ExecuteOne/_/9/ElapsedTime = 00:00:00.001
ExecuteOne/_/9/Text = ------------------------------------------------------
ExecuteOne/_/9/Start = 2025-06-29 14:38:10.907
ExecuteOne/_/9/Query = ORDER BY Location
ExecuteOne/_/9/CountBefore = 1193
ExecuteOne/_/9/CountAfter = 1193
ExecuteOne/_/9/Finish = 2025-06-29 14:38:10.907
ExecuteOne/_/9/ElapsedTime = 00:00:00.000
ExecuteOne/_/9/Text = ------------------------------------------------------
ExecuteOne/_/9/Start = 2025-06-29 14:38:10.907
ExecuteOne/_/9/Query = LIMIT 512
ExecuteOne/_/9/CountBefore = 1193
Limit = 512
ExecuteOne/_/9/CountAfter = 1193
ExecuteOne/_/9/Finish = 2025-06-29 14:38:10.907
ExecuteOne/_/9/ElapsedTime = 00:00:00.000
ExecuteOne/_/9/Text = ------------------------------------------------------
ExecuteOne/_/9/Start = 2025-06-29 14:38:10.908
ExecuteOne/_/9/Query = SHUFFLE
ExecuteOne/_/9/CountBefore = 1193
ExecuteOne/_/9/CountAfter = 1193
ExecuteOne/_/9/Finish = 2025-06-29 14:38:10.911
ExecuteOne/_/9/ElapsedTime = 00:00:00.003
ExecuteOne/_/9/Text = ------------------------------------------------------
ExecuteOne/_/9/Start = 2025-06-29 14:38:10.911
ExecuteOne/_/9/Query = SKIP 560
ExecuteOne/_/9/CountBefore = 1193
ExecuteOne/_/9/CountAfter = 633
ExecuteOne/_/9/Finish = 2025-06-29 14:38:10.911
ExecuteOne/_/9/ElapsedTime = 00:00:00.000
ExecuteOne/_/9/Text = ------------------------------------------------------
ExecuteOne/_/9/Start = 2025-06-29 14:38:10.911
ExecuteOne/_/9/Query = TAKE 16
ExecuteOne/_/9/CountBefore = 633
ExecuteOne/_/9/CountAfter = 16
ExecuteOne/_/9/Finish = 2025-06-29 14:38:10.911
ExecuteOne/_/9/ElapsedTime = 00:00:00.000
ExecuteOne/_/9/Text = ------------------------------------------------------
ExecuteOne/_/9/Start = 2025-06-29 14:38:10.911
ExecuteOne/_/9/Query = SKIP 1390
ExecuteOne/_/9/CountBefore = 16
ExecuteOne/_/9/CountAfter = 0
ExecuteOne/_/9/Finish = 2025-06-29 14:38:10.911
ExecuteOne/_/9/ElapsedTime = 00:00:00.000
ExecuteOne/_/9/Text = ------------------------------------------------------
ExecuteOne/_/9/Start = 2025-06-29 14:38:10.911
ExecuteOne/_/9/Query = TAKE 512
ExecuteOne/_/9/CountBefore = 0
ExecuteOne/_/9/CountAfter = 0
ExecuteOne/_/9/Finish = 2025-06-29 14:38:10.911
ExecuteOne/_/9/ElapsedTime = 00:00:00.000
ExecuteOne/_/9/Text = ------------------------------------------------------

HLocationId

Generated 2025-06-29 14:38:10.911 UTC