- Queries
- All Stories
- Search
- Advanced Search
All Stories
Mar 15 2021
Mar 12 2021
Added system user check to session LoggedIn method.
Mar 11 2021
Mar 8 2021
Mar 4 2021
Fixed outdating sorting resetting code on report change. Before the fix user would have got an SQL error.
Removed artifacts resulted after adding numberic IDField to every report grid:
Mar 3 2021
Test plan is all right. But, beyond this patch, exists SQL error when doing "View Chart" for "By Product" and "By Section" cases. Problematic SQL is like
SELECT LEFT(c.l1_Name, 60) AS Name, c.CategoryId, SUM() as Metric FROM inp_Orders AS o LEFT JOIN inp_OrderItems AS od ON od.OrderId = o.OrderId LEFT JOIN inp_Products AS p ON p.ProductId = od.ProductId LEFT JOIN inp_CategoryItems AS ci ON ci.ItemResourceId = p.ResourceId LEFT JOIN inp_Categories AS c ON c.CategoryId = ci.CategoryId WHERE o.Status IN (4,6) AND o.OrderDate >= 1614718800 AND o.OrderDate <= 1614805199 GROUP BY c.CategoryId HAVING NOT ISNULL(CategoryId) ORDER BY Metric DESCThere is "SUM() as Metric" column, where SUM argument is missing.
Test plan is all right. But, beyond this patch, exists SQL error when doing "View Chart" for "By Product" and "By Section" cases. Problematic SQL is like
Feb 26 2021
Feb 23 2021
Previous fix changed logic of the code to allow empty field values, but that wasn't on purpose.
Feb 19 2021
Cant test this - do not have macOS
Feb 9 2021
Jan 15 2021
This change isn't a bug fix request, but a requirement change, that happened over time.