topic Re: DQL query to filter fields based on their value in DQL

Filter Fields by Value Using DQL Queries for Precise Results

JhonU — Thu, 18 Dec 2025 14:01:42 GMT

Hello everyone, could you help me because I am stuck, through a DQL query I get the following fields based on aggregations, the last thing I need is to be able to filter and only present the fields whose numeric value is greater than a threshold that I define. Example >10, in the case of the image only one value will be presented. I appreciate the help.

Re: DQL query to filter fields based on their value

JhonU — Wed, 02 Oct 2024 16:51:54 GMT

Re: DQL query to filter fields based on their value

StrangerThing — Wed, 02 Oct 2024 17:34:25 GMT

You can use the filterOut command after you do your aggregations to get rid of the records that are < 10.

| summarize count = count(), by:{installerVersion} | filterOut count < 10

Re: DQL query to filter fields based on their value

JhonU — Wed, 02 Oct 2024 17:44:37 GMT

I appreciate the response, however it seems to me that it does not satisfy the query, as seen in the image the final data is presented as fields with their respective value, of these I seek to present only those that meet the criteria, I have tried "fieldsremove" but I cannot add a condition to delete or not the field.

Re: DQL query to filter fields based on their value

StrangerThing — Wed, 02 Oct 2024 17:52:42 GMT

I see, you only want to remove the field and not the record. I'm not sure that's possible with the fieldsRemove command as it doesn't seem to take if statements. You may be able to use the countIf function if your summarize command to accomplish this, but I'm not exactly sure how your query is setup.

Re: DQL query to filter fields based on their value

IzabelaRokita — Thu, 18 Dec 2025 14:01:20 GMT

Hey @JhonU ,
I just wanted to check in and see if you still need help with this. If so, I’d be happy to look into it for you! 😊
Please let me know what works best for you.