Hi @Hanish N ,
thank you for your question. We have this specific usecase covered in our documentation, please see here:
https://docs.ataccama.com/one/16.1.0/one-apis/one-api.html#dq-results section Filter
When obtaining the DQ results via API, you can add the filter part (example):
filter: e
{
attributeId: "d3c8da98-0dea-4523-903c-cbc4a3f28e8b"
values: e"Fire", "Water", "Grass"]
}
{
attributeId: "00e71092-a53b-47f4-ae50-792b777609e7"
values: e"Blastoise", "Bulbasaur", "Charizard"]}
]
Down below is an example for the whole API call including the filter: https://docs.ataccama.com/one/16.1.0/one-apis/one-api.html#dq-results:~:text=GraphQL%20query%20for%20retrieving%20basic%20monitoring%20results
Let me know if this is what you were looking for.
Kind regards,
Anna
Instead of passing value, can’t we get stats of all values of that column?
for ex:
country passed count failed count total
US 140 60 200
IND 180 120 300
CHI 70 50 120
We can’t give all the values in filter right as the values are dynamic. Do we have any query for that?
Hi @Hanish N ,
checking the documentation, I believe it should be possible to use #ALL#
as a value and that should give all of them:
https://docs.ataccama.com/one/latest/one-apis/one-api.html#filter-values
There is also the API call that will give you all possible values for the filters on an attribute:
query ProcessingFilterValues {
monitoringProjectProcessing(gid: "da0be1f4-c8c2-430e-85ee-747861e357e6"){
publishedVersion {
dqFilterValues(catalogItemId: "6f589e83-ebd4-4486-8b79-f7d0498e6c6e"){
name
values
attributeId
order
}
}
}
}
One of them is the #ALL# so I would try with that.
Kind regards,
Anna