[Site Properties Management] Inactive timers are shown

[Site Properties Management] Inactive timers are shown

  
Forge Component
(6)
Published on 2015-11-02 by Fernando Moitinho
6 votes
Published on 2015-11-02 by Fernando Moitinho

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