{"action":"created","issue":{"url":"https://api.github.com/repos/revive-adserver/revive-adserver/issues/987","repository_url":"https://api.github.com/repos/revive-adserver/revive-adserver","labels_url":"https://api.github.com/repos/revive-adserver/revive-adserver/issues/987/labels{/name}","comments_url":"https://api.github.com/repos/revive-adserver/revive-adserver/issues/987/comments","events_url":"https://api.github.com/repos/revive-adserver/revive-adserver/issues/987/events","html_url":"https://github.com/revive-adserver/revive-adserver/issues/987","id":336271981,"node_id":"MDU6SXNzdWUzMzYyNzE5ODE=","number":987,"title":"dateTime.iso8601 not well supported on statistics","user":{"login":"juanjopv","id":40636551,"node_id":"MDQ6VXNlcjQwNjM2NTUx","avatar_url":"https://avatars2.githubusercontent.com/u/40636551?v=4","gravatar_id":"","url":"https://api.github.com/users/juanjopv","html_url":"https://github.com/juanjopv","followers_url":"https://api.github.com/users/juanjopv/followers","following_url":"https://api.github.com/users/juanjopv/following{/other_user}","gists_url":"https://api.github.com/users/juanjopv/gists{/gist_id}","starred_url":"https://api.github.com/users/juanjopv/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/juanjopv/subscriptions","organizations_url":"https://api.github.com/users/juanjopv/orgs","repos_url":"https://api.github.com/users/juanjopv/repos","events_url":"https://api.github.com/users/juanjopv/events{/privacy}","received_events_url":"https://api.github.com/users/juanjopv/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":9,"created_at":"2018-06-27T15:10:18Z","updated_at":"2018-06-28T10:03:58Z","closed_at":null,"author_association":"NONE","body":"Hello,\r\n\r\nWe are using REST API plugin to comunicate with our Revive AdServer, but we have problems on querying for statistics, since we need a strongly datetime filter. We sent and email to the REST API plugin developer and he said that timestamp filters are not well supported by Revive AdServer, but data seems Ok on Revive database. \r\n\r\nSeems like this plugin is a wrapper of legacy XML_RPC API, so the problem comes from there.\r\n\r\nWe're then using XML_RPC API and having the same problem.\r\n\r\nWe found some API documentation found here:\r\nhttps://github.com/Artistan/Revive-XmlRpc/blob/HEAD/api.md#class-artistanrevivexmlrpcopenadsv2apixmlrpc\r\n\r\nWe're using pear/XML_RPC2 for consuming legacy XML_RPC API:\r\nhttps://github.com/pear/XML_RPC2\r\n\r\n\r\n\r\nProblem:\r\nXML_RPC API does not support 'dateTime.iso8601' properly for statistics calls. Results seems to be for a completely day. Since this api is not working properly, the available REST API plugin for Revive AdServer, that I guess is a wrapper of XML_RPC api, has the same problem.\r\n\r\n\r\nSteps To Reproduce:\r\nMake a request to:\r\n\"your-revive-domain/www/api/v2/xmlrpc/ox.campaignStatisticsConversions\" or any other campaign statistic public method of the XML_RPC API passing startDate and endDate on ISO8601 format.\r\n\r\nExpected: Results are filtered properly with accordingly to timestamps ranges.\r\n\r\nActual: Results seems to be from YYYY-MM-dd 00:00:00 to YYYY-MM-dd 23:59:59\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/revive-adserver/revive-adserver/issues/comments/400983255","html_url":"https://github.com/revive-adserver/revive-adserver/issues/987#issuecomment-400983255","issue_url":"https://api.github.com/repos/revive-adserver/revive-adserver/issues/987","id":400983255,"node_id":"MDEyOklzc3VlQ29tbWVudDQwMDk4MzI1NQ==","user":{"login":"juanjopv","id":40636551,"node_id":"MDQ6VXNlcjQwNjM2NTUx","avatar_url":"https://avatars2.githubusercontent.com/u/40636551?v=4","gravatar_id":"","url":"https://api.github.com/users/juanjopv","html_url":"https://github.com/juanjopv","followers_url":"https://api.github.com/users/juanjopv/followers","following_url":"https://api.github.com/users/juanjopv/following{/other_user}","gists_url":"https://api.github.com/users/juanjopv/gists{/gist_id}","starred_url":"https://api.github.com/users/juanjopv/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/juanjopv/subscriptions","organizations_url":"https://api.github.com/users/juanjopv/orgs","repos_url":"https://api.github.com/users/juanjopv/repos","events_url":"https://api.github.com/users/juanjopv/events{/privacy}","received_events_url":"https://api.github.com/users/juanjopv/received_events","type":"User","site_admin":false},"created_at":"2018-06-28T10:03:58Z","updated_at":"2018-06-28T10:03:58Z","author_association":"NONE","body":"By updating users table:\r\nI switched the user account I'm using from Default mangager to Administrator account type and the same result. :("}}
{"actor":{"display_login":"juanjopv"}}