Question on case exports and last_modified_date

When setting a date range for case exports, a subtext is displayed in the
browser:
Export cases modified in this date range

If I set my date range to 1-May to 7 May, which of the following cases will
be exported?

a) Only cases where the last_modified_date is within the range
OR
b) All cases that were modified (or created) in the range, even if the
last_modified_date is not within the range
OR
c) Something else

Thanks,
Andrew

Hi Andrew,

The answer to your question is A.

For further clarity, every time a case is created the same date/time stamp
will be saved to opened_date and last_modified_date. When the case is
modified in some way last_modified_date field will update, while
opened_date will remain the same. Therefore your Option A would include any
cases created OR modified in that date range.

Hope this helps!

Lauren

Lauren N. Fox
Dimagi, Inc.
RPCV Mozambique '07-'11

RSA: +27 (0) 81 831 4290
Moz: +258 82 78 49 245
dimagi.com http://www.dimagi.com/ *| *commcarehq.org

··· On Wed, May 10, 2017 at 4:24 PM, Andrew Cawood wrote:

When setting a date range for case exports, a subtext is displayed in the
browser:
Export cases modified in this date range

If I set my date range to 1-May to 7 May, which of the following cases
will be exported?

a) Only cases where the last_modified_date is within the range
OR
b) All cases that were modified (or created) in the range, even if the
last_modified_date is not within the range
OR
c) Something else

Thanks,
Andrew


You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Hi Lauren,

Thanks for your response - it’s given some insight, but I’d still like to
clarify with an example:

Consider these 3 cases:
(a) Created on 2 May, not modified thereafter
(b) Created on 2 May, modified on 15 May
© Created on 1 April, modified on 2 May
(d) Created on 1 April, modified on 2 May, modified again on 15 May

I now (on 16 May) do a case export with date range 1 May to 7 May.
Which cases will be included in the export?

From what you’ve said, the cases should now have the following datestamps:
(a) opened_date: 2 May last_modified_date: 2 May
(b) opened_date: 2 May last_modified_date: 15 May
© opened_date: 1 April last_modified_date: 2 May
(d) opened_date: 1 April last_modified_date: 15 May

Please would you confirm/comment on the following:
(a) Will be included
(b) Will not be included as last_modified_date is not in range (even though
it was created in the range)
© Will be included - last_modified_date is in the range
(d) Will not be included - last_modified_date is not in range. (even though
it was actually modified in the range)

Thanks,
Andrew

··· ---------------------

On 15 May 2017 at 19:16, Lauren Fox lfox@dimagi.com wrote:

Hi Andrew,

The answer to your question is A.

For further clarity, every time a case is created the same date/time stamp
will be saved to opened_date and last_modified_date. When the case is
modified in some way last_modified_date field will update, while
opened_date will remain the same. Therefore your Option A would include any
cases created OR modified in that date range.

Hope this helps!

Lauren

Lauren N. Fox
Dimagi, Inc.
RPCV Mozambique '07-'11

RSA: +27 (0) 81 831 4290
Moz: +258 82 78 49 245
dimagi.com http://www.dimagi.com/ *| *commcarehq.org

On Wed, May 10, 2017 at 4:24 PM, Andrew Cawood acawood777@gmail.com wrote:

When setting a date range for case exports, a subtext is displayed in the
browser:
Export cases modified in this date range

If I set my date range to 1-May to 7 May, which of the following cases
will be exported?

a) Only cases where the last_modified_date is within the range
OR
b) All cases that were modified (or created) in the range, even if the
last_modified_date is not within the range
OR
c) Something else

Thanks,
Andrew


You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


You received this message because you are subscribed to a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit https://groups.google.com/d/
topic/commcare-users/oZTRG0XuX1U/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.