{"action":"created","issue":{"url":"https://api.github.com/repos/ikkez/f3-cortex/issues/17","repository_url":"https://api.github.com/repos/ikkez/f3-cortex","labels_url":"https://api.github.com/repos/ikkez/f3-cortex/issues/17/labels{/name}","comments_url":"https://api.github.com/repos/ikkez/f3-cortex/issues/17/comments","events_url":"https://api.github.com/repos/ikkez/f3-cortex/issues/17/events","html_url":"https://github.com/ikkez/f3-cortex/issues/17","id":132471935,"number":17,"title":"Q: Retrieve only specific columns","user":{"login":"blindpenguin","id":4688741,"avatar_url":"https://avatars.githubusercontent.com/u/4688741?v=3","gravatar_id":"","url":"https://api.github.com/users/blindpenguin","html_url":"https://github.com/blindpenguin","followers_url":"https://api.github.com/users/blindpenguin/followers","following_url":"https://api.github.com/users/blindpenguin/following{/other_user}","gists_url":"https://api.github.com/users/blindpenguin/gists{/gist_id}","starred_url":"https://api.github.com/users/blindpenguin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/blindpenguin/subscriptions","organizations_url":"https://api.github.com/users/blindpenguin/orgs","repos_url":"https://api.github.com/users/blindpenguin/repos","events_url":"https://api.github.com/users/blindpenguin/events{/privacy}","received_events_url":"https://api.github.com/users/blindpenguin/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2016-02-09T16:54:02Z","updated_at":"2016-02-11T07:35:11Z","closed_at":null,"body":"Hi there,\r\n\r\nin classical SQL i can select specific columns i want to know. Something like:\r\n\r\n`select username, email from users;`\r\n\r\nMaybe i'm blind, but i didn't find the relevant part in the documentation. Or i just don't understand it. So how exactly can i get those columns?\r\n\r\nMy current implementation using the paginate function:\r\n\r\n`$thing = $collection->paginate(0, $limit, null, [\r\n                'order' => 'username, company asc',\r\n            ]);`\r\n\r\nIgnore that \"$collection\". I just changed everything from Mongo to MySQL."},"comment":{"url":"https://api.github.com/repos/ikkez/f3-cortex/issues/comments/182748678","html_url":"https://github.com/ikkez/f3-cortex/issues/17#issuecomment-182748678","issue_url":"https://api.github.com/repos/ikkez/f3-cortex/issues/17","id":182748678,"user":{"login":"ikkez","id":1177647,"avatar_url":"https://avatars.githubusercontent.com/u/1177647?v=3","gravatar_id":"","url":"https://api.github.com/users/ikkez","html_url":"https://github.com/ikkez","followers_url":"https://api.github.com/users/ikkez/followers","following_url":"https://api.github.com/users/ikkez/following{/other_user}","gists_url":"https://api.github.com/users/ikkez/gists{/gist_id}","starred_url":"https://api.github.com/users/ikkez/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ikkez/subscriptions","organizations_url":"https://api.github.com/users/ikkez/orgs","repos_url":"https://api.github.com/users/ikkez/repos","events_url":"https://api.github.com/users/ikkez/events{/privacy}","received_events_url":"https://api.github.com/users/ikkez/received_events","type":"User","site_admin":false},"created_at":"2016-02-11T07:35:11Z","updated_at":"2016-02-11T07:35:11Z","body":"Sorry, I cannot reproduce this. It's working as expected here. Which versions do you use? Try to update F3, because basically this field limitation is being used from the underlying F3 SQL mapper."}}