[ROOT]  dt  Email  <  WHERE To EQ NOTNULL  >   SELECT Date, From, Subject   ORDER BY Date DESC   

No result. See details below for possible causes

_Description

Contains, in addition to result, also log information about execution of API query
WHERE To EQ NOTNULL/SELECT Date, From, Subject/ORDER BY Date DESC

Individual query expressions are:
WHERE To EQ NOTNULL
SELECT Date, From, Subject
ORDER BY Date DESC

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

Query was prematurely terminated

TerminateReason

For query expression

WHERE To EQ NOTNULL

the key

To

was not found.

Last errorResponse is:

Key To not found
CompoundKey.errorResponse: Invalid key.


The current type is PRich.
Probably the wrong key was used as criteria, or the key name was misspelled.

Some possible correct keys are:
PRichId, Date

Some new key functions (available for all entity classes) are:
COUNTP(), COUNTPREC(), GETTYPE(), TOPROPERTYSTREAM()

Some function keys (used on existing keys) are:
AVG(), COUNT(), DATE(), DAYOFWEEK(), DISTINCT(), DOUBLE(), FIRSTLINE(), HOURMINUTE(), INT(), JOIN(), LENGTH(), MAX(), MIN(), MONTH(), QUARTER(), SUM(), TMB(), TOTALHOURS(), TOTALMINUTES(), TYPE(), WEEK(), YEAR(), YEARMONTH(), YEARQUARTER(), YEARWEEK()

Some quantile keys (used on existing keys) are:
MEDIAN, TERTILE, QUARTILE, QUINTILE, SEXTILE, SEPTILE, OCTILE, DECILE, DUODECILE, HEXADECILE, VENTILE, PERCENTILE, PERMILLE


HINT: Use 'STRICT OFF' in order to force execution of query (ignoring this problem).

AllLogEntriesForThisQuery

ExecuteOne/_/159/Start = 2025-02-05 18:02:32.629
ExecuteOne/_/159/Query = WHERE To EQ NOTNULL
ExecuteOne/_/159/CountBefore = 1
ShouldTerminate/_/159/Text = For query expression0x000D0x000A0x000D0x000AWHERE To EQ NOTNULL0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000ATo0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey To not found0x000D0x000ACompoundKey.errorResponse: Invalid key.0x000D0x000A0x000D0x000A0x000D0x000AThe current type is PRich.0x000D0x000AProbably the wrong key was used as criteria, or the key name was misspelled.0x000D0x000A0x000D0x000ASome possible correct keys are:0x000D0x000APRichId, Date0x000D0x000A0x000D0x000ASome new key functions (available for all entity classes) are:0x000D0x000ACOUNTP(), COUNTPREC(), GETTYPE(), TOPROPERTYSTREAM()0x000D0x000A0x000D0x000ASome function keys (used on existing keys) are:0x000D0x000AAVG(), COUNT(), DATE(), DAYOFWEEK(), DISTINCT(), DOUBLE(), FIRSTLINE(), HOURMINUTE(), INT(), JOIN(), LENGTH(), MAX(), MIN(), MONTH(), QUARTER(), SUM(), TMB(), TOTALHOURS(), TOTALMINUTES(), TYPE(), WEEK(), YEAR(), YEARMONTH(), YEARQUARTER(), YEARWEEK()0x000D0x000A0x000D0x000ASome quantile keys (used on existing keys) are:0x000D0x000AMEDIAN, TERTILE, QUARTILE, QUINTILE, SEXTILE, SEPTILE, OCTILE, DECILE, DUODECILE, HEXADECILE, VENTILE, PERCENTILE, PERMILLE0x000D0x000A0x000D0x000A
TerminateReason = For query expression0x000D0x000A0x000D0x000AWHERE To EQ NOTNULL0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000ATo0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey To not found0x000D0x000ACompoundKey.errorResponse: Invalid key.0x000D0x000A0x000D0x000A0x000D0x000AThe current type is PRich.0x000D0x000AProbably the wrong key was used as criteria, or the key name was misspelled.0x000D0x000A0x000D0x000ASome possible correct keys are:0x000D0x000APRichId, Date0x000D0x000A0x000D0x000ASome new key functions (available for all entity classes) are:0x000D0x000ACOUNTP(), COUNTPREC(), GETTYPE(), TOPROPERTYSTREAM()0x000D0x000A0x000D0x000ASome function keys (used on existing keys) are:0x000D0x000AAVG(), COUNT(), DATE(), DAYOFWEEK(), DISTINCT(), DOUBLE(), FIRSTLINE(), HOURMINUTE(), INT(), JOIN(), LENGTH(), MAX(), MIN(), MONTH(), QUARTER(), SUM(), TMB(), TOTALHOURS(), TOTALMINUTES(), TYPE(), WEEK(), YEAR(), YEARMONTH(), YEARQUARTER(), YEARWEEK()0x000D0x000A0x000D0x000ASome quantile keys (used on existing keys) are:0x000D0x000AMEDIAN, TERTILE, QUARTILE, QUINTILE, SEXTILE, SEPTILE, OCTILE, DECILE, DUODECILE, HEXADECILE, VENTILE, PERCENTILE, PERMILLE0x000D0x000A0x000D0x000A0x000D0x000AHINT: Use 'STRICT OFF' in order to force execution of query (ignoring this problem).
ExecuteOne/_/159/CountAfter = 0
ExecuteOne/_/159/Finish = 2025-02-05 18:02:32.630
ExecuteOne/_/159/ElapsedTime = 00:00:00.000
ExecuteOne/_/159/Text = ------------------------------------------------------

Generated 2025-02-05 18:02:32.815 UTC