{"action":"created","issue":{"url":"https://api.github.com/repos/xtuple/xtuple/issues/2728","repository_url":"https://api.github.com/repos/xtuple/xtuple","labels_url":"https://api.github.com/repos/xtuple/xtuple/issues/2728/labels{/name}","comments_url":"https://api.github.com/repos/xtuple/xtuple/issues/2728/comments","events_url":"https://api.github.com/repos/xtuple/xtuple/issues/2728/events","html_url":"https://github.com/xtuple/xtuple/pull/2728","id":160259844,"number":2728,"title":"issue #25928 Reduce mql query time by about 40%","user":{"login":"ChristopherCotnoir","id":16547266,"avatar_url":"https://avatars.githubusercontent.com/u/16547266?v=3","gravatar_id":"","url":"https://api.github.com/users/ChristopherCotnoir","html_url":"https://github.com/ChristopherCotnoir","followers_url":"https://api.github.com/users/ChristopherCotnoir/followers","following_url":"https://api.github.com/users/ChristopherCotnoir/following{/other_user}","gists_url":"https://api.github.com/users/ChristopherCotnoir/gists{/gist_id}","starred_url":"https://api.github.com/users/ChristopherCotnoir/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ChristopherCotnoir/subscriptions","organizations_url":"https://api.github.com/users/ChristopherCotnoir/orgs","repos_url":"https://api.github.com/users/ChristopherCotnoir/repos","events_url":"https://api.github.com/users/ChristopherCotnoir/events{/privacy}","received_events_url":"https://api.github.com/users/ChristopherCotnoir/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2016-06-14T19:07:42Z","updated_at":"2016-06-20T21:36:50Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/xtuple/xtuple/pulls/2728","html_url":"https://github.com/xtuple/xtuple/pull/2728","diff_url":"https://github.com/xtuple/xtuple/pull/2728.diff","patch_url":"https://github.com/xtuple/xtuple/pull/2728.patch"},"body":""},"comment":{"url":"https://api.github.com/repos/xtuple/xtuple/issues/comments/227277299","html_url":"https://github.com/xtuple/xtuple/pull/2728#issuecomment-227277299","issue_url":"https://api.github.com/repos/xtuple/xtuple/issues/2728","id":227277299,"user":{"login":"gilmoskowitz","id":704111,"avatar_url":"https://avatars.githubusercontent.com/u/704111?v=3","gravatar_id":"","url":"https://api.github.com/users/gilmoskowitz","html_url":"https://github.com/gilmoskowitz","followers_url":"https://api.github.com/users/gilmoskowitz/followers","following_url":"https://api.github.com/users/gilmoskowitz/following{/other_user}","gists_url":"https://api.github.com/users/gilmoskowitz/gists{/gist_id}","starred_url":"https://api.github.com/users/gilmoskowitz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gilmoskowitz/subscriptions","organizations_url":"https://api.github.com/users/gilmoskowitz/orgs","repos_url":"https://api.github.com/users/gilmoskowitz/repos","events_url":"https://api.github.com/users/gilmoskowitz/events{/privacy}","received_events_url":"https://api.github.com/users/gilmoskowitz/received_events","type":"User","site_admin":false},"created_at":"2016-06-20T21:36:50Z","updated_at":"2016-06-20T21:36:50Z","body":"Travis CI is failing with the following:\r\n```\r\n2016-06-20 20:26:42 UTC ERROR:  query \"SELECT calculatetaxdetailsummary(pOrderType, pOrderId, pDisplayType, NULL, NULL, NULL, NULL, FALSE)\" returned more than one row\r\n2016-06-20 20:26:42 UTC CONTEXT:  PL/pgSQL function calculatetaxdetailsummary(text,integer,text) line 11 at RETURN NEXT\r\n\tSQL statement \"SELECT round(SUM(amount),4)                  FROM (\r\n\t  SELECT SUM(vodist_amount) AS amount\r\n\t    FROM vodist\r\n\t   WHERE ( (vodist_vohead_id=pVoheadid)\r\n\t     AND   (vodist_tax_id=-1) )\r\n\t  UNION ALL\r\n\t  SELECT vohead_freight AS amount\r\n\t    FROM vohead\r\n\t   WHERE (vohead_id=pVoheadid)     \r\n\t  UNION ALL\r\n\t  SELECT SUM(voitem_freight) AS amount\r\n\t    FROM voitem\r\n\t   WHERE (voitem_vohead_id=pVoheadid)\r\n\t  UNION ALL\r\n\t  SELECT SUM(tax*-1)\r\n\t  FROM \r\n\t    (SELECT round(sum(taxdetail_tax),2) AS tax,\r\n\t              currToBase(_p.vohead_curr_id, round(sum(taxdetail_tax),2), _p.vohead_docdate) AS taxbasevalue\r\n\t     FROM tax \r\n\t     JOIN calculateTaxDetailSummary('VO', pVoheadid, 'T') ON (taxdetail_tax_id=tax_id)\r\n\t     GROUP BY tax_id, tax_sales_accnt_id\r\n\t    ) AS taxdata\r\n\t  ) AS data\"\r\n\tPL/pgSQL function postvoucher(integer,integer,boolean) line 72 at SQL statement\r\n\tPL/pgSQL function postvoucher(integer,boolean) line 5 at RETURN\r\n2016-06-20 20:26:42 UTC STATEMENT:  SELECT postVoucher(452, TRUE) AS result;\r\n```"}}
{"actor":{"display_login":"gilmoskowitz"}}