Aggregated Log Section

<< Click to Display Table of Contents >>

Manual > Server Creation Guide > Action Edition > Action Reference > Summary Action (Logging/Counting/Daily Report) > Summary Action Configuration File and Folder Structure > Summary Master >

Aggregated Log Section

Aggregation log section property list

Aggregation function related

Parameter Name

(Default value)

subject

Required

Commentary

DaysOfHoldingData

(-1)

CSV/ODBC

 

Number of days aggregate log data is retained.

Setting Value

Contents

-1

According to the setting of the DaysOfHoldingData parameter in the Common Properties section

0

Permanent retention

1 or more

Number of days to keep

 

When retaining data for one year

DaysOfHoldingData =365

 

SummaryUnit

(Not specified)

CSV/ODBC

Required

The unit of time for the aggregation.

Setting Value

Contents

{n}SEC

Aggregated every n seconds

*Only values divisible by 60/n can be specified for the {n} part.

{n}MIN

Aggregated every n minutes

*Only values divisible by 60/n can be specified for the {n} part.

{n}HOUR

Aggregated by n hours

*Only values divisible by 24/n can be specified for the {n} part.

1DAY

Counted by day

1MONTH

Counted on a monthly basis

1YEAR

Counted on a yearly basis

 

Aggregation and adding records every 5 minutes

SummaryUnit=5MIN

 

Aggregating data every hour and adding records

SummaryUnit=1HOUR

 

SummaryType

(Not specified)

CSV/ODBC

 

Specify the aggregation method.

Setting Value

Contents

Aggregation method character

When all fields are aggregated using a common aggregation method.

*You can select the following parameters for the aggregation method text. For details, please refer to "Tag Field Master".

 

AVERAGE / TOTAL / MAX / MIN / ADDINGCOUNT / ADDINGTIME / ADDINGTIME2

ADDINGTIME3 / ADDINGPULSE / START / END / COUNT / RANGE / DELTA

 

[SummaryType{n}]

When the aggregation method is specified in the [SummaryType{n}] column of the tag field master (or calculated field master).

 

When the aggregation method for all fields is set to average value

SummaryType=AVERAGE

 

Specifying the aggregation method for each field

SummaryType=[SummaryType1]

In this case, specify the aggregation method in the tag field master as follows:

[Name]

,[Tag]

,[SummaryType1]

F001

,U01.F01.T000

, AVERAGE

F002

,U01.F01.T001

, TOTAL

F003

,U01.F01.T002

, MAX

...



 

SummaryParam

(Not specified)

CSV/ODBC

 

Specifying aggregation parameters.

Setting Value

Contents

Aggregation parameters

When all fields are specified with common aggregation parameters.

*For details on the aggregation parameters that can be specified, please refer to "Tag Field Master".

 

[SummaryParam{n}]

When the aggregation method is specified in the [SummaryParam{n}] column of the tag field master.

 

When the aggregation method for all fields is ADDINGCOUNT and boundary values are set

SummaryType=ADDINGCOUNT

SummaryParam=100000

 

Specifying the aggregation method for each field

SummaryType=[SummaryType1]

SummaryParam=[SummaryParam1]

In this case, specify the aggregation method in the tag field master as follows:

[Name]

,[Tag]

,[SummaryType1]

,[SummaryParam1]

F001

,U01.F01.T000

, AVERAGE

,

F002

,U01.F01.T001

, ADDINGCOUNT

, 10000

F003

,U01.F01.T002

, ADDINGCOUNT

, 1000

...




 

SummaryOffset

(0)

CSV/ODBC


Specify this parameter if you want to offset the aggregation time.

 

The units of SummaryOffset (hours, days, etc.) are determined by the unit specified in SummaryUnit (MIN, HOUR, DAY, etc.) and are as follows: For example, if "SummaryUnit=1MONTH", MONTH is specified, so the unit of SummaryOffset is one day, and if "SummaryOffset=1" is specified, it will be offset by one day.

Units for SummaryUnit

Units used by SummaryOffset

{n}HOUR

1 minute

1DAY

1 hr

1MONTH

1 day

1YEAR

1 month

 

When aggregating data for 24 hours from 8:00 on the current day in daily report aggregation

