Use DQL query within Problem trigger to Teams Workflow

[Hillman]

As the mobile app will soon be end-of-support, I am now testing the workflow that send notification to Teams whenever there are problems being triggered.

However, I do not want to send every problem alerts to Teams. Only those which have Alert Profiles other than Default one assigned will be sent to Teams.

I have constructed a DQL query to do the filter. However, the workflow UI does not allow me to add custom DQL query. It only allows partial DQL filter input.

Is there any way I can use the DQL to do the filtering in Problem triggers?

[gbaudart]

Hi,

You can use the "Additional Custom filter" in the Problem Trigger like this :

Let me know if it's work 😉

[Hillman]

@gbaudart However, the custom filter does not fully cover my use case.

I want to filter out the problems which does not have alert profile assigned and those assigned with "Default" profile only. This involves Array to string conversion (to change the alert profiles array to string), string replacement (to remove the Default profile) and can only be done by full DQL.