[
https://issues.apache.org/jira/browse/CLOUDSTACK-4904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13851910#comment-13851910
]
Harikrishna Patnala commented on CLOUDSTACK-4904:
-------------------------------------------------
the template_View schema is defined such that entries in the template_view are
only active templates.
CREATE VIEW `cloud`.`template_view` AS
select
vm_template.id,
vm_template.uuid,
vm_template.unique_name,
vm_template.name,
....
where
vm_template.state='Active';
In CS when we remove templates we mark them as inactive in DB. Then
template_view doesnot contains the removed entries, which means we cannot
retrieve removed entries by any search criteria.
Alex added that where clause on master/4.3
commit abbae2aa87471274cffa35b54ae8157c1efaade9 (4.3 commit)
Author: Alex Huang <[email protected]>
Date: Mon Aug 26 17:30:58 2013 -0700
Fixed the problem with offerings and templates. These two items due to
a previous patch all the way back in 2.1.x versions uses the removed column
incorrectly. No one fixed since then. Hence, there's a bunch of
findbyidincludingremoved calls in the cloudstack code around these two items.
Some how my code worked when I submitted my patch. But later came across this
issue.
> Unable to see a derieved template if the parent template is deleted
> -------------------------------------------------------------------
>
> Key: CLOUDSTACK-4904
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-4904
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Components: Template
> Affects Versions: 4.2.0
> Reporter: Harikrishna Patnala
> Assignee: Harikrishna Patnala
> Priority: Critical
> Fix For: 4.3.0
>
>
> Functionality required/broken - For a template, if the parent template info
> (template Id) is provided in the listTemplates API then one should be able to
> query for the parent template id as well (whether existing/removed doesn't
> matter)
--
This message was sent by Atlassian JIRA
(v6.1.4#6159)
