############################### Outputs hide conditions ###################
# To enable filtering output data set field 'filter' to 'true'. Content beetwen fields
# <proc.procedure_name.filter> and </proc.procedure_name.filter> should contain
# records with filtering conditions. Each record has next format :
# <variable><condition><value>
# Where :
# <variable> - name of a field above which is made condition check.
# <condition> - condition. Must be one of :
# '=' - Equal. That is value of <variable> is completely identical to <value> value.
# '<>' or '!=' - Not equally. That is value of <variable> distinct from <value> value.
# '>' - Bigger than. That is value of <variable> is bigger than <value> value. Can be used only for date and numeretic types.
# '<' - Less than. That is value of <variable> is less than <value> value. Can be used only for date and numeretic types.
# '>=' - Bigger or equal. That is <variable> value is bigger or equals to <value> value. Can be used only for date and numeretic types.
# '<=' - Less or equal. That is <variable> value is less or to equals value of <value> Can be used only for date and numeretic types.
# <value> - constant value to which compares contents of field <variable>.
# The format and type should coincide completely with field <variable> characteristics.
# It is possible to use a constant 'NULL' which specifies empty value (Do not confuse to zero value).
# Strings should be limited by symbol '"'(inverted commas). Entry "" means empty string (not null).
# Examples : "boroda" , "habba habba habba", "" (empty string)
# Date must have next format : "DD/MM/YYYY HH24:MM:SS:III".
# Where :
# DD - Day. [01;31].
# MM - Month. [01 - Januar;12 - December].
# YYYY - Year. [1900;2229].
# HH24 - Hour in 24 format. [00;23]
# MM - Minutes. [00;59]
# SS - Seconds. [00;59]
# III - Milliseconds. [000;999]
# Examples: "01/01/2001 17:55:05:001","03/12/2005","5/5/1980 13:32"
# Example :
# <proc.pRR41.filter>
# # Do not write to output elements with name 'isik.variable1' if his value not defined(equals NULL).
# isik.variable1=NULL
# # Skip if value of field mass equals 0. Field mass must be defined as numeretic type.
# mass=0
# # Skip if 'infringementDate' date bigger or equals to 24 feb 1992. Field 'infringementDate' must be defined as date type.
# infringementDate >= "24/02/1992"
# </proc.pRR41.filter>
Пример :
---- Входищие данные
isik.variable1=NULL
# Skip if value of field mass equals 0. Field mass must be defined as numeretic type.
mass=0 #zerro, not null.
# Skip if 'infringementDate' date bigger or equals to 24 feb 1992.
# Field 'infringementDate' must be defined as date type.
infringementDate >= "24/02/1992"
# String parsing.
boroda <> "123 # 123" # quoted inside string must be parsed correctly
---- Выходящие
conditions[4][3] = {{'isik.variable1','=',null},
{'mass','=',0},
{'infringementDate','>=',"24/02/1992"},
{'boroda','<>',"123 # 123"}}
ЗЫ! Символ # - коментарий (после данного символа можно писать коментраии, как в примере). Необходимо правильно определять коментарий это или просто часть строки (как в примере последнее условие).
Заранее благодарен.
Сообщение изменено: CyBurglar (11 июля 2005 - 12:19 )
