The `Action` view in myDIG is messed Up. See attached pic

[saggu]

[saggu]

This is after I deleted all the documents with tld = cfr.org

[GreatYYX]

from es manually? how is _db.json, have u changed it manually before?

[saggu]

Yes, from ES manually. Havent touched _db.json today. Curious as to how does that query work? TO get the KG to show on mydig?

[GreatYYX]

complete query: https://github.com/usc-isi-i2/mydig-webservice/blob/master/ws/ws.py#L2245

[GreatYYX]

Basically, myDIG gets kg and kg original from es directly and full join them with the tlds which appear in catalog. kg original is restricted by term created_by: etk.

[saggu]

[saggu]

What is happening here ^ ?

[GreatYYX]

can u try above query in kibana

[saggu]

Result of

{
  "query": {
    "term": {
      "knowledge_graph.website.key": {
        "value": "cfr.org"
      }
    }
  }
}

is 1222

and result of

POST sage_kg/_search
 {
              "aggs": {
                  "group_by_tld_original": {
                    "filter": {
                      "bool": {
                        "must_not": {
                          "term": {
                            "created_by": "etk"
                          }
                        }
                      }
                    },
                    "aggs": {
                      "grouped": {
                        "terms": {
                          "field": "tld.raw",
                          "size": 2147483647
                        }
                      }
                    }
                  },
                  "group_by_tld": {
                    "terms": {
                      "field": "tld.raw",
                      "size": 2147483647
                    }
                  }
              },
              "size":0
            }

has that number to be 5872.

Looks wrong

[GreatYYX]

myDIG's query is based on TLD in CDR, ur term query is based on website in kg.

[GreatYYX]

btw, in latest mydig, delete by tld is also based on tld.raw, knowledge_graph.website is not sufficient in some cases (e.g., if no website is extracted).

[GreatYYX]

@saggu close it? what about #190

[saggu]

Yeah, I guess. Closing this