{"action":"opened","issue":{"url":"https://api.github.com/repos/ebean-orm/ebean/issues/1405","repository_url":"https://api.github.com/repos/ebean-orm/ebean","labels_url":"https://api.github.com/repos/ebean-orm/ebean/issues/1405/labels{/name}","comments_url":"https://api.github.com/repos/ebean-orm/ebean/issues/1405/comments","events_url":"https://api.github.com/repos/ebean-orm/ebean/issues/1405/events","html_url":"https://github.com/ebean-orm/ebean/issues/1405","id":330207504,"node_id":"MDU6SXNzdWUzMzAyMDc1MDQ=","number":1405,"title":"ENH: Add SqlQuery.findSingleAttribute() ... for returning single scalar values via SqlQuery","user":{"login":"rbygrave","id":208973,"node_id":"MDQ6VXNlcjIwODk3Mw==","avatar_url":"https://avatars0.githubusercontent.com/u/208973?v=4","gravatar_id":"","url":"https://api.github.com/users/rbygrave","html_url":"https://github.com/rbygrave","followers_url":"https://api.github.com/users/rbygrave/followers","following_url":"https://api.github.com/users/rbygrave/following{/other_user}","gists_url":"https://api.github.com/users/rbygrave/gists{/gist_id}","starred_url":"https://api.github.com/users/rbygrave/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rbygrave/subscriptions","organizations_url":"https://api.github.com/users/rbygrave/orgs","repos_url":"https://api.github.com/users/rbygrave/repos","events_url":"https://api.github.com/users/rbygrave/events{/privacy}","received_events_url":"https://api.github.com/users/rbygrave/received_events","type":"User","site_admin":false},"labels":[{"id":13876687,"node_id":"MDU6TGFiZWwxMzg3NjY4Nw==","url":"https://api.github.com/repos/ebean-orm/ebean/labels/enhancement","name":"enhancement","color":"84b6eb","default":true}],"state":"open","locked":false,"assignee":{"login":"rbygrave","id":208973,"node_id":"MDQ6VXNlcjIwODk3Mw==","avatar_url":"https://avatars0.githubusercontent.com/u/208973?v=4","gravatar_id":"","url":"https://api.github.com/users/rbygrave","html_url":"https://github.com/rbygrave","followers_url":"https://api.github.com/users/rbygrave/followers","following_url":"https://api.github.com/users/rbygrave/following{/other_user}","gists_url":"https://api.github.com/users/rbygrave/gists{/gist_id}","starred_url":"https://api.github.com/users/rbygrave/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rbygrave/subscriptions","organizations_url":"https://api.github.com/users/rbygrave/orgs","repos_url":"https://api.github.com/users/rbygrave/repos","events_url":"https://api.github.com/users/rbygrave/events{/privacy}","received_events_url":"https://api.github.com/users/rbygrave/received_events","type":"User","site_admin":false},"assignees":[{"login":"rbygrave","id":208973,"node_id":"MDQ6VXNlcjIwODk3Mw==","avatar_url":"https://avatars0.githubusercontent.com/u/208973?v=4","gravatar_id":"","url":"https://api.github.com/users/rbygrave","html_url":"https://github.com/rbygrave","followers_url":"https://api.github.com/users/rbygrave/followers","following_url":"https://api.github.com/users/rbygrave/following{/other_user}","gists_url":"https://api.github.com/users/rbygrave/gists{/gist_id}","starred_url":"https://api.github.com/users/rbygrave/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rbygrave/subscriptions","organizations_url":"https://api.github.com/users/rbygrave/orgs","repos_url":"https://api.github.com/users/rbygrave/repos","events_url":"https://api.github.com/users/rbygrave/events{/privacy}","received_events_url":"https://api.github.com/users/rbygrave/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/ebean-orm/ebean/milestones/184","html_url":"https://github.com/ebean-orm/ebean/milestone/184","labels_url":"https://api.github.com/repos/ebean-orm/ebean/milestones/184/labels","id":3404842,"node_id":"MDk6TWlsZXN0b25lMzQwNDg0Mg==","number":184,"title":"11.17.2","description":null,"creator":{"login":"rbygrave","id":208973,"node_id":"MDQ6VXNlcjIwODk3Mw==","avatar_url":"https://avatars0.githubusercontent.com/u/208973?v=4","gravatar_id":"","url":"https://api.github.com/users/rbygrave","html_url":"https://github.com/rbygrave","followers_url":"https://api.github.com/users/rbygrave/followers","following_url":"https://api.github.com/users/rbygrave/following{/other_user}","gists_url":"https://api.github.com/users/rbygrave/gists{/gist_id}","starred_url":"https://api.github.com/users/rbygrave/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rbygrave/subscriptions","organizations_url":"https://api.github.com/users/rbygrave/orgs","repos_url":"https://api.github.com/users/rbygrave/repos","events_url":"https://api.github.com/users/rbygrave/events{/privacy}","received_events_url":"https://api.github.com/users/rbygrave/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":1,"state":"open","created_at":"2018-06-06T12:23:18Z","updated_at":"2018-06-07T10:16:13Z","due_on":null,"closed_at":null},"comments":0,"created_at":"2018-06-07T10:16:13Z","updated_at":"2018-06-07T10:16:13Z","closed_at":null,"author_association":"MEMBER","body":"\r\n### Examples\r\n\r\n```java\r\n    String sql = \"select max(unit_price) from o_order_detail where order_qty > ?\";\r\n\r\n    BigDecimal maxPrice = Ebean.createSqlQuery(sql)\r\n      .setParameter(1, 2)\r\n      .findSingleAttribute(BigDecimal.class);\r\n```\r\n\r\n\r\n```java\r\n    String sql = \"select min(updtime) from o_order_detail where unit_price > ? and updtime is not null\";\r\n\r\n    OffsetDateTime minCreated = Ebean.createSqlQuery(sql)\r\n      .setParameter(1, 2)\r\n      .findSingleAttribute(OffsetDateTime.class);\r\n``\r\n\r\n"}}
{"actor":{"display_login":"rbygrave"}}