[ROOT] / app / bef / Controller / EditController / ~std / QueryProgress
QueryProgress
| Key | Value |
|---|---|
| _Description | Contains, in addition to result, also log information about execution of API query WHERE DimCurrency.AlternateKey EQ 'GBP'/PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount/ORDER BY 2020/SKIP 750 Individual query expressions are: WHERE DimCurrency.AlternateKey EQ 'GBP' PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 SKIP 750 Note that the ordinary result (from an ordinary exceution of query) is stored in -Result- which is 'invisible' from ordinary -PropertyAccess-. |
| AllLogEntriesForThisQuery | ExecuteOne/_/23/Start = 2026-07-05 17:48:02.156 ExecuteOne/_/23/Query = WHERE DimCurrency.AlternateKey EQ 'GBP' ExecuteOne/_/23/CountBefore = 60398 ExecuteOne/_/23/CountAfter = 6740 ExecuteOne/_/23/Finish = 2026-07-05 17:48:02.464 ExecuteOne/_/23/ElapsedTime = 00:00:00.307 ExecuteOne/_/23/Text = ------------------------------------------------------ ExecuteOne/_/23/Start = 2026-07-05 17:48:02.464 ExecuteOne/_/23/Query = PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ExecuteOne/_/23/CountBefore = 6740 StrCurrentType = DimCustomer.Name+','+DimCustomerId ExecuteOne/_/23/CountAfter = 1890 ExecuteOne/_/23/Finish = 2026-07-05 17:48:05.192 ExecuteOne/_/23/ElapsedTime = 00:00:02.728 ExecuteOne/_/23/Text = ------------------------------------------------------ ExecuteOne/_/23/Start = 2026-07-05 17:48:05.192 ExecuteOne/_/23/Query = ORDER BY 2020 ExecuteOne/_/23/CountBefore = 1890 ExecuteOne/_/23/CountAfter = 1890 ExecuteOne/_/23/Finish = 2026-07-05 17:48:05.192 ExecuteOne/_/23/ElapsedTime = 00:00:00.000 ExecuteOne/_/23/Text = ------------------------------------------------------ ExecuteOne/_/23/Start = 2026-07-05 17:48:05.192 ExecuteOne/_/23/Query = SKIP 750 ExecuteOne/_/23/CountBefore = 1890 ExecuteOne/_/23/CountAfter = 1140 ExecuteOne/_/23/Finish = 2026-07-05 17:48:05.193 ExecuteOne/_/23/ElapsedTime = 00:00:00.000 ExecuteOne/_/23/Text = ------------------------------------------------------ |
| CreateHints | -True- |
| CurrentStrictness | -ON- |
| Limit | -1000- |
| Queries | WHERE DimCurrency.AlternateKey EQ 'GBP'; PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount; ORDER BY 2020; SKIP 750 |
| StrCurrentType | -DimCustomer.Name+','+DimCustomerId- |
| UseCache | -False- |
8 items
Generated 2026-07-05 17:59:07.616 UTC