SummaryUnit=1DAY

SummaryOffset=8

 

CalculationType

([Expression])

CSV/ODBC


If you want to log calculations, specify the calculation method. For information about calculation fields, see "Calculation Field Master".

Setting Value

Contents

[Expression]

When performing a calculation according to a formula.

[SummaryType{n}]

If you want to create an aggregate log from the results of the calculation log, specify the [SummaryType{n}] column in the calculation field master.

 

Calculate according to the [Expression] column of the calculated field master.

CalculationType =[Expression]

 

Aggregate according to the [SummaryType] column of the calculated field master.

CalculationType =[SummaryType1]

An example of calculating field master settings.

[Name]

,[Expression]

,[SummaryType1]

CAL01

,U01.F01.T000 / 2 + 1

, AVERAGE

CAL02

,F01.T001+U01.F01.T002

, TOTAL

CAL03

,CAL01+CAL02

, MAX

...



 

CalculationParam

(Not specified)

CSV/ODBC

 

Specify the aggregation parameters for the calculation log.

Setting Value

Contents

Aggregation parameters

When all fields are specified with common aggregation parameters.

*For details on the aggregation parameters that can be specified, please refer to "Tag Field Master".

 

[SummaryParam{n}]

When the aggregation method is specified in the [SummaryParam{n}] column of the calculated field master.

 

When the aggregation method for all calculated fields is AVERAGE and you want to ignore 0 from the calculation

CalculationType=AVERAGE

CalculationParam=IGNOREZERO

 

Specifying the aggregation method for each field

CalculationType=[SummaryType1]

CalculationParam=[SummaryParam1]

An example of calculating field master settings.

[Name]

,[Expression]

,[SummaryType1]

,[SummaryParam1]

C000

,T000 + T001 + T002

, AVERAGE

, IGNOREZERO

C001

,T003 + T004 / 2

, AVERAGE

, IGNOREZERO

C002

,C000 + C001

, AVERAGE

, IGNOREZERO

...




 

TimeRangeType

(TYPE1)

CSV/ODBC


The type of time range to save when aggregating.

Setting Value

Contents

TYPE1

From the current hour (including the current hour) to the next hour (excluding the next hour)

TYPE2

From the current hour (excluding the current hour) to the next hour (including the next hour)

 

hint

For the aggregate log section, it affects the time range when aggregating. For example, if you set it as follows and "TimeRangeType=TYPE1", when 1 o'clock passes, the route log from 0:00:00 to 0:59:59 will be aggregated and saved as a 0:00:00 record in the aggregate log.

 

For TYPE1

[RAW::DAY]

SummaryUnit=1HOUR

TimeRangeType=TYPE1

*When 1 o'clock passes, the route logs from 0:00:00 to 0:59:59 will be tallied and saved as a 0:00:00 record in the aggregated log.

 

For TYPE2

[RAW::DAY]

SummaryUnit=1HOUR

TimeRangeType=TYPE2

*When 1 o'clock passes, the route logs from 0:00:01 to 1:00:00 will be tallied and saved as a 0:00:00 record in the aggregated log.

 

DecimalNum

(-1)

CSV/ODBC


Specify the number of decimal places.

Setting Value

Contents

-1

To save all field values as is without rounding them:

0 or more

To match all fields to a specified number of digits:

[DecimalNum{n}]

When specifying the number of decimal points in the [DevimalNum{n}] column of the tag field master (or calculated field master)

 

When setting the number of decimal points in all fields to one digit

DecimalNum=1

 

Specify the number of decimal points for each field

DecimalNum=[DecimalNum1]

In this case, you can specify the number of decimal points for each field in the tag field master as follows:

[Name]

,[Tag]

,[DecimalNum1]

F001

,U01.F01.T000

, 2

F002

,U01.F01.T001

, 1

F003

,U01.F01.T002

, 3

...



 

SearchMaxPrevMins

(Not specified)

CSV/ODBC


If this parameter is specified, the calculation method (ADDINGCOUNT/ADDINGTIME/ADDINGTIME2/ADDINGTIME3/ADDINGPULSE) will search back to the specified minute period when calculating, and if no valid value is found, it will calculate assuming that no previous value exists. If this parameter is not specified, the search will continue until a valid value is found.

 

