{"action":"created","issue":{"url":"https://api.github.com/repos/graphql-python/graphene-sqlalchemy/issues/54","repository_url":"https://api.github.com/repos/graphql-python/graphene-sqlalchemy","labels_url":"https://api.github.com/repos/graphql-python/graphene-sqlalchemy/issues/54/labels{/name}","comments_url":"https://api.github.com/repos/graphql-python/graphene-sqlalchemy/issues/54/comments","events_url":"https://api.github.com/repos/graphql-python/graphene-sqlalchemy/issues/54/events","html_url":"https://github.com/graphql-python/graphene-sqlalchemy/issues/54","id":236251894,"node_id":"MDU6SXNzdWUyMzYyNTE4OTQ=","number":54,"title":"how to Join with get_query","user":{"login":"ssomnoremac","id":3521359,"node_id":"MDQ6VXNlcjM1MjEzNTk=","avatar_url":"https://avatars1.githubusercontent.com/u/3521359?v=4","gravatar_id":"","url":"https://api.github.com/users/ssomnoremac","html_url":"https://github.com/ssomnoremac","followers_url":"https://api.github.com/users/ssomnoremac/followers","following_url":"https://api.github.com/users/ssomnoremac/following{/other_user}","gists_url":"https://api.github.com/users/ssomnoremac/gists{/gist_id}","starred_url":"https://api.github.com/users/ssomnoremac/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ssomnoremac/subscriptions","organizations_url":"https://api.github.com/users/ssomnoremac/orgs","repos_url":"https://api.github.com/users/ssomnoremac/repos","events_url":"https://api.github.com/users/ssomnoremac/events{/privacy}","received_events_url":"https://api.github.com/users/ssomnoremac/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2017-06-15T16:48:49Z","updated_at":"2018-11-22T17:15:27Z","closed_at":null,"author_association":"NONE","body":"Just trying to filter on a field from a foreign table.\r\n\r\nThis doesn't seem to work\r\n```\r\ndef resolve_articles(self, args, context, info):\r\n        query = Article.get_query(context)\r\n        authorName = args.get('authorName')\r\n        return query.join(Author).filter(Author.name == authorName)\r\n```\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/graphql-python/graphene-sqlalchemy/issues/comments/441088398","html_url":"https://github.com/graphql-python/graphene-sqlalchemy/issues/54#issuecomment-441088398","issue_url":"https://api.github.com/repos/graphql-python/graphene-sqlalchemy/issues/54","id":441088398,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0MTA4ODM5OA==","user":{"login":"zhanibekshynarbek","id":13959295,"node_id":"MDQ6VXNlcjEzOTU5Mjk1","avatar_url":"https://avatars1.githubusercontent.com/u/13959295?v=4","gravatar_id":"","url":"https://api.github.com/users/zhanibekshynarbek","html_url":"https://github.com/zhanibekshynarbek","followers_url":"https://api.github.com/users/zhanibekshynarbek/followers","following_url":"https://api.github.com/users/zhanibekshynarbek/following{/other_user}","gists_url":"https://api.github.com/users/zhanibekshynarbek/gists{/gist_id}","starred_url":"https://api.github.com/users/zhanibekshynarbek/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zhanibekshynarbek/subscriptions","organizations_url":"https://api.github.com/users/zhanibekshynarbek/orgs","repos_url":"https://api.github.com/users/zhanibekshynarbek/repos","events_url":"https://api.github.com/users/zhanibekshynarbek/events{/privacy}","received_events_url":"https://api.github.com/users/zhanibekshynarbek/received_events","type":"User","site_admin":false},"created_at":"2018-11-22T17:15:27Z","updated_at":"2018-11-22T17:15:27Z","author_association":"NONE","body":"Hey. thanks for the reply. I need to explicitly specify the required fields and I don't use `relationship` only `ForeignKey` \r\nAdding `add_columns` to the query gets the error as above. I have a lot of fields that need to be associated with many tables if the field is requested.\r\n\r\n```Python\r\n    if 'authorName' in requested_fields:\r\n        query = query.add_columns(Author.name.label('author_name'))\r\n```\r\nI wanted to make such request"}}
{"actor":{"display_login":"zhanibekshynarbek"}}