is it just as simple as naming the field?
# prisma-whats-new
m
is it just as simple as naming the field?
a
@mentallyretired The type is used for the quick screenshot was not the best one, but every field in your Type is available as filter
with some limitations for JSON fields I guess
m
right but I'm trying to compare two fields in the query
so lastSync (DateTime) vs lastUpdate (DateTime)
and only pull back the records that have been updated since the last sync
can I do that without a second query?
a
So you know lastSync already on the client don't you?
m
no
a
in that case, the only workaround I know if using a permission query, but I don't know if that fits your use case
Where does lastSync come from?
m
its a field on my "table"
my product collection has lastSync and lastUpdate
and I need to select the products that have been updated (in my admin) since the last time they were synced (to shopify)
a
afraid that's not possible
m
dang. k
thanks for the help 🙂
😎 1
n
@mentallyretired taking a step back you can probably sync them directly to shopify when they are updated using SSS function