SearchMaxPrevMins=5

 

CsvFileName

(Not specified)

CSV

Required

The CSV file name to save the log. The actual file name will be appended with the date according to the CsvFileUnit setting. Specify the relative path from the summary folder. Also, do not specify the same folder as other root logs or aggregate logs.

 

CsvFileName=DB\DAY\SMR_DAY_.csv

 

CsvFileUnit

(DAY)

CSV


Specifies the unit for saving the file.

Setting Value

Contents

DAY

A file will be created and saved on a daily basis.

MONTH

Files will be created and saved on a monthly basis.

YEAR

Files will be created and saved on an annual basis.

 

CsvFileUnit=DAY

 

hint

If you select DAY, "YYYYMMDD" will be added to the file name. Similarly, if you select MONTH, "YYYYMM" will be added to the file name, and if you select YEAR, "YYYY" will be added to the file name.

 

CsvSearchMaxPrevRecords

(10000)

CSV


When calculating the cumulative value (ADDINGCOUNT), if the specified record search does not find the value, the previous value will be used as 0. If no value is specified, the default value will be 10000.

 

CsvSearchMaxPrevRecords=0

 

attention

If you specify 0, the search will go back in time without any restrictions and the difference from past values will be calculated. However, since the search may take a long time, you should usually use the default value.

 

OdbcSearchMaxPrevRecords

(100)

ODBC


When calculating the cumulative value (ADDINGCOUNT), if the specified record search does not find the value, the previous value will be set to 0. If no value is specified, the default value will be 100.

 

OdbcSearchMaxPrevRecords=0

 

attention

If you specify 0, the search will go back in time without any restrictions and the difference from past values will be calculated. However, since the search may take a long time, you should usually use the default value.

 

OdbcTable

(Not specified)

ODBC

Required

The name of the table in the ODBC database where the logs will be saved.

 

OdbcTable=DAY

 

SummaryASync

(F)

ODBC


The synchronization mode for the aggregation.

Setting Value

Contents

T

The parent summary that specifies this parameter in the aggregation log and its child summaries are aggregated asynchronously.

F

Synchronous aggregation

 

SummaryASync=T

 

 

 

Report function related

Parameter Name

(Default value)

subject

Required

Commentary

ReportLayoutMaster

(Not specified)

CSV/ODBC

Required

The path to the layout master file, specified relative to the summary folder.

 

ReportLayoutMaster=layoutmaster.xls

 

ReportLayoutMasterSheet

(Not specified)

CSV/ODBC

 

The sheet name to use when printing.

 

ReportLayoutMasterSheet=DAY

 

hint

The sheet names of the actual layout master files are specified as follows:

To separate form layouts by page: "Sheet type name_Sheet name_P"
Example) Standard_DAY_P

If the form layout is not divided by page: "Sheet name_P"
Example) DAY_P

 

ReportOutputSheetName

(Not specified)

 

CSV/ODBC

 

The name of the sheet when outputting to an Excel file as a subreport.

 

ReportOutputSheetName=Daily report_

 

hint

In reality, the page number is added after the name.
Example: Daily report 1, Daily report 2...

If nothing is specified, the sheet name will be the page number only.

Example: 1, 2

 

ReportPrinter

((default))

CSV/ODBC

 

Name of the printer to use when printing reports. If you want to use the default printer set in the OS, specify "(default)".

 

ReportPrinter=XXX (printer name)

 

ReportExcel

(F)

CSV/ODBC

 

Set whether to use formulas and graphs in the Layout Master File.

Setting Value

Contents

T

If you want to use formulas or graphs in your layout master files, you must set this to "T" and install Microsoft Excel.

F

If you do not use formulas or graphs in your Layout Master File, set this to "F."

 

ReportExcel=T

 

ReportTitleHeader

(Not specified)

CSV/ODBC

 

The report title header.

 

ReportTitleHeader=xxSite

 

ReportTitleFooter

(Not specified)

CSV/ODBC

 

The report title footer.

 

ReportTitleFooter=Daily Report

 

ReportTitleTotal

(Not specified)

CSV/ODBC

 

