I’m attempting to filter Left Joined tables in a GQI dashboard query. Before adding the filter the data is joined correctly. Adding a filter causes only the Left table data to appear even though I have verified the index is present in both tables. I’ve tried filtering pre and post join, as well as adding a Select and then filtering. Is this a known issue?
Hi Jim. What version of DM are you currently running?
I have a similar query and it is working, the only difference is that in the Filter I’m not using “regex” but “contains”.
Also, have you checked if the regex is correct? Are you expecting to match a literal of “ip-10-185-241-110”?
I think the problem is not the join but the filter you are trying to use. Please check if by changing it back to regex and using the following expression IP.*(10|185|241|110) you get the result you are expecting
Thanks Sebastian. I tried using contains instead of the regex, but with the same result. I know the join is working because I can remove the filter and get values from both tables (screenshot attached). The version we are running is DataMiner (10.2.8.0-12037). Can you attach a screenshot of the query you are using, maybe I can find a subtle difference.