Eclipse BIRT Designer Version 4.8.0.v201806261756
Data Cube1.RecipientsForPieChart.x
integer
false
Data Cube1.RecipientsForPieChart.y
integer
false
Data Cube - RecipientsForPieChart.RecipientsForPieChart.x
integer
false
Data Cube - RecipientsForPieChart.RecipientsForPieChart.y
integer
false
Data Cube2.RecipientsForPieChart.x
integer
false
Data Cube2.RecipientsForPieChart.y
integer
false
Data Cube.RecipientsForPieChart.x
integer
false
Data Cube.RecipientsForPieChart.y
integer
false
RecipientsForMailingTypeChartDataCube.RecipientsForMailingTypeChart.x
integer
false
RecipientsForMailingTypeChartDataCube.RecipientsForMailingTypeChart.y
integer
false
RecipientsStatistics.RecipientsStatitics.x
integer
false
RecipientsStatistics.RecipientsStatitics.y
integer
false
DataCubeForDevidingByThree.RecipientsDataSet.x
integer
false
DataCubeForDevidingByThree.RecipientsDataSet.y
integer
false
RecipientStatisticsForCSV.RecipientStatisticsForCSV.x
integer
false
RecipientStatisticsForCSV.RecipientStatisticsForCSV.y
integer
false
135
80
135
80
135
80
135
80
135
80
135
80
135
80
135
80
in
/templates/blank_report.gif
auto layout
ltr
styles.css
false
static
integer
true
simple
text-box
Unformatted
static
string
true
simple
text-box
Unformatted
static
false
string
true
-1
simple
text-box
Unformatted
static
true
string
true
simple
text-box
Unformatted
static
true
string
true
simple
text-box
Unformatted
static
string
true
simple
text-box
Unformatted
static
string
true
simple
text-box
Unformatted
static
false
string
true
simple
text-box
Unformatted
static
false
string
true
simple
text-box
Unformatted
static
string
true
simple
text-box
Unformatted
static
string
true
simple
text-box
Unformatted
static
false
string
true
simple
text-box
Unformatted
1
mailingListId
integer
2
mailingListGroupId
integer
3
targetGroupId
integer
4
mailingListName
string
5
targetGroupName
string
6
countTypeText
integer
7
countTypeHtml
integer
8
countTypeOfflineHtml
integer
9
countActive
integer
10
countActiveForPeriod
integer
11
countWaitingForConfirm
integer
12
countOptout
integer
13
countBounced
integer
14
countGenderMale
integer
15
countGenderFemale
integer
16
countGenderUnknown
integer
17
countRecipient
integer
18
countTargetGroup
integer
19
active_count_asOf
integer
20
countBlacklisted
integer
21
countWaitingForConfirmAsOf
integer
22
countBlacklistedAsOf
integer
23
countOptoutAsOf
integer
24
countBouncedAsOf
integer
25
countRecipientAsOf
integer
mailingListId
mailingListGroupId
targetGroupId
mailingListName
targetGroupName
countTypeText
countTypeHtml
countTypeOfflineHtml
countActive
countActiveForPeriod
countWaitingForConfirm
countOptout
countBounced
countGenderMale
countGenderFemale
countGenderUnknown
countRecipient
countTargetGroup
active_count_asOf
countBlacklisted
countWaitingForConfirmAsOf
countBlacklistedAsOf
countOptoutAsOf
countBouncedAsOf
countRecipientAsOf
1
mailingListId
integer
2
mailingListGroupId
integer
3
targetGroupId
integer
4
mailingListName
string
5
targetGroupName
string
6
countTypeText
integer
7
countTypeHtml
integer
8
countTypeOfflineHtml
integer
9
countActive
integer
10
countActiveForPeriod
integer
11
countWaitingForConfirm
integer
12
countOptout
integer
13
countBounced
integer
14
countGenderMale
integer
15
countGenderFemale
integer
16
countGenderUnknown
integer
17
countRecipient
integer
18
countTargetGroup
integer
19
active_count_asOf
integer
20
countBlacklisted
integer
21
countWaitingForConfirmAsOf
integer
22
countBlacklistedAsOf
integer
23
countOptoutAsOf
integer
24
countBouncedAsOf
integer
25
countRecipientAsOf
integer
DummyDataSource
= statData.size()) {
return false;
}
row["mailingListId"] = statData.get(currentRow).getMailingListId();
row["mailingListGroupId"] = statData.get(currentRow).getMailingListGroupId();
row["targetGroupId"] = statData.get(currentRow).getTargetGroupId();
row["mailingListName"] = statData.get(currentRow).getMailingListName();
row["countTypeText"] = statData.get(currentRow).getCountTypeText();
row["countTypeHtml"] = statData.get(currentRow).getCountTypeHtml();
row["countTypeOfflineHtml"] = statData.get(currentRow).getCountTypeOfflineHtml();
row["countActive"] = statData.get(currentRow).getCountActive();
row["countActiveForPeriod"] = statData.get(currentRow).getCountActiveForPeriod();
row["countWaitingForConfirm"] = statData.get(currentRow).getCountWaitingForConfirm();
row["countBlacklisted"] = statData.get(currentRow).getCountBlacklisted();
row["countOptout"] = statData.get(currentRow).getCountOptout();
row["countBounced"] = statData.get(currentRow).getCountBounced();
row["countGenderMale"] = statData.get(currentRow).getCountGenderMale();
row["countGenderFemale"] = statData.get(currentRow).getCountGenderFemale();
row["countGenderUnknown"] = statData.get(currentRow).getCountGenderUnknown();
row["countRecipient"] = statData.get(currentRow).getCountRecipient();
row["countTargetGroup"] = statData.get(currentRow).getCountTargetGroup();
row["active_count_asOf"] = statData.get(currentRow).getCountActiveAsOf();
row["countWaitingForConfirmAsOf"] = statData.get(currentRow).getCountWaitingForConfirmAsOf();
row["countBlacklistedAsOf"] = statData.get(currentRow).getCountBlacklistedAsOf();
row["countOptoutAsOf"] = statData.get(currentRow).getCountOptoutAsOf();
row["countBouncedAsOf"] = statData.get(currentRow).getCountBouncedAsOf();
row["countRecipientAsOf"] = statData.get(currentRow).getCountRecipientAsOf();
// do some i18n stuff
targetGroupID = statData.get(currentRow).getTargetGroupId();
if (targetGroupID == 1) {
row["targetGroupName"] = Packages.com.agnitas.messages.I18nString.getLocaleString("statistic.all_subscribers", reportContext.getLocale());
} else {
row["targetGroupName"] = statData.get(currentRow).getTargetGroupName();
}
currentRow++;
return true;
]]>
1
mailingListId
integer
2
mailingListGroupId
integer
3
targetGroupId
integer
4
targetGroupGroupId
integer
5
mailingListName
string
6
targetGroupName
string
7
countActive
integer
8
countOptout
integer
9
countBounced
integer
10
date
date-time
11
countWaitingForConfirm
integer
12
countBlacklisted
integer
mailingListId
mailingListGroupId
targetGroupId
targetGroupGroupId
mailingListName
targetGroupName
countActive
countOptout
countBounced
date
countWaitingForConfirm
countBlacklisted
1
mailingListId
integer
2
mailingListGroupId
integer
3
targetGroupId
integer
4
targetGroupGroupId
integer
5
mailingListName
string
6
targetGroupName
string
7
countActive
integer
8
countOptout
integer
9
countBounced
integer
10
date
date-time
11
countWaitingForConfirm
integer
12
countBlacklisted
integer
DummyDataSource
= listData.size()) {
return false;
}
row["mailingListId"] = listData.get(currentRow).getMailingListId();
row["mailingListGroupId"] = listData.get(currentRow).getMailingListGroupId();
row["targetGroupId"] = listData.get(currentRow).getTargetGroupId();
row["targetGroupGroupId"] = listData.get(currentRow).getTargetGroupGroupId();
row["mailingListName"] = listData.get(currentRow).getMailingListName();
row["countActive"] = listData.get(currentRow).getCountActive();
row["countOptout"] = listData.get(currentRow).getCountOptout();
row["countBounced"] = listData.get(currentRow).getCountBounced();
row["countWaitingForConfirm"] = listData.get(currentRow).getCountWaitingForConfirm();
row["countBlacklisted"] = listData.get(currentRow).getCountBlacklisted();
row["date"] = listData.get(currentRow).getDate();
// do some i18n stuff
if (listData.get(currentRow).getTargetGroupId() == 1) {
row["targetGroupName"] = Packages.com.agnitas.messages.I18nString.getLocaleString("statistic.all_subscribers", reportContext.getLocale());
} else {
row["targetGroupName"] = listData.get(currentRow).getTargetGroupName();
}
currentRow++;
return true;
]]>
1
mailingListGroupId
integer
2
mailingList
string
3
mailingListId
integer
4
category
string
5
categoryindex
integer
6
targetgroup
string
7
targetgroupindex
integer
8
count
integer
9
rate
float
10
targetGroupId
integer
mailingListGroupId
mailingList
mailingListId
category
categoryindex
targetgroup
targetgroupindex
count
rate
targetGroupId
1
mailingListGroupId
integer
2
mailingList
string
3
mailingListId
integer
4
category
string
5
categoryindex
integer
6
targetgroup
string
7
targetgroupindex
integer
8
count
integer
9
rate
float
10
targetGroupId
integer
DummyDataSource
= statList.size()) {
return false;
}
row["mailingListGroupId"] = statList.get(currentRow).getMailingListGroupId();
row["mailingList"] = statList.get(currentRow).getMailingList();
row["mailingListId"] = statList.get(currentRow).getMailingListId();
row["category"] = statList.get(currentRow).getCategory();
row["categoryindex"] = statList.get(currentRow).getCategoryindex();
row["targetgroupindex"] = statList.get(currentRow).getTargetgroupindex();
row["targetGroupId"] = statList.get(currentRow).getTargetgroupId();
row["count"] = statList.get(currentRow).getCount();
row["rate"] = statList.get(currentRow).getRate();
// do some i18n stuff
if (statList.get(currentRow).getTargetgroupId() == 1) {
row["targetgroup"] = Packages.com.agnitas.messages.I18nString.getLocaleString("statistic.all_subscribers", reportContext.getLocale());
} else {
row["targetgroup"] = statList.get(currentRow).getTargetgroup();
}
currentRow++;
return true;]]>
0
mailingListId
integer
1
mailingListName
string
2
targetGroupId
integer
3
targetGroupName
string
4
day
date
5
countActive
integer
mailingListId
mailingListName
targetGroupId
targetGroupName
day
countActive
1
mailingListId
integer
2
mailingListName
string
3
targetGroupId
integer
4
targetGroupName
string
5
day
date
6
countActive
integer
DummyDataSource
= statList.size()) {
return false;
}
row["mailingListId"] = statList.get(currentRow).getMailingListId();
row["mailingListName"] = statList.get(currentRow).getMailingListName();
row["targetGroupId"] = statList.get(currentRow).getTargetGroupId();
// do some i18n stuff
if (statList.get(currentRow).getTargetGroupId() == 1) {
row["targetGroupName"] = Packages.com.agnitas.messages.I18nString.getLocaleString("statistic.all_subscribers", reportContext.getLocale());
} else {
row["targetGroupName"] = statList.get(currentRow).getTargetGroupName();
}
row["countActive"] = statList.get(currentRow).getCountActive();
row["day"] = statList.get(currentRow).getDate();
currentRow++;
return true;
]]>
a4
portrait
6.5mm
6.5mm
6.5mm
6.5mm
true
true
reportNameTitle
reportContext.getPersistentGlobalVariable("reportName")
string
reportName
Packages.com.agnitas.messages.I18nString.getLocaleString("Name", reportContext.getLocale()) + ':'
string
accountNameTitle
reportContext.getPersistentGlobalVariable("accountName")
string
reportMainTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("recipient.RecipientStatus", reportContext.getLocale())
string
stopDateFormated
params["stopDateFormated"].value
string
period-1
Packages.com.agnitas.messages.I18nString.getLocaleString("report.recipient.period", reportContext.getLocale()) + ":"
string
from-1
Packages.com.agnitas.messages.I18nString.getLocaleString("From", reportContext.getLocale())
string
startDate-1
reportContext.getPersistentGlobalVariable("startDateFormated")
string
true
to-1
Packages.com.agnitas.messages.I18nString.getLocaleString("default.to", reportContext.getLocale())
string
stopDate-1
reportContext.getPersistentGlobalVariable("stopDateFormated")
string
true
asOf-1
Packages.com.agnitas.messages.I18nString.getLocaleString("report.label.asOf", reportContext.getLocale()) + ":"
string
asOfStopDate-1
reportContext.getPersistentGlobalVariable("stopDateFormated")
string
true
|
5
1
auto
|
|
5
1
|
|
period-1
|
from-1
|
startDate-1
|
to-1
|
stopDate-1
|
|
Packages.com.agnitas.messages.I18nString.getLocaleString("report.recipient.statistics.account", reportContext.getLocale())
|
4
1
accountNameTitle
|
|
reportName
|
4
1
reportNameTitle
|
all
if (figures.contains(BirtReporUtils.BirtReportFigure.RECIPIENT_STATUS)) {false} else {true}
|
|
|
|
|
all
if (figures.contains(BirtReporUtils.BirtReportFigure.RECIPIENT_STATUS)) {false} else {true}
|
|
|
|
|
all
if (figures.contains(BirtReporUtils.BirtReportFigure.RECIPIENT_STATUS)) {false} else {true}
|
reportMainTitle
|
asOf-1
|
asOfStopDate-1
|
|
|
all
if (figures.contains(BirtReporUtils.BirtReportFigure.RECIPIENT_STATUS)) {false} else {true}
|
|
|
|
|
RecipientsStatistic2
all
if (figures.contains(BirtReporUtils.BirtReportFigure.RECIPIENT_STATUS)) {false} else {true}
mailingListId
dataSetRow["mailingListId"]
integer
mailingListGroupId
dataSetRow["mailingListGroupId"]
integer
targetGroupId
dataSetRow["targetGroupId"]
integer
mailingListName
dataSetRow["mailingListName"]
string
targetGroupName
dataSetRow["targetGroupName"]
string
countTypeText
dataSetRow["countTypeText"]
integer
countTypeHtml
dataSetRow["countTypeHtml"]
integer
countTypeOfflineHtml
dataSetRow["countTypeOfflineHtml"]
integer
countActive
dataSetRow["countActive"]
integer
countActiveForPeriod
dataSetRow["countActiveForPeriod"]
integer
countWaitingForConfirm
dataSetRow["countWaitingForConfirm"]
integer
countOptout
dataSetRow["countOptout"]
integer
countBounced
dataSetRow["countBounced"]
integer
countGenderMale
dataSetRow["countGenderMale"]
integer
countGenderFemale
dataSetRow["countGenderFemale"]
integer
countGenderUnknown
dataSetRow["countGenderUnknown"]
integer
countRecipient
dataSetRow["countRecipient"]
integer
countTargetGroup
dataSetRow["countTargetGroup"]
integer
mailingListNameRS
dataSetRow["mailingListName"]
string
targetGroupNameRS
dataSetRow["targetGroupName"]
string
countActiveRS
dataSetRow["active_count_asOf"]
integer
countTypeHtmlRS
dataSetRow["countTypeHtml"]
integer
countTypeTextRS
dataSetRow["countTypeText"]
integer
countTypeOfflineHtmlRS
dataSetRow["countTypeOfflineHtml"]
integer
countOptoutRS
dataSetRow["countOptoutAsOf"]
integer
true
countBouncedRS
dataSetRow["countBouncedAsOf"]
integer
true
mailingListNameRSTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("Mailinglist", reportContext.getLocale());
string
targetGroupNameRSTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("Target-Groups", reportContext.getLocale());
string
countActiveRSTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("recipient.MailingState1", reportContext.getLocale())
string
countTypeHtmlRSTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("HTML", reportContext.getLocale())
string
countTypeTextRSTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("recipient.mailingtype.text", reportContext.getLocale())
string
countTypeOfflinehtmlRSTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("recipient.mailingtype.htmloffline", reportContext.getLocale())
string
countOptoutRSTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("recipient.status.optout", reportContext.getLocale())
string
countBouncedRSTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("recipientsStatistic.tableHeader.bounces", reportContext.getLocale())
string
countWaitingForConfirmRS
dataSetRow["countWaitingForConfirmAsOf"]
integer
true
countWaitingForConfirmRSTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("birt.recipient.notConfirmed", reportContext.getLocale())
string
active_count_asOf
dataSetRow["active_count_asOf"]
integer
countBlacklisted
dataSetRow["countBlacklisted"]
integer
true
countBlacklistedRSTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("recipient.MailingState6", reportContext.getLocale())
string
true
countBlacklistedRS
dataSetRow["countBlacklistedAsOf"]
integer
true
row["mailingListName"]
asc
-1
row["targetGroupId"]
asc
-1
|
mailingListNameRSTitle
|
targetGroupNameRSTitle
|
countActiveRSTitle
|
countTypeHtmlRSTitle
|
countTypeTextRSTitle
|
countTypeOfflinehtmlRSTitle
|
countOptoutRSTitle
|
countBouncedRSTitle
|
countWaitingForConfirmRSTitle
|
countBlacklistedRSTitle
|
|
all
row["targetGroupId"] != 1
mailingListNameRS
|
targetGroupNameRS
|
right
countActiveRS
|
right
right
countTypeHtmlRS
|
right
right
countTypeTextRS
|
right
right
countTypeOfflineHtmlRS
|
right
right
countOptoutRS
|
right
right
countBouncedRS
|
right
right
countWaitingForConfirmRS
|
right
countBlacklistedRS
|
all
if (figures.contains(BirtReporUtils.BirtReportFigure.RECIPIENT_DEVELOPMENT_DETAILED)) {false} else {true}
growthOfRecipientsTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("report.recipient.statistics.last30days", reportContext.getLocale())
string
period-2
Packages.com.agnitas.messages.I18nString.getLocaleString("report.recipient.period", reportContext.getLocale()) + ":"
string
form-2
Packages.com.agnitas.messages.I18nString.getLocaleString("From", reportContext.getLocale())
string
startDate-2
reportContext.getPersistentGlobalVariable("startDateFormated")
string
true
to-2
Packages.com.agnitas.messages.I18nString.getLocaleString("default.to", reportContext.getLocale())
string
stopDate-2
reportContext.getPersistentGlobalVariable("stopDateFormated")
string
true
|
|
|
|
|
|
|
|
|
|
|
|
|
growthOfRecipientsTitle
|
period-2
|
form-2
|
startDate-2
|
to-2
|
stopDate-2
|
|
|
|
|
|
|
RecipientsStatistic2
all
if (figures.contains(BirtReporUtils.BirtReportFigure.RECIPIENT_DEVELOPMENT_DETAILED)) {false} else {true}
mailingListId
dataSetRow["mailingListId"]
integer
mailingListGroupId
dataSetRow["mailingListGroupId"]
integer
targetGroupId
dataSetRow["targetGroupId"]
integer
mailingListName
dataSetRow["mailingListName"]
string
targetGroupName
dataSetRow["targetGroupName"]
string
countTypeText
dataSetRow["countTypeText"]
integer
countTypeHtml
dataSetRow["countTypeHtml"]
integer
countTypeOfflineHtml
dataSetRow["countTypeOfflineHtml"]
integer
countActive
dataSetRow["countActive"]
integer
countActiveForPeriod
dataSetRow["countActiveForPeriod"]
integer
countOptout
dataSetRow["countOptout"]
integer
countBounced
dataSetRow["countBounced"]
integer
countGenderMale
dataSetRow["countGenderMale"]
integer
countGenderFemale
dataSetRow["countGenderFemale"]
integer
countGenderUnknown
dataSetRow["countGenderUnknown"]
integer
countRecipient
dataSetRow["countRecipient"]
integer
countTargetGroup
dataSetRow["countTargetGroup"]
integer
mailingListNameGR
dataSetRow["mailingListName"]
string
targetGroupNameGR
dataSetRow["targetGroupName"]
string
targetGroupNameGRTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("Target-Groups", reportContext.getLocale());
string
countActiveForPeriodGR
dataSetRow["countActiveForPeriod"]
integer
countActiveForPeriodGRTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("recipient.Opt_Ins", reportContext.getLocale())
string
mailingListNameGRTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("Mailinglist", reportContext.getLocale());
string
countOptoutGR
dataSetRow["countOptout"]
integer
countOptoutGRTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("statistic.Opt_Outs", reportContext.getLocale())
string
countBouncedGR
dataSetRow["countBounced"]
integer
countBouncedGRTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("recipientsStatistic.tableHeader.bounces", reportContext.getLocale())
string
countWaitingForConfirmTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("birt.recipient.notConfirmed", reportContext.getLocale())
string
true
countWaitingForConfirm
dataSetRow["countWaitingForConfirm"]
integer
true
countBlacklisted
dataSetRow["countBlacklisted"]
string
true
countBlacklistedRSTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("recipient.MailingState6", reportContext.getLocale())
string
true
row["mailingListName"]
asc
-1
row["targetGroupId"]
asc
-1
|
mailingListNameGRTitle
|
targetGroupNameGRTitle
|
countActiveForPeriodGRTitle
|
countOptoutGRTitle
|
countBouncedGRTitle
|
countWaitingForConfirmTitle
|
countBlacklistedRSTitle
|
|
all
row["targetGroupId"] != 1
mailingListNameGR
|
left
targetGroupNameGR
|
right
right
countActiveForPeriodGR
|
right
right
countOptoutGR
|
right
right
countBouncedGR
|
right
countWaitingForConfirm
|
right
countBlacklisted
|
all
if (figures.contains(BirtReporUtils.BirtReportFigure.RECIPIENT_DEVELOPMENT_NET)) {false} else {true}
active_recipients_total_title
Packages.com.agnitas.messages.I18nString.getLocaleString("statistic.recipient.active.total", reportContext.getLocale())
string
true
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
active_recipients_total_title
|
|
|
|
|
|
|
|
|
|
|
|
RecipientStatisticsDynamic2
all
if (figures.contains(BirtReporUtils.BirtReportFigure.RECIPIENT_DEVELOPMENT_NET)) {false} else {true}
mailingListId
mailingListId
dataSetRow["mailingListId"]
integer
mailingListName
mailingListName
dataSetRow["mailingListName"]
string
targetGroupId
targetGroupId
dataSetRow["targetGroupId"]
integer
targetGroupName
targetGroupName
dataSetRow["targetGroupName"]
string
day
day
dataSetRow["day"]
date
countActive
countActive
dataSetRow["countActive"]
integer
mailingListTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("Mailinglist", reportContext.getLocale());
string
true
targetGroupTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("Target-Groups", reportContext.getLocale());
string
true
startDateAggregated
date
groupTargetGroup
MIN
Expression
row["day"]
true
endDateAggregated
date
groupTargetGroup
MAX
Expression
row["day"]
true
sumActiveForStartDate
integer
groupTargetGroup
SUM
Expression
row["countActive"]
BirtComp.equalTo(row["day"], row["startDateAggregated"])
true
sumActiveForEndDate
integer
groupTargetGroup
SUM
Expression
row["countActive"]
BirtComp.equalTo(row["day"], row["endDateAggregated"])
true
formatedStartDate
formatDateByLocale(row["startDateAggregated"])
string
true
formatedEndDate
formatDateByLocale(row["endDateAggregated"])
string
true
groupMailingList
row["mailingListId"]
row["mailingListId"]
false
row["mailingListName"]
asc
-1
|
mailingListTitle
|
targetGroupTitle
|
formatedStartDate
|
formatedEndDate
|
groupTargetGroup
row["targetGroupId"]
row["targetGroupId"]
false
row["targetGroupId"]
asc
-1
|
all
row["targetGroupId"] != 1
mailingListName
|
targetGroupName
|
sumActiveForStartDate
|
sumActiveForEndDate
|
all
if (figures.contains(BirtReporUtils.BirtReportFigure.RECIPIENT_DEVELOPMENT_NET)) {false} else {true}
growthOfRecipientsDetailTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("report.recipient.statistics.last30days", reportContext.getLocale()) + " " + Packages.com.agnitas.messages.I18nString.getLocaleString("report.recipient.statistics.dailyBasis", reportContext.getLocale())
string
period-3
Packages.com.agnitas.messages.I18nString.getLocaleString("report.recipient.period", reportContext.getLocale()) + ":"
string
form-3
Packages.com.agnitas.messages.I18nString.getLocaleString("From", reportContext.getLocale())
string
startDate-3
reportContext.getPersistentGlobalVariable("startDateFormated")
string
true
to-3
Packages.com.agnitas.messages.I18nString.getLocaleString("default.to", reportContext.getLocale())
string
stopDate-3
reportContext.getPersistentGlobalVariable("stopDateFormated")
string
true
|
|
|
|
|
|
|
|
|
|
|
|
|
growthOfRecipientsDetailTitle
|
period-3
|
form-3
|
startDate-3
|
to-3
|
stopDate-3
|
|
|
|
|
|
|
avoid
RecipientStatisticsDetailedDynamic2
all
if (figures.contains(BirtReporUtils.BirtReportFigure.RECIPIENT_DEVELOPMENT_NET)) {false} else {true}
mailingListId
dataSetRow["mailingListId"]
integer
mailingListGroupId
dataSetRow["mailingListGroupId"]
integer
targetGroupId
dataSetRow["targetGroupId"]
integer
targetGroupGroupId
dataSetRow["targetGroupGroupId"]
integer
mailingListName
dataSetRow["mailingListName"]
string
targetGroupName
dataSetRow["targetGroupName"]
string
countActive
dataSetRow["countActive"]
integer
countOptout
dataSetRow["countOptout"]
integer
countBounced
dataSetRow["countBounced"]
integer
date
dataSetRow["date"]
date-time
dateGRDetail
dateFormat(dataSetRow["date"],"short")
string
true
targetGroupNameGRDetail
dataSetRow["targetGroupName"]
string
mailingListNameGRDetail
dataSetRow["mailingListName"]
string
targetGroupNameGRDetailTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("Target-Groups", reportContext.getLocale());
string
countActiveGRDetail
dataSetRow["countActive"]
integer
countActiveGRDetailTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("recipient.Opt_Ins", reportContext.getLocale())
string
countOptoutGRDetail
dataSetRow["countOptout"]
integer
countOptoutGRDetailTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("statistic.Opt_Outs", reportContext.getLocale())
string
countBouncedGRDetail
dataSetRow["countBounced"]
integer
countBouncedGRDetailTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("recipientsStatistic.tableHeader.bounces", reportContext.getLocale())
string
countGrowthGRDetail
dataSetRow["countActive"] - dataSetRow["countOptout"] - dataSetRow["countBounced"]
integer
countGrowthGRDetailTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("report.recipient.statistics.growth", reportContext.getLocale())
string
dateGRDetailTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("settings.fieldType.DATE", reportContext.getLocale());
string
countWaitingForConfirmTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("birt.recipient.notConfirmed", reportContext.getLocale())
string
true
countWaitingForConfirm
dataSetRow["countWaitingForConfirm"]
integer
true
countBlacklisted
dataSetRow["countBlacklisted"]
integer
true
countBlacklistedRSTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("recipient.MailingState6", reportContext.getLocale())
string
true
40000
row["date"]
asc
-1
group_mailingListId
none
asc
row["mailingListId"]
true
false
auto
auto
auto
row["mailingListName"]
asc
-1
|
8
1
mailingListNameGRDetail
|
group_targetGroupId
none
asc
row["targetGroupId"]
true
false
auto
auto
auto
row["targetGroupName"]
asc
-1
|
dateGRDetailTitle
|
targetGroupNameGRDetailTitle
|
countActiveGRDetailTitle
|
countOptoutGRDetailTitle
|
countBouncedGRDetailTitle
|
countGrowthGRDetailTitle
|
countWaitingForConfirmTitle
|
countBlacklistedRSTitle
|
|
dateGRDetail
|
targetGroupNameGRDetail
|
right
right
countActiveGRDetail
|
right
right
countOptoutGRDetail
|
right
right
countBouncedGRDetail
|
right
right
countGrowthGRDetail
|
right
countWaitingForConfirm
|
right
countBlacklisted
|
all
if ((figures.contains(BirtReporUtils.BirtReportFigure.OPENERS_MEASURED)) || (figures.contains(BirtReporUtils.BirtReportFigure.CLICKERS_TOTAL))) {false} else {true}
allActiveRecipientsTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("birt.recipient.allActiveRecipients", reportContext.getLocale());
string
asOf-5
Packages.com.agnitas.messages.I18nString.getLocaleString("report.label.asOf", reportContext.getLocale()) + ":"
string
asOfStopDate-5
reportContext.getPersistentGlobalVariable("stopDateFormated")
string
true
|
|
|
|
|
|
|
allActiveRecipientsTitle
|
asOf-5
|
asOfStopDate-5
|
|
|
|
RecipientStatisticsWithDevices2
all
if ((figures.contains(BirtReporUtils.BirtReportFigure.OPENERS_MEASURED)) || (figures.contains(BirtReporUtils.BirtReportFigure.CLICKERS_TOTAL))) {false} else {true}
mailingListGroupId
dataSetRow["mailingListGroupId"]
integer
mailingList
dataSetRow["mailingList"]
string
mailingListId
dataSetRow["mailingListId"]
integer
category
dataSetRow["category"]
string
categoryindex
dataSetRow["categoryindex"]
integer
targetgroup
dataSetRow["targetgroup"]
string
targetgroupindex
dataSetRow["targetgroupindex"]
integer
count
dataSetRow["count"]
integer
rate
dataSetRow["rate"]
float
all_recipient_active_value
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.ACTIVE_END_DATE_INDEX) {dataSetRow["count"]} else {0}
integer
all_recipient_active_rate
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.ACTIVE_END_DATE_INDEX) {dataSetRow["rate"]} else {0}
float
all_recipient_openers_value
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.OPENERS_END_DATE_INDEX) {dataSetRow["count"]} else {0}
integer
all_recipient_openers_rate
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.OPENERS_END_DATE_INDEX) {dataSetRow["rate"]} else {0}
float
all_recipient_clickers_value
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.CLICKER_END_DATE_INDEX) {dataSetRow["count"]} else {0}
integer
all_recipient_clickers_rate
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.CLICKER_END_DATE_INDEX) {dataSetRow["rate"]} else {0}
float
mailingList_
string
group_targetgroupindex
MAX
Expression
row["mailingList"]
targetGroup_
string
group_targetgroupindex
MAX
Expression
row["targetgroup"]
all_recipient_active_value_
integer
group_targetgroupindex
MAX
Expression
row["all_recipient_active_value"]
all_recipient_active_rate_
float
group_targetgroupindex
MAX
Expression
if (row["all_recipient_active_value"] > 0) {1} else {0}
all_recipient_openers_value_
integer
group_targetgroupindex
MAX
Expression
row["all_recipient_openers_value"]
all_recipient_openers_rate_
float
group_targetgroupindex
MAX
Expression
row["all_recipient_openers_rate"]
all_recipient_clickers_value_
integer
group_targetgroupindex
MAX
Expression
row["all_recipient_clickers_value"]
all_recipient_clickers_rate_
float
group_targetgroupindex
MAX
Expression
row["all_recipient_clickers_rate"]
mailingListTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("Mailinglist", reportContext.getLocale())
string
targetGroupTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("Target-Groups", reportContext.getLocale())
string
all_recipient_active_title
string
MAX
Expression
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.ACTIVE_END_DATE_INDEX) {Packages.com.agnitas.messages.I18nString.getLocaleString(CommonKeys.ACTIVE, reportContext.getLocale())} else {""}
all_recipient_active_rate_title
row["all_recipient_active_title"] + " in %"
string
all_recipient_openers_title
string
MAX
Expression
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.OPENERS_END_DATE_INDEX) {Packages.com.agnitas.messages.I18nString.getLocaleString(RecipientsStatisticDataSet.OPENERS, reportContext.getLocale())} else {""}
all_recipient_openers_rate_title
row["all_recipient_openers_title"] + " in %"
string
all_recipient_clickers_title
string
MAX
Expression
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.CLICKER_END_DATE_INDEX) {Packages.com.agnitas.messages.I18nString.getLocaleString(CommonKeys.CLICKER, reportContext.getLocale())} else {""}
all_recipient_clickers_rate_title
row["all_recipient_clickers_title"] + " in %"
string
Aggregation
integer
group_targetgroupindex
MAX
Expression
row["targetgroupindex"]
targetGroupId
dataSetRow["targetGroupId"]
integer
true
all
if (figures.contains(BirtReporUtils.BirtReportFigure.OPENERS_MEASURED)) {false} else {true}
all
if (figures.contains(BirtReporUtils.BirtReportFigure.OPENERS_MEASURED)) {false} else {true}
all
if (figures.contains(BirtReporUtils.BirtReportFigure.CLICKERS_TOTAL)) {false} else {true}
all
if (figures.contains(BirtReporUtils.BirtReportFigure.CLICKERS_TOTAL)) {false} else {true}
|
mailingListTitle
|
targetGroupTitle
|
all_recipient_active_title
|
all_recipient_active_rate_title
|
all_recipient_openers_title
|
all_recipient_openers_rate_title
|
all_recipient_clickers_title
|
all_recipient_clickers_rate_title
|
group_mailingListId
none
asc
row["mailingListId"]
true
false
auto
auto
auto
row["mailingList"]
asc
-1
group_targetgroupindex
none
asc
row["targetGroupId"]
row["targetGroupId"]
true
false
auto
auto
auto
row["targetGroupId"]
asc
-1
|
all
row["targetgroupindex"] != 1
mailingList_
|
targetGroup_
|
right
right
all_recipient_active_value_
|
right
Custom
0.00%
right
all
row["targetgroupindex"] != 1
all_recipient_active_rate_
|
right
right
all_recipient_openers_value_
|
right
Custom
0.00%
right
all
row["targetgroupindex"] != 1
all_recipient_openers_rate_
|
right
right
all_recipient_clickers_value_
|
right
Custom
0.00%
right
all
row["targetgroupindex"] != 1
all_recipient_clickers_rate_
|
all
if (figures.contains(BirtReporUtils.BirtReportFigure.CLICKERS_AFTER_DEVICE)) {false} else {true}
clickersByDeviceTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("report.recipient.statistics.clickersAfterDevice.label", reportContext.getLocale());
string
activityByDevicesTitle2
Packages.com.agnitas.messages.I18nString.getLocaleString("report.recipient.statistics.activitybydevices", reportContext.getLocale());
string
asOf-3
Packages.com.agnitas.messages.I18nString.getLocaleString("report.label.asOf", reportContext.getLocale()) + ":"
string
asOfStopDate-3
reportContext.getPersistentGlobalVariable("stopDateFormated")
string
true
|
|
|
|
|
|
|
activityByDevicesTitle2
|
asOf-3
|
asOfStopDate-3
|
|
|
|
|
clickersByDeviceTitle
|
|
|
|
|
|
RecipientStatisticsWithDevices2
all
if (figures.contains(BirtReporUtils.BirtReportFigure.CLICKERS_AFTER_DEVICE)) {false} else {true}
mailingListGroupId
dataSetRow["mailingListGroupId"]
integer
mailingList
dataSetRow["mailingList"]
string
mailingListId
dataSetRow["mailingListId"]
integer
category
dataSetRow["category"]
string
categoryindex
dataSetRow["categoryindex"]
integer
targetgroup
dataSetRow["targetgroup"]
string
targetgroupindex
dataSetRow["targetgroupindex"]
integer
count
dataSetRow["count"]
integer
rate
dataSetRow["rate"]
float
mailingListTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("Mailinglist", reportContext.getLocale())
string
mailingList_
string
group_targetgroupId
MAX
Expression
row["mailingList"]
true
targetGroup_
string
group_targetgroupId
MAX
Expression
row["targetgroup"]
true
targetGroupTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("Target-Groups", reportContext.getLocale())
string
clickerTrackedEndDateValue
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.CLICKER_TRACKED_END_DATE_INDEX) {dataSetRow["count"]} else {0}
integer
clickerTrackedEndDateRate
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.CLICKER_TRACKED_END_DATE_INDEX) {1} else {0}
float
clickerPcEndDateValue
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.CLICKER_PC_END_DATE_INDEX) {dataSetRow["count"]} else {0}
integer
clickerPcEndDateRate
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.CLICKER_PC_END_DATE_INDEX) {dataSetRow["rate"]} else {0}
float
clickerTabletEndDateValue
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.CLICKER_TABLET_END_DATE_INDEX) {dataSetRow["count"]} else {0}
integer
clickerTabletEndDateRate
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.CLICKER_TABLET_END_DATE_INDEX) {dataSetRow["rate"]} else {0}
float
clickerMobileEndDateValue
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.CLICKER_MOBILE_END_DATE_INDEX) {dataSetRow["count"]} else {0}
integer
clickerMobileEndDateRate
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.CLICKER_MOBILE_END_DATE_INDEX) {dataSetRow["rate"]} else {0}
float
clickerSmarttvEndDateValue
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.CLICKER_SMARTTV_END_DATE_INDEX) {dataSetRow["count"]} else {0}
integer
clickerSmarttvEndDateRate
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.CLICKER_SMARTTV_END_DATE_INDEX) {dataSetRow["rate"]} else {0}
float
clickerMultipleEndDateValue
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.CLICKER_MULTIPLE_DEVICES_END_DATE_INDEX) {dataSetRow["count"]} else {0}
integer
clickerMultipleEndDateRate
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.CLICKER_MULTIPLE_DEVICES_END_DATE_INDEX) {dataSetRow["rate"]} else {0}
float
clickerTrackedEndDateValue_
integer
group_targetgroupId
MAX
Expression
row["clickerTrackedEndDateValue"]
true
clickerTrackedEndDateRate_
float
group_targetgroupId
MAX
Expression
if (row["clickerTrackedEndDateValue"] > 0) {1} else {0}
true
clickerPcEndDateValue_
float
group_targetgroupId
MAX
Expression
row["clickerPcEndDateValue"]
true
clickerPcEndDateRate_
float
group_targetgroupId
MAX
Expression
row["clickerPcEndDateRate"]
true
clickerMobileEndDateValue_
integer
group_targetgroupId
MAX
Expression
row["clickerMobileEndDateValue"]
true
clickerMobileEndDateRate_
float
group_targetgroupId
MAX
Expression
row["clickerMobileEndDateRate"]
true
clickerTabletEndDateValue_
integer
group_targetgroupId
MAX
Expression
row["clickerTabletEndDateValue"]
true
clickerTabletEndDateRate_
float
group_targetgroupId
MAX
Expression
row["clickerTabletEndDateRate"]
true
clickerSmarttvEndDateValue_
integer
group_targetgroupId
MAX
Expression
row["clickerSmarttvEndDateValue"]
true
clickerSmarttvEndDateRate_
float
group_targetgroupId
MAX
Expression
row["clickerSmarttvEndDateRate"]
true
clickerMultipleEndDateValue_
integer
group_targetgroupId
MAX
Expression
row["clickerMultipleEndDateValue"]
true
clickerMultipleEndDateRate_
float
group_targetgroupId
MAX
Expression
row["clickerMultipleEndDateRate"]
true
clickerTrackedValueTitle
string
MAX
Expression
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.CLICKER_TRACKED_END_DATE_INDEX) {Packages.com.agnitas.messages.I18nString.getLocaleString(CommonKeys.CLICKER_TRACKED, reportContext.getLocale())} else {""}
clickerTrackedRateTitle
row["clickerTrackedValueTitle"] + " in %"
string
clickerPcValueTitle
string
MAX
Expression
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.CLICKER_PC_END_DATE_INDEX) {Packages.com.agnitas.messages.I18nString.getLocaleString("statistic.pc", reportContext.getLocale())} else {""}
clickerPcRateTitle
row["clickerPcValueTitle"] + " in %"
string
clickerMobileValueTitle
string
MAX
Expression
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.CLICKER_MOBILE_END_DATE_INDEX) {Packages.com.agnitas.messages.I18nString.getLocaleString("report.openers.mobile.shortname", reportContext.getLocale())} else {""}
clickerMobileRateTitle
row["clickerMobileValueTitle"] + " in %"
string
clickerTabletValueTitle
string
MAX
Expression
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.CLICKER_TABLET_END_DATE_INDEX) {Packages.com.agnitas.messages.I18nString.getLocaleString("report.openers.tablet.shortname", reportContext.getLocale())} else {""}
clickerTabletRateTitle
row["clickerTabletValueTitle"] + " in %"
string
clickerSmarttvValueTitle
string
MAX
Expression
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.CLICKER_SMARTTV_END_DATE_INDEX) {Packages.com.agnitas.messages.I18nString.getLocaleString("report.openers.smarttv.shortname", reportContext.getLocale())} else {""}
clickerSmarttvRateTitle
row["clickerSmarttvValueTitle"] + " in %"
string
clickerMultipleValueTitle
string
MAX
Expression
if (dataSetRow["categoryindex"] == RecipientsStatisticDataSet.CLICKER_MULTIPLE_DEVICES_END_DATE_INDEX) {Packages.com.agnitas.messages.I18nString.getLocaleString("report.openers.multiple-devices.shortname", reportContext.getLocale())} else {""}
clickerMultipleRateTitle
row["clickerMultipleValueTitle"] + " in %"
string
targetgroupId
dataSetRow["targetGroupId"]
integer
true
|
mailingListTitle
|
targetGroupTitle
|
clickerTrackedValueTitle
|
clickerTrackedRateTitle
|
clickerPcValueTitle
|
clickerPcRateTitle
|
clickerMobileValueTitle
|
clickerMobileRateTitle
|
clickerTabletValueTitle
|
clickerTabletRateTitle
|
clickerSmarttvValueTitle
|
clickerSmarttvRateTitle
|
clickerMultipleValueTitle
|
clickerMultipleRateTitle
|
group_mailingListId
none
asc
row["mailingListId"]
row["mailingListId"]
true
false
auto
auto
auto
row["mailingList"]
asc
-1
group_targetgroupId
none
asc
row["targetgroupId"]
row["targetgroupId"]
true
false
auto
auto
auto
row["targetgroupId"]
asc
-1
|
all
row["targetgroupindex"] != 1
mailingList_
|
targetGroup_
|
clickerTrackedEndDateValue_
|
Custom
0.00%
all
row["targetgroupindex"] != 1
clickerTrackedEndDateRate_
|
clickerPcEndDateValue_
|
Custom
0.00%
all
row["targetgroupindex"] != 1
clickerPcEndDateRate_
|
clickerMobileEndDateValue_
|
Custom
0.00%
all
row["targetgroupindex"] != 1
clickerMobileEndDateRate_
|
clickerTabletEndDateValue_
|
Custom
0.00%
all
row["targetgroupindex"] != 1
clickerTabletEndDateRate_
|
clickerSmarttvEndDateValue_
|
Custom
0.00%
all
row["targetgroupindex"] != 1
clickerSmarttvEndDateRate_
|
clickerMultipleEndDateValue_
|
Custom
0.00%
all
row["targetgroupindex"] != 1
clickerMultipleEndDateRate_
|
all
if (figures.contains(BirtReporUtils.BirtReportFigure.MAILING_TYPE)) {false} else {true}
byMailingTypeTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("report.recipient.statistics.bymailingtype", reportContext.getLocale());
string
asOf-4
Packages.com.agnitas.messages.I18nString.getLocaleString("report.label.asOf", reportContext.getLocale()) + ":"
string
asOfStopDate-4
reportContext.getPersistentGlobalVariable("stopDateFormated")
string
true
|
|
|
|
|
|
|
byMailingTypeTitle
|
asOf-4
|
asOfStopDate-4
|
|
|
|
RecipientsStatistic2
all
if (figures.contains(BirtReporUtils.BirtReportFigure.MAILING_TYPE)) {false} else {true}
mailingListId
dataSetRow["mailingListId"]
integer
mailingListGroupId
dataSetRow["mailingListGroupId"]
integer
targetGroupId
dataSetRow["targetGroupId"]
integer
mailingListName
dataSetRow["mailingListName"]
string
targetGroupName
dataSetRow["targetGroupName"]
string
countTypeText
dataSetRow["countTypeText"]
integer
countTypeHtml
dataSetRow["countTypeHtml"]
integer
countTypeOfflineHtml
dataSetRow["countTypeOfflineHtml"]
integer
countActive
dataSetRow["countActive"]
integer
countActiveForPeriod
dataSetRow["countActiveForPeriod"]
integer
countWaitingForConfirm
dataSetRow["countWaitingForConfirm"]
integer
countOptout
dataSetRow["countOptout"]
integer
countBounced
dataSetRow["countBounced"]
integer
countGenderMale
dataSetRow["countGenderMale"]
integer
countGenderFemale
dataSetRow["countGenderFemale"]
integer
countGenderUnknown
dataSetRow["countGenderUnknown"]
integer
countRecipient
dataSetRow["countRecipient"]
integer
countTargetGroup
dataSetRow["countTargetGroup"]
integer
active_count_asOf
dataSetRow["active_count_asOf"]
integer
mailingListName_
dataSetRow["mailingListName"]
string
mailingListNameTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("Mailinglist", reportContext.getLocale());
string
activeCountAsOf_
dataSetRow["active_count_asOf"]
integer
activeCountAsOfTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("recipient.MailingState1", reportContext.getLocale())
string
activeCountAsOfRate_
if (dataSetRow["active_count_asOf"] > 0) {1} else {0}
float
activeCountAsOfRateTitle
row["activeCountAsOfTitle"] + " in %"
string
htmlCount_
dataSetRow["countTypeHtml"]
integer
htmlCountTitle_
Packages.com.agnitas.messages.I18nString.getLocaleString("HTML", reportContext.getLocale())
string
htmlRateTitle
row["htmlCountTitle_"] + " in %"
string
htmlRate_
if (dataSetRow["active_count_asOf"] > 0) {Math.round(dataSetRow["countTypeHtml"]/dataSetRow["active_count_asOf"]*Math.pow(10,4))/Math.pow(10,4)} else {0}
float
textCount_
dataSetRow["countTypeText"]
integer
textCountTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("recipient.mailingtype.text", reportContext.getLocale())
string
textRate_
if (dataSetRow["active_count_asOf"] > 0) {Math.round(dataSetRow["countTypeText"]/dataSetRow["active_count_asOf"]*Math.pow(10,4))/Math.pow(10,4)} else {0}
float
textRateTitle
row["textCountTitle"] + " in %"
string
offlineHtmlCount_
dataSetRow["countTypeOfflineHtml"]
integer
offlineHtmlTitle
Packages.com.agnitas.messages.I18nString.getLocaleString("recipient.mailingtype.htmloffline", reportContext.getLocale())
string
offlineHtmlRateTitle
row["offlineHtmlTitle"] + " in %"
string
offlineHtmlRate_
if (dataSetRow["active_count_asOf"] > 0) {Math.round(dataSetRow["countTypeOfflineHtml"]/dataSetRow["active_count_asOf"]*Math.pow(10,4))/Math.pow(10,4)} else {0}
float
row["mailingListName"]
asc
-1
eq
row["targetGroupId"]
1
true
|
mailingListNameTitle
|
activeCountAsOfTitle
|
activeCountAsOfRateTitle
|
htmlCountTitle_
|
htmlRateTitle
|
textCountTitle
|
textRateTitle
|
offlineHtmlTitle
|
offlineHtmlRateTitle
|
|
mailingListName_
|
activeCountAsOf_
|
Custom
0.00%
activeCountAsOfRate_
|
htmlCount_
|
Custom
0.00%
htmlRate_
|
textCount_
|
Custom
0.00%
textRate_
|
offlineHtmlCount_
|
Custom
0.00%
offlineHtmlRate_
|