Specifies the title string (total) to be displayed in the summary row of the report. If you specify a keyword (**F_TitleTotal) in the layout master, the value of this property will be output when printing or when outputting to a Excel file. If you specify a string in TitleTotal of Summary report grid control, that will take priority when displayed on the screen.

ReportTitleAverage

(Not specified)

CSV/ODBC

 

Specifies the title string (average) to be displayed in the summary row of the report. If a keyword (**F_TitleAverage) is specified in the layout master, the value of this property will be output when printing or when outputting to a Excel file. Note that if a string is specified in TitleAverage of Summary report grid control, that will take priority when displayed on the screen.

ReportTitleMax

(Not specified)

CSV/ODBC

 

Specifies the title string (maximum) to be displayed in the summary row of the report. If you specify a keyword (**F_TitleMax) in the layout master, the value of this property will be output when printing or when outputting to a Excel file. Note that if you specify a string in TitleMax of Summary report grid control, that will take priority when displayed on the screen.

ReportTitleMin

(Not specified)

CSV/ODBC

 

Specifies the title string (minimum) to be displayed in the summary row of the report. If you specify a keyword (**F_TitleMin) in the layout master, the value of this property will be output when printing or when outputting to a Excel file. If you specify a string in TitleMin of Summary report grid control, that will take priority when displayed on the screen.

ReportTitleLoadFactor

(Not specified)

CSV/ODBC

 

Specifies the title string (load factor) to be displayed in the summary row of the report. If you specify a keyword (**F_TitleLoadFactor) in the layout master, the value of this property will be output when printing or when outputting to a Excel file. If you specify a string in TitleLoadFactor in Summary report grid control, that will take priority when displayed on the screen.

ReportExcelCellFormatType

(formatednum)

CSV/ODBC

 

Cell formatting when outputting to Excel. For details, please refer to "About supported Excel cell formats".

Setting Value

Contents

formatednum

Output as a number and set the number of digits

formatednum2

Output as a number and set the number of digits and comma format

text

Text output

num

Output as a number

 

ReportExcelCellFormatType=formatednum2

 

ReportOffset

(0)

CSV/ODBC

 

Specify this when you want to change the display start time (date and time) in the report display. You cannot specify a negative value for this parameter.

 

The units of ReportOffset (hours, days, etc.) are determined by the units specified in SummaryUnit (MIN, HOUR, DAY, etc.) and are as follows: For example, if "SummaryUnit=1HOUR", HOUR is specified, so the units of ReportOffset are in units of one hour, and if "ReportOffset=1" is specified, it will be offset by one hour.

Units for SummaryUnit

Units used by ReportOffset

{n}MIN

1 minute

{n}HOUR

1 hr

1DAY

1 day

1MONTH

1 month

 

Display data for 24 hours from 8:00 on the current day to 7:00 on the following day

SummaryUnit=1HOUR

ReportOffset=8

 

ReferenceOffset

(0)

CSV/ODBC


Specify this when you want to change the reference time (date and time) of the report.

 

Normally, the reference time and the time of the actual data are in the same time series, but if you want to shift the date and time specified when referencing aggregated data from the date and time of the referenced data, specify this parameter. For example, if you set this parameter to "1" in the aggregated log section of the monthly report, the reference time will be processed as being the date and time that is one month larger (for example, if April is specified as the reference time, the aggregated data for March will be used).

The reference time (the time after the offset) is used in the start reference time and end reference time of the event parameters.

 

・Event: CREATESUBREPORT / PRINTREPORT

 

When specifying the start and end reference times in relative time for an event, if you specify the keyword "[REFERENCEOFFSET]", the value specified with ReferenceOffset will be embedded with a plus or minus sign.

 

Example) Example of specifying the start and end times of the event parameters

Daily report: ...,DAY-1D[REFERENCEOFFSET]D,DAY[REFERENCEOFFSET]D,...

Monthly report: ...,MONTH-1MO[REFERENCEOFFSET]MO,MONTH[REFERENCEOFFSET]MO,...

Annual report: ...,YEAR+1Y[REFERENCEOFFSET]Y,YEAR[REFERENCEOFFSET]Y,...

 

