Dynamic Filter for entity tags for fetching related problems

Hi All,

requirement: need to filter the problems for entity tags . here entity tags are nothing but a assignmentgroup name which are tagged for each application. So each application owner should be able to filter using assignment group and see their application related problems. Here I am able to get dynamic filter in drop down menu. But only one assignment group is giving the problem records. others assignment groups giving nothing. (other assignment groups have problems in that timeframe while checked filtering with the name of assignment group filter directly)

dynamic filter query as follows.
fetch dt.davis.problems
| filter iAny(startsWith(entity_tags[], “AssignmentGroup”))
| expand entity_tags
|filter contains(toString(entity_tags), “AssignmentGroup:xxxxx”) or contains(toString(entity_tags), "yyyyy)
or contains(toString(entity_tags), “[Environment]AssignmentGroup:zzzz”) or contains(toString(entity_tags), “[Environment]AssignmentGroup:AAAA”)or contains(toString(entity_tags), “AssignmentGroup:BBBB”)
|parse entity_tags, “ld:key ‘:’ ld:Value”
|summarize collectDistinct(Value)

DQL query for fetching problem

fetch dt.davis.problems
| expand entity_tags
| filter entity_tags ==$AssignmentGroup

Please help me where it goes wrong. I set the query limits as attached. Does it matter?

Hey @karthikayini_m ,
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! :blush:
Please let me know what works best for you.