"{\"prefix\":{\"site\":{\"value\":\"aaa\",\"boost\":1.0}}}", //
                "site:aaa");

        assertQueryBuilder("{\"timestamp\":{\"order\":\"asc\"}}", "sort:timestamp");
        assertQueryBuilder("{\"timestamp\":{\"order\":\"asc\"}}", "sort:timestamp.asc");
        assertQueryBuilder("{\"timestamp\":{\"order\":\"desc\"}}", "sort:timestamp.desc");

        try {
            assertQueryBuilder("", "sort:xxx");

labels.search_result_sort_filename_asc=by Filename (asc)
labels.search_result_sort_filename_desc=by Filename (desc)
labels.search_result_sort_created_asc=by Date (asc)
labels.search_result_sort_created_desc=by Date (desc)
labels.search_result_sort_content_length_asc=by Size (asc)
labels.search_result_sort_content_length_desc=by Size (desc)
labels.search_result_sort_last_modified_asc=by Last Modified (asc)

                Set.of(), //
                "{\"timestamp\":{\"order\":\"asc\"}}", //
                buildQuery("sort:timestamp"));
        assertQueryContext(query, Map.of(), //
                Set.of(), //
                "{\"timestamp\":{\"order\":\"asc\"}}", //
                buildQuery("sort:timestamp.asc"));
        assertQueryContext(query, Map.of(), //
                Set.of(), //

labels.search_result_sort_filename_asc=by Filename (asc)
labels.search_result_sort_filename_desc=by Filename (desc)
labels.search_result_sort_created_asc=by Date (asc)
labels.search_result_sort_created_desc=by Date (desc)
labels.search_result_sort_content_length_asc=by Size (asc)
labels.search_result_sort_content_length_desc=by Size (desc)
labels.search_result_sort_last_modified_asc=by Last Modified (asc)

	return nil
}

// ToSQL for generate SQL string.
//
//	db.ToSQL(func(tx *gorm.DB) *gorm.DB {
//			return tx.Model(&User{}).Where(&User{Name: "foo", Age: 20})
//				.Limit(10).Offset(5)
//				.Order("name ASC")
//				.First(&User{})
//	})
func (db *DB) ToSQL(queryFn func(tx *DB) *DB) string {
	tx := queryFn(db.Session(&Session{DryRun: true, SkipDefaultTransaction: true}).getInstance())
	stmt := tx.Statement

    /** The key of the message: by Filename (asc) */
    public static final String LABELS_search_result_sort_filename_asc = "{labels.search_result_sort_filename_asc}";

    /** The key of the message: by Filename (desc) */
    public static final String LABELS_search_result_sort_filename_desc = "{labels.search_result_sort_filename_desc}";

    /** The key of the message: by Date (asc) */

                        "must_not", List.of( //
                                Map.of("term", Map.of("instanceId", instanceId))))), //
                "size", 100, //
                "sort", List.of(Map.of("createdTime", "asc"))));

        try (CurlResponse response = ComponentUtil.getCurlHelper() //
                .post("/" + getIndexName() + "/_search") //
                .body(query)
                .execute()) {

        assertNotNull(order);
        assertEquals(BucketOrder.count(false), order);
    }

    // Test getBucketOrder with count.asc
    @Test
    public void test_getBucketOrder_countAsc() {
        facetInfo.sort = "count.asc";
        BucketOrder order = facetInfo.getBucketOrder();
        assertNotNull(order);
        assertEquals(BucketOrder.count(true), order);
    }

						<la:message key="labels.searchoptions_score" />
					</c:if> <c:if test="${sort=='filename.asc'}">
						<la:message key="labels.search_result_sort_filename_asc" />
					</c:if> <c:if test="${sort=='filename.desc'}">
						<la:message key="labels.search_result_sort_filename_desc" />
					</c:if> <c:if test="${sort=='created.asc'}">
						<la:message key="labels.search_result_sort_created_asc" />

						</la:option>
						<la:option value="filename.asc">
							<la:message key="labels.search_result_sort_filename_asc" />
						</la:option>
						<la:option value="filename.desc">
							<la:message key="labels.search_result_sort_filename_desc" />
						</la:option>
						<la:option value="created.asc">
							<la:message key="labels.search_result_sort_created_asc" />
						</la:option>