Furthermore, the units of ReferenceOffset (hours, days, etc.) are determined based on the units specified in SummaryUnit (MIN, HOUR, DAY, etc.) and are as follows: For example, if "SummaryUnit=1HOUR", HOUR is specified, so the units of ReferenceOffset are in days, and if "ReferenceOffset=1" is specified, it will be offset by 1 day.

Units for SummaryUnit

Units used by ReferenceOffset

{n}MIN

1 hr

{n}HOUR

1 day

1DAY

1 month

1MONTH

1 year

 

To specify the reference time for monthly reports by adding one month to the date and time

SummaryUnit=1DAY

ReferenceOffset=1

 

 

■ What is reference time?

 

The reference time refers to the date and time specified when specifying the range of aggregated data to be processed from various functions that access aggregated data. For example, when retrieving aggregated data such as Daily/Monthly/Yearly Report from a daily report screen and displaying it on a screen, the target aggregated data is displayed by specifying the date of the report you want to refer to on the screen, and the date specified here is the reference time.

 

For example, if you set the ReportOffset parameter in the monthly report aggregation log section as shown below, the generated monthly report aggregation data will be from the 10th to the 9th of the following month.

 

[DAY::MONTH]

SummaryUnit=1DAY

ReportOffset=10

 

If you do not specify ReferenceOffcet above, and specify "April" as the start reference time for PRINTREPORT and "May" as the end reference time, the monthly report data to be processed will be data from April 10 to May 9. If this specification does not meet your requirements, there is no need to specify the ReferenceOffset parameter.

 

On the other hand, if you want to treat the monthly report data from April 10th to May 9th as "May" instead of "April" due to user requirements, you can use the ReferenceOffcet parameter as follows.

 

[DAY::MONTH]

SummaryUnit=1DAY

ReportOffset=10

ReferenceOffset=1

 

By setting it up as above, if you specify "May" as the start reference time for PRINTREPORT etc. and "June" as the end reference time, the monthly report data to be processed will be data from April 10th to May 9th.

 

 

ReportTitleDateFormat

(Not specified)

CSV/ODBC

 

Report date format. This is the format used for dates when printing and displaying on the screen.

 

If you specify a format in Summary report grid control's TitleDateFormat, it will take precedence when displayed on the screen.

When printing or outputting to a Excel file, the date data type is output as a string. If you do not specify anything in ReportTitleDateFormat, the data type will be output as a date type. However, in that case, you must specify the format in TitleDateFormat in Summary report grid control.

You can specify the date and time format (free format) for this parameter. For details on the format, see "Date and time format (free format)".

 

Displaying 0-23 hours in daily report

ReportTitleDateFormat=@[%H hour]

 

Display 1-24 hours in daily report

ReportTitleDateFormat=@[%(H1) hours]

 

Displaying monthly report with day of the week

ReportTitleDateFormat=@[%m month %d day (%a)]

 

Displaying monthly report without days of the week

ReportTitleDateFormat=@[%m month %d day]

 

Displaying the month in the annual report

