在C# Elastic.Clients.Elasticsearch中实现appointmentdate降序排序

问题背景 #

使用C#的Elastic.Clients.Elasticsearch库（非Nest）编写的日期范围查询已正常运行，需要添加排序功能，使结果按appointmentdate字段降序展示。

原查询代码 #

if (!string.IsNullOrEmpty(formData.DateFrom))
{
    if (!string.IsNullOrEmpty(formData.DateTo))
    {
        // 同时提供DateFrom和DateTo
        mustQueries.Add(new DateRangeQuery(Infer.Field<PatientTimeline>(f => f.appointmentdate))
        {
            Gt = DateTime.ParseExact(formData.DateFrom, "yyyy-MM-ddTHH:mm:ssZ", CultureInfo.InvariantCulture, DateTimeStyles.AssumeUniversal),
            Lt = DateTime.ParseExact(formData.DateTo, "yyyy-MM-ddTHH:mm:ssZ", CultureInfo.InvariantCulture, DateTimeStyles.AssumeUniversal),
            TimeZone = "Z",
            Boost = 1.0F,
        });
    }
    else
    {
        // 仅提供DateFrom
        mustQueries.Add(new DateRangeQuery(Infer.Field<PatientTimeline>(f => f.appointmentdate))
        {
            Gt = DateTime.ParseExact(formData.DateFrom, "yyyy-MM-ddTHH:mm:ssZ", CultureInfo.InvariantCulture, DateTimeStyles.AssumeUniversal),
            TimeZone = "Z",
            Boost = 1.0F,
        });
    }
}

if (!string.IsNullOrEmpty(formData.DateTo))
{
    // 仅提供DateTo
    mustQueries.Add(new DateRangeQuery(Infer.Field<PatientTimeline>(f => f.appointmentdate))
    {
        Lt = DateTime.ParseExact(formData.DateTo, "yyyy-MM-ddTHH:mm:ssZ", CultureInfo.InvariantCulture, DateTimeStyles.AssumeUniversal),
        TimeZone = "Z",
        Boost = 1.0F,
    });
}

添加排序的完整代码实现 #

在构建SearchRequest时，通过Sort属性配置按appointmentdate降序排序，注意时区与日期查询保持一致：

// 原日期范围查询逻辑（保留不变）
var mustQueries = new List<Query>();

if (!string.IsNullOrEmpty(formData.DateFrom))
{
    if (!string.IsNullOrEmpty(formData.DateTo))
    {
        mustQueries.Add(new DateRangeQuery(Infer.Field<PatientTimeline>(f => f.appointmentdate))
        {
            Gt = DateTime.ParseExact(formData.DateFrom, "yyyy-MM-ddTHH:mm:ssZ", CultureInfo.InvariantCulture, DateTimeStyles.AssumeUniversal),
            Lt = DateTime.ParseExact(formData.DateTo, "yyyy-MM-ddTHH:mm:ssZ", CultureInfo.InvariantCulture, DateTimeStyles.AssumeUniversal),
            TimeZone = "Z",
            Boost = 1.0F,
        });
    }
    else
    {
        mustQueries.Add(new DateRangeQuery(Infer.Field<PatientTimeline>(f => f.appointmentdate))
        {
            Gt = DateTime.ParseExact(formData.DateFrom, "yyyy-MM-ddTHH:mm:ssZ", CultureInfo.InvariantCulture, DateTimeStyles.AssumeUniversal),
            TimeZone = "Z",
            Boost = 1.0F,
        });
    }
}

if (!string.IsNullOrEmpty(formData.DateTo))
{
    mustQueries.Add(new DateRangeQuery(Infer.Field<PatientTimeline>(f => f.appointmentdate))
    {
        Lt = DateTime.ParseExact(formData.DateTo, "yyyy-MM-ddTHH:mm:ssZ", CultureInfo.InvariantCulture, DateTimeStyles.AssumeUniversal),
        TimeZone = "Z",
        Boost = 1.0F,
    });
}

// 构建包含排序的查询请求
var searchRequest = new SearchRequest<PatientTimeline>
{
    Query = new BoolQuery { Must = mustQueries },
    Sort = new List<SortOptions>
    {
        new FieldSort
        {
            Field = Infer.Field<PatientTimeline>(f => f.appointmentdate),
            Order = SortOrder.Desc, // 降序排序
            TimeZone = "Z" // 与日期查询时区保持一致，避免排序偏差
        }
    }
};

// 执行查询（假设_client是你的Elasticsearch客户端实例）
var response = await _client.SearchAsync<PatientTimeline>(searchRequest);

关键说明 #

• 使用FieldSort指定排序字段，通过SortOrder.Desc实现降序排列
• 配置TimeZone = "Z"与日期查询的时区一致，确保排序结果基于正确的时间维度
• 将排序配置与原查询逻辑整合到SearchRequest中，一起提交给Elasticsearch执行

内容的提问来源于stack exchange，提问作者Jahanzaib