Re: sql datetime field aggregation

2023-08-21 Thread Kojo
Sent: Monday, August 21, 2023 4:45 PM > To: users@solr.apache.org > Subject: RE: sql datetime field aggregation > > I didn’t use it too much but I’d guess syntax support for sql would be > limited to simple things. I’d love to learn if anybody has knowledge on the > sql handler. >

RE: sql datetime field aggregation

2023-08-21 Thread ufuk yılmaz
uot;select NAME, ADDRESS, EMAIL, AGE from PEOPLE where AGE > 25 order by AGE, NAME DESC", sort="AGE asc, NAME desc" ) Sent from Mail for Windows From: ufuk yılmaz Sent: Monday, August 21, 2023 4:45 PM To: users@solr.apache.org Subject: RE: sql datetime field aggregation I did

RE: sql datetime field aggregation

2023-08-21 Thread ufuk yılmaz
I didn’t use it too much but I’d guess syntax support for sql would be limited to simple things. I’d love to learn if anybody has knowledge on the sql handler. If your field is indexed using datetime field type or long number since epoch, then range faceting could be a way to group based on mont