ReportTitleDateFormat=@[%#mmonth]

 

ReportReferenceDateFormat

(Not specified)

CSV/ODBC

 

You can specify the date and time format for the report's reference date when printing.

For details on the format, please refer to "Date and time format (free format)".

 

 

 

Quality check function related

 

hint

By enabling the quality check function of summary actions, if the source data is missing or contains unreliable values, the aggregated data can be treated as unreliable values such as "*123". For details about the quality check function, see "Using the quality check function".

 

Parameter Name

(Default value)

subject

Required

Commentary

QualityCheckRequiredRecords

(0)

CSV/ODBC

 

The number of pieces of raw data required for each aggregated record. For example, if raw data is logged at one-minute intervals, the number of records for one hour will be 60.

 

If you define this parameter, for example when performing daily report aggregation from raw data, if the number of data items to be aggregated for one hour does not match the number specified in this parameter, it will be considered an anomaly and an unreliable value flag "*" will be added to the aggregated data. If you do not define this parameter or specify 0 for this parameter, no check will be made based on the number of data items to be aggregated.

 

This parameter should only be specified in the aggregation log section that performs aggregation based on raw data (e.g., [RAW::DAY]).

 

QualityCheckRequiredRecords=60

 

QualityCheckType

(NONE)

 

CSV/ODBC

 

The type of quality check in the tag field master and the calculated field master (when "CalculationType=[SummaryType{n}]" is specified in the aggregation log section of the summary master). If you want to apply multiple conditions, list them with commas. Example: NULLTOBAD,BADTOBAD

 

Setting Value

Contents

NONE

No quality check.

NULLTONULL

If there is a NULL value in the source data, it will be treated as a NULL value.

NULLTOBAD

If the source data contains NULL values, they will be treated as unreliable values (such as *123).

BADTONULL

If the source data contains unreliable values (such as *123), the value will be set to NULL.

BADTOBAD

If unreliable values (such as *123) exist in the source data, they will be treated as unreliable values (such as *123).

 

If multiple conditions are specified, such as "XxxTONULL,XxxTOBAD", and both conditions are met (NULL records exist and untrusted values exist), XxxTONULL will take precedence.

In addition, fields with TermOfValidity set are not subject to quality checks and behave the same as NONE.

 

QualityCheckType=NULLTOBAD

 

hint

The quality check judgment logic differs depending on the statistical method. For details, please refer to "Aggregation Quality Check".

 

QualityCheckTypeFieldMaster

(Not specified)

 

CSV/ODBC

 

If you want to specify the QualityCheckType individually for each field in the tag field master and calculation field master (when "CalculationType=[SummaryType{n}]" is specified), specify the column name of the tag field master (and calculation field master) in this parameter.

 

QualityCheckTypeFieldMaster=[QualityCheckType1]

 

hint

When defining the QualityCheckType column in both the tag field master and the calculated field master, the column name for both is commonly specified in this parameter. Therefore, both must have the same column name.

 

ExpressionQualityCheckType

(NONE)

 

CSV/ODBC

 

The type of quality check in the calculation expression in the calculation field master (when "CalculationType=[Expression]" is specified). If you want to apply multiple conditions, list them with commas.

Example: NULLTOBAD,BADTOBAD

 

Setting Value

Contents

NONE

No quality check.

NULLTONULL

If a NULL value exists in the calculation data, it is treated as a NULL value.

NULLTOBAD

If a NULL value is present in the calculation data, it is treated as an unreliable value (such as *123).

BADTONULL

If the calculation data contains unreliable values (such as *123), the value is treated as NULL.

BADTOBAD

If an unreliable value (such as *123) is present in the calculated data, it is treated as an unreliable value (such as *123).

 

If multiple conditions are specified, such as "XxxTONULL,XxxTOBAD", and both conditions are met (NULL records exist and untrusted values exist), XxxTONULL will take precedence.

In addition, if you specify "F" in the [UncertainIsZero] column of the calculation field master, the calculation result will be NULL if a NULL value exists. For more information on this matter, please refer to the description in "Calculation Field Master".

 

ExpressionQualityCheckType=NULLTOBAD

 

ExpressionQualityCheckTypeFieldMaster

(Not specified)

 

CSV/ODBC

 

In static calculations using calculated fields, if you want to specify the ExpressionQualityCheckType for each field individually, specify the column name of the calculated field master.

 

ExpressionQualityCheckTypeFieldMaster=[ExpressionQualityCheckType1]

 

 

Example of aggregate log section settings

Example: Minimum settings when saving to a CSV file

[RAW::AVERAGE]

CsvFileName=DB\AVRAGE\SMR_AVERAGE_.csv

CsvFileUnit=DAY

SummaryType=AVERAGE

SummaryUnit=1MIN

 

Example) Minimum settings for saving to a ODBC database

[RAW::AVERAGE]

ODBCTable=AVERAGETABLE

SummaryType=AVERAGE

SummaryUnit=1MIN

 

Example: Minimum settings when using the report function

[RAW::DAY]

CsvFileName=DB\DAY\SMR_DAY_.csv

CsvFileUnit=DAY

DecimalNum=[DecimalNum1]

TimeRangeType=TYPE2

SummaryType=[SummaryType1]

SummaryParam=[SummaryParam1]

SummaryUnit=1HOUR

ReportLayoutMaster=layoutmaster.xls

ReportLayoutMasterSheet=DAY

