Hi all, I was wondering if it was possible to filt...
# troubleshoot
b
Hi all, I was wondering if it was possible to filter a graphQL query by its
timestampMillis
?
Here's the query I'm using right now:
Copy code
{
  search(
    input: {type: DATASET, query: "*", start:0, count: 10 }
  ) {
    start
    count
    total
    searchResults {
      entity {
        urn
        type
        ... on Dataset {
          name
          datasetProfiles(limit:10) {
            timestampMillis
            columnCount
            rowCount
            fieldProfiles {
              fieldPath
              nullCount
              nullProportion
              uniqueCount
              uniqueProportion
              min
              max
              mean
              median
              stdev
              sampleValues
            }
          }
        }
      }
      matchedFields{
        name
        value
      }
    }
  }
}
But every variation of
filters
I've tried has returned 0 results. I've also tried this on a specific dataset (rather than
query: "*"
) with no luck
Nevermind, figured it out!
Copy code
{
  search(
    input: {type: DATASET, query: "db.table", start:0, count: 10 }
  ) {
    start
    count
    total
    searchResults {
      entity {
        urn
        type
        ... on Dataset {
          name
          datasetProfiles(limit:10, startTimeMillis:1658861887172) {
            timestampMillis
            columnCount
            rowCount
            fieldProfiles {
              fieldPath
              nullCount
              nullProportion
              uniqueCount
              uniqueProportion
              min
              max
              mean
              median
              stdev
              sampleValues
            }
          }
        }
      }
    }
  }
}