1 <#--

     2 ============================================================================ 

     3 Name        : email.html.ftl 

     4 Part of     : Helium 

     5 

     6 Copyright (c) 2009 Nokia Corporation and/or its subsidiary(-ies).

     7 All rights reserved.

     8 This component and the accompanying materials are made available

     9 under the terms of the License "Eclipse Public License v1.0"

    10 which accompanies this distribution, and is available

    11 at the URL "http://www.eclipse.org/legal/epl-v10.html".

    12 

    13 Initial Contributors:

    14 Nokia Corporation - initial contribution.

    15 

    16 Contributors:

    17 

    18 Description:

    19 

    20 ============================================================================

    21 -->

    22 <?xml version="1.0" encoding="utf-8"?>

    23 <build-status>

    24     <#assign table_info = pp.loadData('com.nokia.helium.metadata.SQLFMPPLoader',

    25         "${dbPath}") >

    26 <#assign priority_table = table_info['select * from priority'] >

    27 <#assign priority_ids = priority_table?keys>

    28 

    29 <#list priority_ids as priority>

    30     <#assign priority_count = table_info['select count(data) as COUNT from metadata where priority_id = ${priority} and logpath_id in (select id from logfiles where path like \'%${logfile}%\')'][0]['COUNT'] >

    31     <#if (priority_count >= 0)>

    32         <${priority_table['${priority}']?lower_case} count= "${priority_count}">

    33     </#if>

    34 </#list>

    35 </build-status>