what's the easiest way to filter on a date being g...
# prisma-whats-newc
claym
08/30/2017, 1:41 PMwhat's the easiest way to filter on a date being greater than today?
d
Daniel K.
08/30/2017, 1:43 PMwhat have you tried so far ? 🙂
Daniel K.
08/30/2017, 1:43 PM Copy code
query ($today: DateTime!) {
allUsers(filter: { createdAt_gt: $today }) { id }
}👍🏻 1
c
claym
08/30/2017, 2:32 PMhaha not entirely sure where to start. i take it there's no equivalent to sysdate or now()?
claym
08/30/2017, 2:37 PMi think i got it sorted, thanks.
claym
08/30/2017, 3:11 PMMind if I ask another one of you?
claym
08/30/2017, 3:11 PMThis works in playground:
claym
08/30/2017, 3:11 PMquery getFactors($startDate:DateTime!, $endDate:DateTime!) {
allFactors(orderBy: createdAt_DESC, filter:{
AND: [{
startOn_lte:$startDate,
OR:[{
endOn: null
},{
endOn_gte: $endDate
}]
}]
}) {
id
description
score
}
}
claym
08/30/2017, 3:11 PMhowever, running in my webapp, I get
The inline argument "endOn" of kind "NullValue" is not supported.
Use variables instead of inline arguments to overcome this limitation.
claym
08/30/2017, 3:11 PMwtf am i supposed to do with this 😄
n
nilan
08/30/2017, 3:34 PM@claym, that's a problem with Apollo Client. Again, would love to discuss this in the Forum https://www.graph.cool/forum/ 🙂
c
claym
08/30/2017, 3:56 PMended up figuring it out as I was typing it into the forum 😄 thanks!
n
nilan
08/30/2017, 3:58 PMthe Forum is a magical place ✨ 😂
s
Stefan
08/30/2017, 5:40 PM@claym what's the reason?