[Properties Management] Inactive timers are shown

[Properties Management] Inactive timers are shown

  
Forge Component
(7)
Published on 23 Jul (3 weeks ago) by Carlos Alfaro
7 votes
Published on 23 Jul (3 weeks ago) by Carlos Alfaro

Hi Fernando, 

We noticed that the component shows inactive timers in the list, timers that have been "removed" from an eSpace. 

Looks like the advanced query in action GetAllTimersByESpace should have an extra condition added: 

SyntaxEditor Code Snippet

SELECT {Cyclic_Job_Shared}.*,
    {Meta_Cyclic_Job}.*
from {Meta_Cyclic_Job}
    inner join {Cyclic_Job_Shared} on {Cyclic_Job_Shared}.[Meta_Cyclic_Job_Id] = {Meta_Cyclic_Job}.[Id] 
    inner join {Espace} on {Espace}.[Id] = {Meta_Cyclic_Job}.[Espace_Id] 
where {Espace}.[SS_Key] = @SS_Key and {Espace}.[Is_Active] = 1 and {Meta_Cyclic_Job}.[Name] like @SearchKeyword
and {Meta_Cyclic_Job}.[Is_Active] = 1
order by {Meta_Cyclic_Job}.[Name]


Regards,

Peter

Hi Peter,

Great pick-up, that is correct should only the active ones.

I will incorporate that on the component and make it available on the next release.


Regards,

Fernando

Hi,

First, let me say thanks for this fantastic component, it save's me a lot of time and clicking.

I'm still experiencing this behaviour of seeing the timers that are deleted. So it is just a vote up to request a fix for this.


Regards,

Rodolfo Cardoso