hi i am trying to query id from user , the select ...
# orm-helpm
Mahmoud El Kotoury
04/17/2019, 4:34 PMhi i am trying to query id from user , the select statement is always selecting all and not id or the specified field , can any one help
c
cedric
04/17/2019, 4:41 PMcan you paste the query you're running?
m
Mahmoud El Kotoury
04/17/2019, 4:50 PMok 1 second
Mahmoud El Kotoury
04/17/2019, 4:52 PM Copy code
query {
user(id:"%USERID%") {
email
}
}Mahmoud El Kotoury
04/17/2019, 4:52 PMit select all fields in user table first
Mahmoud El Kotoury
04/17/2019, 4:56 PMname , password etc..
Mahmoud El Kotoury
04/17/2019, 4:56 PMwhile I only need the email field
Mahmoud El Kotoury
04/17/2019, 4:57 PMMahmoud El Kotoury
04/17/2019, 5:27 PM@cedric any help would be appreciated brother
c
cedric
04/17/2019, 6:07 PMapologies, i got pulled into a phone call
cedric
04/17/2019, 6:08 PMit's possible that it selects all fields from the database by-design, but then filters what gets returned by the graphql response based on the fragment
cedric
04/17/2019, 6:09 PMi'm not certain of the internals on how prisma constructs its sql queries unfortunately
m
Mahmoud El Kotoury
04/18/2019, 10:19 AMthank you @cedric
Mahmoud El Kotoury
04/18/2019, 10:19 AMbut isn't there a way to optimize that?
Mahmoud El Kotoury
04/18/2019, 11:16 AMis there a way to solve that?
3 Views