{"action":"opened","issue":{"url":"https://api.github.com/repos/tarakc02/listbuilder/issues/2","repository_url":"https://api.github.com/repos/tarakc02/listbuilder","labels_url":"https://api.github.com/repos/tarakc02/listbuilder/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/tarakc02/listbuilder/issues/2/comments","events_url":"https://api.github.com/repos/tarakc02/listbuilder/issues/2/events","html_url":"https://github.com/tarakc02/listbuilder/issues/2","id":161567038,"number":2,"title":"r2sql error with dplyr <= 0.4.3","user":{"login":"tarakc02","id":7571361,"avatar_url":"https://avatars.githubusercontent.com/u/7571361?v=3","gravatar_id":"","url":"https://api.github.com/users/tarakc02","html_url":"https://github.com/tarakc02","followers_url":"https://api.github.com/users/tarakc02/followers","following_url":"https://api.github.com/users/tarakc02/following{/other_user}","gists_url":"https://api.github.com/users/tarakc02/gists{/gist_id}","starred_url":"https://api.github.com/users/tarakc02/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tarakc02/subscriptions","organizations_url":"https://api.github.com/users/tarakc02/orgs","repos_url":"https://api.github.com/users/tarakc02/repos","events_url":"https://api.github.com/users/tarakc02/events{/privacy}","received_events_url":"https://api.github.com/users/tarakc02/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-06-22T00:03:32Z","updated_at":"2016-06-22T00:03:32Z","closed_at":null,"body":"For instance:\r\n`agq <- aggregate_q_(table = \"f_transaction_detail_mv\",\r\n                    where = list(quote(alloc_school_code %in% (\"HSB\")),\r\n                                 quote(between(giving_record_dt,\r\n                                               to_date(20140101L, \"yyyymmdd\"),\r\n                                               to_date(20141231L, \"yyyymmdd\")))),\r\n                    having = list(quote(sum(benefit_aog_credited_amt) >= 1000)),\r\n                    id_field = \"donor_entity_id_nbr\",\r\n                    id_type = \"entity_id\",\r\n                    schema = \"CDW\")`\r\n\r\nNow if I do `print(agq)`:\r\n` Error in vapply(lapply(conds, r2sql), as.character, FUN.VALUE = character(1)) : \r\n  values must be length 1,\r\n but FUN(X[[1]]) result is length 3 `\r\n\r\nIt looks like the problem is that inner lapply, which is unnecessary (r2sql already expects a list of quoted expressions). "}}
{"actor":{"display_login":"tarakc02"}}