How to specify value for "attdate" within search?

While restricting search on attachments you can specify fields like “filename”,“attauthor_display” even with wildcard. That works fine.
But I didn’t find the correct syntax for specifying any “attdate” value (date when the last version of the attachment was uploaded).

Is it possible at all?

There is an additional question: Is it possible to specify a date range ?

Thanks

In the meantime I found the information I was looking for.

This helps:

range -> attdate:[2020-12-01T00:00:00.000Z TO 2020-12-02T23:59:59.999Z]

/HOUR 
/DAY 
/MONTH 
/YEAR round to the beginning of hour,day,month,year

with rounding attdate:[2020-12-20T12:34:56.789Z/MONTH TO 2020-01-31T23:59:59.999Z]

today        ->  attdate:[NOW-1DAY/DAY TO *]
yesterday    ->  attdate:[NOW-1DAY/DAY TO NOW/DAY]
last month   ->  attdate:[NOW-1MONTH/MONTH TO NOW/MONTH]
last year    ->  attdate:[NOW-1YEAR/YEAR TO NOW/YEAR]

all pdf attachments uploaded yesterday`

mimetype:application/pdf && attdate:[NOW-1DAY/DAY TO NOW/DAY]

This link helped: Working with Dates | Apache Solr Reference Guide 6.6

1 Like

Thanks for posting back, quite useful!

Would be awesome to add this info to https://extensions.xwiki.org/xwiki/bin/view/Extension/Solr%20Search%20Application#HSearchSyntax IMO (don’t hesitate to add it, it’s a wiki ;)).

Thanks a lot