Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
Select vrrec.* from VOUCHER_EXPORT_RECORD vr where vr.VOUCHER_EXPORT_RECORDS recwhere rec.SOURCE_ID = <BILLING_SOURCE_ID> order by vrrec.id;

Example value for XML_DOCUMENT_DEF.SQL_RELOAD_RECORDS column can be:

Code Block
languagesql
Select vrrec.* from VOUCHER_EXPORT_RECORD vr where vr.VOUCHER_EXPORT_RECORDS recwhere rec.SOURCE_ID = <BILLING_SOURCE_ID> and vrrec.id > <MAX_LOADED_ID> order by vrrec.id;

If there are 20,000 records, then the GenericXMLFiller uses the SQL-queries configured in the corresponding XML_DOCUMENT_DEF entry like this:

...

FORMATTER_CLASS
NAMEFormatter name
CODEFormatter code
DESCRIPTIONDescribes the purpose of the formatter
VALUE_CLASS

Defines the input for the formatter (i.e. java.util.Date or java.lang.Number

)

or java.lang.String)

Important Note: The formatter should be chosen based on the actual value type. If the value type is not compatible with the java type defined in VALUE_FORMATTER.VALUE_CLASS, the formatting fails and hence file generation fails.

  • If the value to be formatter is a String, then use a Value_Formatter that has the VALUE_CLASS = 'java.lang.String'
  • If the value to be formatter is a Number type (int or long or Amount or float or Integer etc..), then use a Value_Formatter that has the VALUE_CLASS = 'java.lang.Number'
  • If the value to be formatter is a Date, then use a Value_Formatter that has the VALUE_CLASS = 'java.util.Date'
FORMATTER_CLASSClass used to format (i.e. com.CDRator.billing.utils.formatter.DateFormatter)
FORMATTER_METHODUsually it is format
FORMATTER_EXPRESSION

Pattern used to convert the object

in the

to formatted string

(i.e.

. This is optional for the formatters that do not require a pattern to be defined.

Examples:

  • “dd.MM.yyyy”
or
  • to format a Date object to a string in this format
  • “#,##0.00”
)
  • to format a Number to decimal format String
NULL_VALUEValue returned if the input object is null. This is optional and defaults to null.

4 - Example of Generation

...