ReportTitleDateFormat=@[%H hour]

 

Example: Additional items when using calculated fields

[RAW::DAY]

...

CalculationType=[Expression]

...

 

[DAY::MONTH]

...

CalculationType=[SummaryType1]

...

 

 

[MONTH::YEAR]

...

CalculationType=[SummaryType1]

...

 

 

Example) Setting example when using the quality check function (*When RAW data is 1 minute interval)

[RAW::DAY]

QualityCheckRequiredRecords=60

QualityCheckType=NULLTOBAD

QualityCheckTypeFieldMaster=[QualityCheckType1]

ExpressionQualityCheckType=NULLTOBAD

ExpressionQualityCheckTypeFieldMaster=[ExpressionQualityCheckType1]

 

[DAY::MONTH]

QualityCheckType=NULLTOBAD

QualityCheckTypeFieldMaster=[QualityCheckType1]

ExpressionQualityCheckType=NULLTOBAD

ExpressionQualityCheckTypeFieldMaster=[ExpressionQualityCheckType1]

 

[MONTH::YEAR]

QualityCheckType=NULLTOBAD

QualityCheckTypeFieldMaster=[QualityCheckType1]

ExpressionQualityCheckType=NULLTOBAD

ExpressionQualityCheckTypeFieldMaster=[ExpressionQualityCheckType1]

 

 

 

hint

Starting with Ver6, it is now possible to specify "Date and time format (free format)" as a format that can be specified for the ReportTitleDateFormat parameter. This parameter definition is upward compatible and will also work with older formats, but unless there is a special reason, we recommend that you specify the date and time format (free format).

 

The old formats that can be specified for ReportTitleDateFormat are as follows.

 

Format

explanation

%Y

Year in four digits (0100-9999)

%#Y

Year without leading zero (100-9999)

%y

The last two digits of the year (00-99)

%#y

Last two digits of the year without leading zeros (0-99)

%[YJ]

Japanese calendar (Showa 60, Heisei 20, Reiwa 1, etc.)

%[#YJ]

Japanese calendar without an era name at the beginning (60, 20, 1, etc.)

%m

Two-digit month (01-12)

%#m

Month without leading zero (1-12)

%d

Day of the month as a two-digit number (01-31)

%#d

Day without leading zero (1-31)

%p, %#p

AM/PM for morning/afternoon

%I

Two-digit hour in 12-hour format (01-12)

%#I

12-hour format with no leading zeros (1-12)

%H

Two-digit hour in 24-hour format (00-23)

%#H

24-hour hour with no leading zeros (0-23)

%[H+1]

Two-digit hour in 24-hour format (01-24)

%[#H+1]

24-hour time without leading zeros (1-24)

%M

Minute in two digits (00-59)

%#M

Minutes without leading zeros (0-59)

%S

Second in two digits (00-59)

%#S

Second without leading zero (0-59)

%%, %#%

One percent sign (%)

%b, %#b

Abbreviated month name (Jan, Feb etc.)

%B, %#B

Full month name (January, February etc.)

%a, %#a

Abbreviated name of the day of the week (Sun, Mon etc.)

%A, %#A

Full name of the day of the week (Sunday, Monday etc.)

%w, %#w

Day of the week as a single digit (0-6), with Sunday being 0

%[AJ]

Japanese names of days of the week (Sun, Moon, Tuesday, etc.)

%j

Three-digit number of days since the beginning of the year (001-366)

%#j

Day of the year without leading zero (1-366)

%U

Two-digit week number, with Sunday as the first day of the week (00-51)

%#U

Week number with Sunday as the first day of the week, without leading zeros (0-51)

%W

Two-digit week number, with Monday as the first day of the week (00-51)

%#W

Week number with Monday as the first day of the week, without leading zeros (0-51)

%c

"%m/%d/%y Same as %H:%M:%S"

%#c

"%A, %B %d, %Y Same as %H:%M:%S"

%x

Same as "%m/%d/%y"

%#x

"%A, %B Same as %d, %Y"

%X, %#X

Same as "%H:%M:%S"

%z, %#z,

%Z, %#Z

The name or abbreviation of the time zone (if the time zone is unknown, no characters are printed)