Soji

All you had to do was create a new query with the right filter in the query phrasebook. then use this query in Powerbi.

Hello, I confirm that Powerbi extension works well. I would like to ask if it possible to add "Parent organization" colum? because I would like to be able to filter all organizations under this parent organization? Thanks for your help. BR

With the filter below, I can decide which notification to use because it will send based on the service assigned in the ticket. This means, that the Service field must be filled in. SELECT UserRequest WHERE service_name LIKE "name of service" However, I can't decide on the notification for the creation of a ticket because the Service field will not be filled in (for example if the ticket is created via email). Can someone help me to find the OQL that allows to check the services of the customer contract...

Hello, My ITOP use mail ticket to automation extension for 2 mailbox with different domain name. Is it possible to choose the notification according to the caller (or organization)? Indeed, I would like that the notifications can be sent via the sender address ticket@domain1.com with email signature associated to domain1.com, and another sender address ticket@domain2.com with another email signature depending on the organization of the caller? I suppose, I need to use the filter on the trigger? Thanks...

Hello Vincent, Interesting, thanks! Frozen status in this documentation, I suppose that means "pending' status, right?

Hello, Is there an existing extension which send a reminder (by email) to the caller if he doesn't respond the ticket after X days? after that, if no answer the ticket will solve and/or close automatically. Jira can do that... Thanks for your help.

Hello, After reading the documentation, I think I'm almost done. <field id="remindchange" xsi:type="AttributeStopWatch" _delta="define"> <states> <state id="plannedscheduled"/> </states> <working_time/> <thresholds> <threshold id="100"> <highlight> <code>warning</code> <persistent>false</persistent> </highlight> <actions> <verb>ApplyStimulus</verb> <params> <param xsi:type="string">ev_plan</param> </params> </actions> </threshold> </thresholds> <goal>RemindChange</goal> </field> class RemindChange...

Hi Pierre, Thanks for your answer. I would like to receive a notification by email 1 hour before the start_date of the change execution. I tried to implement a new stopwatch for change mgmt : <field id="remindchange" xsi:type="AttributeStopWatch"> <states> <state id="start_date"/> </states> <working_time/> <thresholds/> <goal/> </field> Then, I created a new notification with this filter: SELECT Change WHERE start_date > DATE_SUB(CURRENT_DATE(), INTERVAL 1 HOUR) AND start_date > CURRENT_DATE() Did...