Query to delete duplicates

Something like this

upsert {
  query {
     Q1 as q(func: has(project.office)){
      PO as project.office
      project.title
  }
    q2(func: uid(Q1)){
      office @filter(NOT eq(office.name, val(PO))) {
        TODELETE as uid
        office.name
      }
    }
  }

  mutation {
    delete {
      uid(Q1) <office> uid(TODELETE) .
    }
  }
}
2 Likes