TickTac

Department

Appstore

Owner

Steven Lloyd

UNASSIGNED

Status

New

In Progress

Fixed

Tested

Closed

Priority

1-High

2-Medium

3-Low

Ticket#	Title	Status	Priority	Owner	Created	Modified
33 View	change orders table to pcommerce_orders and needs setup section	Closed	1 - High	Steven Lloyd	3 yrs 1 months 7 days	3 yrs 19 days
6 View	need a notification so the owner gets notified of new orders	Closed	2 - Medium		3 yrs 2 months 20 days	3 yrs 19 days
5 View	Add ability to use coupons and create coupons	Closed	2 - Medium		3 yrs 2 months 20 days	3 yrs 19 days
4 View	Add ability to turn off preview hover in cart	Closed	2 - Medium		3 yrs 2 months 20 days	3 yrs 19 days

Array object: { "file": "dev-appstore.wasql.com_php_1ed1e472f2f5a65da007497c36c50866.php", "line": 98, "function": "getDBRecords", "error": "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND coalesce(data-'$.status','') in ('new','in_progress','fixed','tested') G' at line 7", "query": " SELECT count(*) cnt, data-'$.url' as url FROM ticktac_tickets WHERE _cuser= AND coalesce(data-'$.status','') in ('new','in_progress','fixed','tested') GROUP BY data-'$.url'" } --------------------

Array object: { "file": "dev-appstore.wasql.com_php_1ed1e472f2f5a65da007497c36c50866.php", "line": 98, "function": "getDBRecords", "error": "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND coalesce(data-'$.status','') in ('new','in_progress','fixed','tested') AN' at line 7", "query": " SELECT count(*) cnt, data-'$.owner' as owner FROM ticktac_tickets WHERE _cuser= AND coalesce(data-'$.status','') in ('new','in_progress','fixed','tested') AND url='pCommerce' GROUP BY data-'$.owner'" } --------------------

Array object: { "file": "dev-appstore.wasql.com_php_1ed1e472f2f5a65da007497c36c50866.php", "line": 98, "function": "getDBRecords", "error": "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND coalesce(data-'$.status','') in ('new','in_progress','fixed','tested') AN' at line 7", "query": " SELECT count(*) cnt, data-'$.status' as status FROM ticktac_tickets WHERE _cuser= AND coalesce(data-'$.status','') in ('new','in_progress','fixed','tested') AND url='pCommerce' GROUP BY data-'$.status'" } --------------------

Array object: { "file": "dev-appstore.wasql.com_php_1ed1e472f2f5a65da007497c36c50866.php", "line": 98, "function": "getDBRecords", "error": "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND coalesce(data-'$.status','') in ('new','in_progress','fixed','tested') AN' at line 7", "query": " SELECT count(*) cnt, data-'$.priority' as priority FROM ticktac_tickets WHERE _cuser= AND coalesce(data-'$.status','') in ('new','in_progress','fixed','tested') AND url='pCommerce' GROUP BY data-'$.priority'" } --------------------