Hi guys, How do you address snapshot-based SuiteQ...
# suiteql
p
Hi guys, How do you address snapshot-based SuiteQL pagination via REST API? Example (simplified):
SELECT id FROM transaction WHERE lastModifiedDate > 5s ago
--- The issue I'm getting is that if a transaction on page 1 is modified then it also jumps to the last page of ever-changing results.
r
Instead of 5 seconds ago. Get the date time of current time and 5 seconds ago time. So transaction date modified is less than currenttime and greater then 5 seconds ago time So even after running your query some other transaction gets updated it will still not show up as the date modified on it will be greater than current time in your query.