Apex Code Development You need to sign in to do that
Don't have an account?
Query based on SystemModstamp - I'm seeing objects which should not be there
Hi,
I am running a query which performs a select based on the SystemModstamp which looks like
select field, field, field where SystemModstamp > DateTime
where DateTime is in UTC and of the form 1999-01-01T23:01:01Z. The call is returning objects even when I set the time to 30 minutes into the future from the current time. I also tried specifying the time in the form 1999-01-01T23:01:01-08:00 but had the same issue.
I thought that this was a timezone issue, but I see that the time string is correct when I debug and inspect the query going across. Also, it seems that if I was looking at 2 hours into the future (on one attempt), no objects would be returned but at 1 hour into the future, I was still retrieving objects.
I am using the partner WSDL with .Net 1.1 and my timezone is PST.
Has anyone else run into a similar issue or have any insights to offer?
Thanks,
Chirayu.
I am running a query which performs a select based on the SystemModstamp which looks like
select field, field, field where SystemModstamp > DateTime
where DateTime is in UTC and of the form 1999-01-01T23:01:01Z. The call is returning objects even when I set the time to 30 minutes into the future from the current time. I also tried specifying the time in the form 1999-01-01T23:01:01-08:00 but had the same issue.
I thought that this was a timezone issue, but I see that the time string is correct when I debug and inspect the query going across. Also, it seems that if I was looking at 2 hours into the future (on one attempt), no objects would be returned but at 1 hour into the future, I was still retrieving objects.
I am using the partner WSDL with .Net 1.1 and my timezone is PST.
Has anyone else run into a similar issue or have any insights to offer?
Thanks,
Chirayu.
Yes, running a querries via the restful api also returns unexpected results when limiting by systemmodstamp. This is the kind of stuff I have come to expect,.