from corehq.apps.es import CaseES
from corehq.apps.es import FormES


def get_form_export_base_query(domain, xmlns):
    # TODO: This probably needs app_id too
    return (FormES().
            domain(domain)
            .xmlns(xmlns)
            .sort("received_on"))


def get_case_export_base_query(domain, case_type):
    return (CaseES()
            .domain(domain)
            .case_type(case_type)
            .sort("modified_on"))

from corehq.apps.es import CaseES
from corehq.apps.es import FormES


def get_form_export_base_query(domain, xmlns):
    # TODO: This probably needs app_id too
    return (FormES().
            domain(domain)
            .xmlns(xmlns)
            .sort("received_on"))


def get_case_export_base_query(domain, case_type):
    return (CaseES()
            .domain(domain)
            .case_type(case_type)
            .sort("opened_on"))

Sort cases by opened_on, not modified_on
Sort cases by opened_on, not modified_on

Addresses
https://github.com/dimagi/commcare-hq/pull/10187/files#r51863935
