Guest User

Untitled

a guest
Jul 17th, 2018
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. {
  2. "size": 0,
  3. "aggs": {
  4. "groupby": {
  5. "terms": {
  6. "script": {
  7. "source": "ZonedDateTime.ofInstant(Instant.ofEpochMilli(doc['CLOSED_DATE'].value.millis), ZoneId.of('UTC')).get(IsoFields.WEEK_OF_WEEK_BASED_YEAR)"
  8. },
  9. "size": 100
  10. }
  11. }
  12. },
  13. "query": {
  14. "bool": {
  15. "must": [
  16. {
  17. "range": {
  18. "CLOSED_DATE": {
  19. "gte": "2018-06-24T00:00:01",
  20. "lte": "2018-06-30T23:59:59",
  21. "time_zone": "UTC"
  22. }
  23. }
  24. }
  25. ]
  26. }
  27. }
  28. }
  29.  
  30. {
  31. "size": 0,
  32. "aggs": {
  33. "groupby": {
  34. "terms": {
  35. "script": {
  36. "source": "doc['CLOSED_DATE'].value.getWeekOfWeekyear()"
  37. },
  38. "size": 100
  39. }
  40. }
  41. },
  42. "query": {
  43. "bool": {
  44. "must": [
  45. {
  46. "range": {
  47. "CLOSED_DATE": {
  48. "gte": "2018-06-24T00:00:01",
  49. "lte": "2018-06-30T23:59:59",
  50. "time_zone": "UTC"
  51. }
  52. }
  53. }
  54. ]
  55. }
  56. }
  57. }
Add Comment
Please, Sign In to add comment