Skip to main content

Can we get results at column level where filter is applied. For ex: For Ashville city total records are 6 and failed is 1. Similarly at each rule level passed and failed count.  

Like this we have to get results of all the cities present in that column.

 

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


Reply