3 lines
1.4 KiB
Markdown
3 lines
1.4 KiB
Markdown
- #Work
|
|
- Get All Docs from solr before 2023 and after that
|
|
- http://tools.k8s-c1.vicosrv.de/module/customer/163,168,178,183,194,210,211,212,216,217,218,220,224,227,231,232,233,236,237,240,241,243,244,246,247,248,249,250,251,808/solr?jq=map(%7B%22pid%22%3A.customer.project.id%2C%20%22cid%22%3A.customer.customerId%2C%20%22before_2023%22%3A.rawResponse.facet_counts.facet_ranges.pubDate.counts%20%7C%20(if%20.%20%3D%3D%20null%20then%200%20else%20(.%20%7C%20to_entries%20%7C%20%20map(select(.key%20%3C%20%222023-01-01T00%3A00%3A00Z%22))%20%7C%20map(.value)%20%7C%20add)%20end)%20%2C%20%22after_2023%22%3A.rawResponse.facet_counts.facet_ranges.pubDate.counts%20%7C%20(if%20.%20%3D%3D%20null%20then%200%20else%20(.%20%7C%20to_entries%20%7C%20%20map(select(.key%20%3E%3D%20%222023-01-01T00%3A00%3A00Z%22))%20%7C%20map(.value)%20%7C%20add)%20end)%20%2C%20%22sum%22%3A.rawResponse.facet_counts.facet_ranges.pubDate.counts%20%7C%20(if%20.%20%3D%3D%20null%20then%200%20else%20(.%20%7C%20to_entries%20%7C%20map(.value)%20%7C%20add)%20end)%20%20%7D)%20%7C%20sort_by(.sum)%20%7C%20reverse%5B%5D%20%20%7C%20%5B.pid%2C%20.cid%2C%20.before_2023%2C%20.after_2023%2C%20.sum%5D%20%7C%20%40csv&query=q.op%3DOR%26q%3D*%253A*%26facet.range.gap%3D%252B1YEAR%26facet%3Dtrue%26facet.range%3DpubDate%26facet.range.start%3D2000-01-01T00%3A00%3A00Z%26facet.range.end%3D2025-01-01T00%3A00%3A00Z%26rows%3D0%26facet.mincount%3D1&raw=true |