{"action":"created","issue":{"url":"https://api.github.com/repos/kbower/tickettest1/issues/3328","repository_url":"https://api.github.com/repos/kbower/tickettest1","labels_url":"https://api.github.com/repos/kbower/tickettest1/issues/3328/labels{/name}","comments_url":"https://api.github.com/repos/kbower/tickettest1/issues/3328/comments","events_url":"https://api.github.com/repos/kbower/tickettest1/issues/3328/events","html_url":"https://github.com/kbower/tickettest1/issues/3328","id":197044681,"number":3328,"title":"When the Arrival Date is updated using Loft, the comments inserted in the PO_LN$ACTN_HST are formatted incorrectly.","user":{"login":"i-rabot","id":24670438,"avatar_url":"https://avatars.githubusercontent.com/u/24670438?v=3","gravatar_id":"","url":"https://api.github.com/users/i-rabot","html_url":"https://github.com/i-rabot","followers_url":"https://api.github.com/users/i-rabot/followers","following_url":"https://api.github.com/users/i-rabot/following{/other_user}","gists_url":"https://api.github.com/users/i-rabot/gists{/gist_id}","starred_url":"https://api.github.com/users/i-rabot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/i-rabot/subscriptions","organizations_url":"https://api.github.com/users/i-rabot/orgs","repos_url":"https://api.github.com/users/i-rabot/repos","events_url":"https://api.github.com/users/i-rabot/events{/privacy}","received_events_url":"https://api.github.com/users/i-rabot/received_events","type":"User","site_admin":false},"labels":[{"id":502425680,"url":"https://api.github.com/repos/kbower/tickettest1/labels/bug","name":"bug","color":"ee0701","default":true},{"id":502436250,"url":"https://api.github.com/repos/kbower/tickettest1/labels/eld","name":"eld","color":"fef2c0","default":false}],"state":"open","locked":false,"assignee":{"login":"kentbower","id":5034099,"avatar_url":"https://avatars.githubusercontent.com/u/5034099?v=3","gravatar_id":"","url":"https://api.github.com/users/kentbower","html_url":"https://github.com/kentbower","followers_url":"https://api.github.com/users/kentbower/followers","following_url":"https://api.github.com/users/kentbower/following{/other_user}","gists_url":"https://api.github.com/users/kentbower/gists{/gist_id}","starred_url":"https://api.github.com/users/kentbower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kentbower/subscriptions","organizations_url":"https://api.github.com/users/kentbower/orgs","repos_url":"https://api.github.com/users/kentbower/repos","events_url":"https://api.github.com/users/kentbower/events{/privacy}","received_events_url":"https://api.github.com/users/kentbower/received_events","type":"User","site_admin":false},"assignees":[{"login":"kentbower","id":5034099,"avatar_url":"https://avatars.githubusercontent.com/u/5034099?v=3","gravatar_id":"","url":"https://api.github.com/users/kentbower","html_url":"https://github.com/kentbower","followers_url":"https://api.github.com/users/kentbower/followers","following_url":"https://api.github.com/users/kentbower/following{/other_user}","gists_url":"https://api.github.com/users/kentbower/gists{/gist_id}","starred_url":"https://api.github.com/users/kentbower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kentbower/subscriptions","organizations_url":"https://api.github.com/users/kentbower/orgs","repos_url":"https://api.github.com/users/kentbower/repos","events_url":"https://api.github.com/users/kentbower/events{/privacy}","received_events_url":"https://api.github.com/users/kentbower/received_events","type":"User","site_admin":false}],"milestone":null,"comments":4,"created_at":"2016-12-21T22:08:18Z","updated_at":"2016-12-21T22:08:22Z","closed_at":null,"body":"_Imported from trac ticket 3328.\nCreated by **mariam**\nOpened in trac: Aug 6, 2015, 12:45:39 PM\nLast modified in trac: Aug 29, 2016, 10:28:39 AM_\n***\n_by mariam:_\nWhen the Arrival Date is updated using Loft, the comments inserted in the PO_LN$ACTN_HST are formatted incorrectly. found PO_LN$ACTN_HST.CMNT field for that PO was formatted MM/DD/YYYY instead of DD-MM-YYYY for the PO_LN$ACTN_HST. PO_ACTN_TP_CD = ‘ADC’   (ADC stands for Arrival Date Change) \n___\nIt's a Loft bug.  I doubt our engineer had any reason to believe a column named CMNT would be parsed by a report and the date extracted.\n\nScott, please create a ticket referencing [r5051](../commit/ea9884ffb62d7d79b780111030fb40259fe2c0d6)\nInclude in the ticket that a dataupdate.py update statement must be included to fix all purchaseordertrans 'ADC' type transactions which Loft incorrectly wrote.  I suspect this ticket should be raised in priority.\n___\nAlso, the 'SDC' type transactions are also wrong probably.\n\n"},"comment":{"url":"https://api.github.com/repos/kbower/tickettest1/issues/comments/268654904","html_url":"https://github.com/kbower/tickettest1/issues/3328#issuecomment-268654904","issue_url":"https://api.github.com/repos/kbower/tickettest1/issues/3328","id":268654904,"user":{"login":"i-rabot","id":24670438,"avatar_url":"https://avatars.githubusercontent.com/u/24670438?v=3","gravatar_id":"","url":"https://api.github.com/users/i-rabot","html_url":"https://github.com/i-rabot","followers_url":"https://api.github.com/users/i-rabot/followers","following_url":"https://api.github.com/users/i-rabot/following{/other_user}","gists_url":"https://api.github.com/users/i-rabot/gists{/gist_id}","starred_url":"https://api.github.com/users/i-rabot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/i-rabot/subscriptions","organizations_url":"https://api.github.com/users/i-rabot/orgs","repos_url":"https://api.github.com/users/i-rabot/repos","events_url":"https://api.github.com/users/i-rabot/events{/privacy}","received_events_url":"https://api.github.com/users/i-rabot/received_events","type":"User","site_admin":false},"created_at":"2016-12-21T22:08:22Z","updated_at":"2016-12-21T22:08:22Z","body":"_**kbower** trac comment on Aug 29, 2016, 10:27:33 AM:_\n\nAdding this SQL:\n```\nUPDATE purchaseordertrans SET \"comment\"=to_char(to_date(purchaseordertrans.\"comment\", 'MM/DD/YYYY'), 'DD-MON-YYYY') \nWHERE purchaseordertrans.type = 'ADC' \nAND purchaseordertrans.\"comment\" LIKE '%/%/%' \nAND valid_date(purchaseordertrans.\"comment\", 'MM/DD/YYYY') IS NOT NULL;\n\nUPDATE purchaseordertrans SET \"comment\"=to_char(to_date(purchaseordertrans.\"comment\", 'DD-MON-YY'), 'DD-MON-YYYY') \nWHERE purchaseordertrans.type = 'SDC' \nAND length(purchaseordertrans.\"comment\") = 9 \nAND valid_date(purchaseordertrans.\"comment\", 'DD-MON-YY') IS NOT NULL;\n```\n"}}
{"actor":{"display_login":"i-rabot"}}