helix-query.yaml

version: 1

indices:
  english: &default
    source: html
    fetch: https://{repo}--{owner}.hlx.page/{path}
    include:
      - en/publish/*/*/*/*.(md|docx)
    exclude:
      - '**/Document.*'
    target: https://adobe.sharepoint.com/:x:/r/sites/TheBlog/Shared%20Documents/theblog/en/query-index.xlsx?d=w9b11cf8528564434a5363b1c13699d0f&csf=1&web=1&e=crkaXh
    sitemap: en/query-index.json
    properties:
      author:
        select: main > div:nth-of-type(3) > p:nth-of-type(1)
        value: |
          match(el, '[bB]y (.*)')
      title:
        select: main > div > h1:first-of-type
        value: |
          textContent(el)
      date:
        select: main > div:nth-of-type(3)
        value: |
          parseTimestamp(match(el, '[Oo][Nn] \\d\\d-\\d\\d-\\d\\d\\d\\d'), 'MM-DD-YYYY')
      topics:
        select: main > div:last-of-type > p:first-of-type
        values: |
          match(el, '(Topics: )? ([^,]+)')
      products:
        select: main > div:last-of-type > p:nth-of-type(2)
        values: |
          match(el, '(Products: )? ([^,]+)')
      hero:
        select: main > div:nth-of-type(2) img:first-of-type
        value: |
          attribute(el, 'src')
      teaser:
        select: main > div:nth-child(n+4):not(:last-child) p
        value: |
          words(textContent(el), 0, 20)
      sourceHash:
        select: head > meta[name=x-source-hash
        value: |
          attribute(el, 'content')
      external-path:
        select: none
        value: |
          replace(path, '/publish/', '/')
    queries:
      recent:
        query: "*"
        hitsPerPage: 12
        parameters:
          - language
          - context
          - date
        filters: |
          parents:"${context}${language}" AND date < ${date}
        cache: 600
      recent-by-author:
        query: "*"
        hitsPerPage: 12
        parameters:
          - language
          - context
          - date
          - author
        filters: |
          parents:"${context}${language}" AND date < ${date} AND author:"${author}"
        cache: 600
      recent-by-topic:
        query: "*"
        hitsPerPage: 12
        parameters:
          - language
          - context
          - date
          - topic
        filters: |
          parents:"${context}${language}" AND date < ${date} AND topics:"${topic}"
        cache: 600

  german:
    <<: *default
    include:
      - de/publish/*/*/*/*.(md|docx)
    target: https://adobe.sharepoint.com/:x:/r/sites/TheBlog/Shared%20Documents/theblog/de/query-index.xlsx?d=w7e4e8437735540cf9a632f486c42c865&csf=1&web=1&e=w3EocR

  korean:
    <<: *default
    include:
      - ko/publish/*/*/*/*.(md|docx)
    target: https://adobe.sharepoint.com/:x:/r/sites/TheBlog/Shared%20Documents/theblog/ko/query-index.xlsx?d=wd29a640f97104e3b8ece1d5b89aba0be&csf=1&web=1&e=K3fruX

  french:
    <<: *default
    include:
      - fr/publish/*/*/*/*.(md|docx)
    target: https://adobe.sharepoint.com/:x:/r/sites/TheBlog/Shared%20Documents/theblog/fr/query-index.xlsx?d=w0e8a21f8b55d4bd48088556c67f95bd4&csf=1&web=1&e=6RuhWr

  italian:
    <<: *default
    include:
      - it/publish/*/*/*/*.(md|docx)
    target: https://adobe.sharepoint.com/:x:/r/sites/TheBlog/Shared%20Documents/theblog/it/query-index.xlsx?d=we2fbc2b08a164958a41bb61f776f3aac&csf=1&web=1&e=k1f9uS

  spanish:
    <<: *default
    include:
      - es/publish/*/*/*/*.(md|docx)
    target: https://adobe.sharepoint.com/:x:/r/sites/TheBlog/Shared%20Documents/theblog/es/query-index.xlsx?d=w89b84177df3b4d0d8f5e54a8390e7bb8&csf=1&web=1&e=qLQZny

  japanese:
    <<: *default
    include:
      - jp/publish/*/*/*/*.(md|docx)
    target: https://adobe.sharepoint.com/:x:/r/sites/TheBlog/Shared%20Documents/theblog/jp/query-index.xlsx?d=wc6a419a78b334addbd61c92845a7d223&csf=1&web=1&e=60wq5c

  brasil:
    <<: *default
    include:
      - br/publish/*/*/*/*.(md|docx)
    target: https://adobe.sharepoint.com/:x:/r/sites/TheBlog/Shared%20Documents/theblog/br/query-index.xlsx?d=wa09c53afbe564829ae0016464bc554c7&csf=1&web=1&e=QVX7d0