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?

