{"action":"created","issue":{"url":"https://api.github.com/repos/adamhunter/dossier/issues/51","labels_url":"https://api.github.com/repos/adamhunter/dossier/issues/51/labels{/name}","comments_url":"https://api.github.com/repos/adamhunter/dossier/issues/51/comments","events_url":"https://api.github.com/repos/adamhunter/dossier/issues/51/events","html_url":"https://github.com/adamhunter/dossier/issues/51","id":54046029,"number":51,"title":"How can I select a database column without displaying it as its own report column?","user":{"login":"nathanl","id":338814,"avatar_url":"https://avatars.githubusercontent.com/u/338814?v=3","gravatar_id":"","url":"https://api.github.com/users/nathanl","html_url":"https://github.com/nathanl","followers_url":"https://api.github.com/users/nathanl/followers","following_url":"https://api.github.com/users/nathanl/following{/other_user}","gists_url":"https://api.github.com/users/nathanl/gists{/gist_id}","starred_url":"https://api.github.com/users/nathanl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nathanl/subscriptions","organizations_url":"https://api.github.com/users/nathanl/orgs","repos_url":"https://api.github.com/users/nathanl/repos","events_url":"https://api.github.com/users/nathanl/events{/privacy}","received_events_url":"https://api.github.com/users/nathanl/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-01-12T12:01:52Z","updated_at":"2015-01-13T02:36:11Z","closed_at":null,"body":"Silly question, but if I knew how to do this once, I've forgotten.\r\n\r\nSay I've got this query for a report:\r\n\r\n```\r\nSELECT name, color, id FROM widgets;\r\n```\r\n\r\nI don't want to display the id as its own column; instead, I want the `name` to link somewhere using that id.\r\n\r\n```\r\ndef format_name(value, row)\r\n  # build link using value and row[:id]\r\nend\r\n```\r\n\r\nHow can I prevent `id` from showing up as its own column?"},"comment":{"url":"https://api.github.com/repos/adamhunter/dossier/issues/comments/69686496","html_url":"https://github.com/adamhunter/dossier/issues/51#issuecomment-69686496","issue_url":"https://api.github.com/repos/adamhunter/dossier/issues/51","id":69686496,"user":{"login":"adamhunter","id":65676,"avatar_url":"https://avatars.githubusercontent.com/u/65676?v=3","gravatar_id":"","url":"https://api.github.com/users/adamhunter","html_url":"https://github.com/adamhunter","followers_url":"https://api.github.com/users/adamhunter/followers","following_url":"https://api.github.com/users/adamhunter/following{/other_user}","gists_url":"https://api.github.com/users/adamhunter/gists{/gist_id}","starred_url":"https://api.github.com/users/adamhunter/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/adamhunter/subscriptions","organizations_url":"https://api.github.com/users/adamhunter/orgs","repos_url":"https://api.github.com/users/adamhunter/repos","events_url":"https://api.github.com/users/adamhunter/events{/privacy}","received_events_url":"https://api.github.com/users/adamhunter/received_events","type":"User","site_admin":false},"created_at":"2015-01-13T02:36:11Z","updated_at":"2015-01-13T02:36:11Z","body":"Still a pending feature request my friend :)\r\nWe usually just use a custom report template to hide columns at the moment.\r\n\r\nOn Mon, Jan 12, 2015, 09:57 Nathan Long <notifications@github.com> wrote:\r\n\r\n> Another solution is to SELECT CONCAT(name, '--', id) AS name_link, then\r\n> format the header as just 'name' and format the values by splitting on the\r\n> '--' and building a link. Also a bit awkward, but workable.\r\n>\r\n> —\r\n> Reply to this email directly or view it on GitHub\r\n> <https://github.com/adamhunter/dossier/issues/51#issuecomment-69581358>.\r\n>"}}