Looks like this ticket never got documented:
https://issues.apache.org/jira/browse/SOLR-10303
In your case you'll want to use the epoch function which returns unix time:
select(search(collection),
epoch(date_dt) as utime)
I'll create a jira to document this feature.
Joel Bernstein
http://joelsolr.blogspot.com/
On Tue, Jun 6, 2023 at 9:29 AM Susheel Kumar <[email protected]> wrote:
> Hello,
>
> How can we take a minimum date in a grouping scenario. I tried using the
> min function but it converts all dates to a fixed e Value.
>
> rollup(
> search(employee_position,
> q="*:*",
> qt="/export",
> fl="EMPLOYEE_ID_s,POSITION_ID_s,HIRE_DATE_dt",
> df="_text_",
> sort="POSITION_ID_s asc, HIRE_DATE_dt asc"),
> over="POSITION_ID_s",
> count(HIRE_DATE_dt),
> min(HIRE_DATE_dt))
>
>
> ==
> "docs": [
> {
> "min(HIRE_DATE_dt)": 1.7976931348623157e+308,
> "POSITION_ID_s": "017681N",
> "count(HIRE_DATE_dt)": 1
> },
> {
> "min(HIRE_DATE_dt)": 1.7976931348623157e+308,
> "POSITION_ID_s": "017686N",
> "count(HIRE_DATE_dt)": 2
> },
>
