Control Message Filters and Filter Parameters
In the Control Message, you can define various object group filters and filter parameters to specify the range of data to be extracted from the database for each object group. You can also use custom filters. For more information about filters, see About EagleML Filters in the EagleML wiki.
Using ALLEXTRACTS_ Prefix
The ALLEXTRACTS_ prefix allows you to address all feedtypes at the same time.
For example, you want to extract all feedtypes with Asset Properties model. The task parameter is set like this:
<taskParameter>
<name>ALLEXTRACTS_IncludeAssetProperties</name>
<dataType>S</dataType>
<value>Y</value>
</taskParameter>
When you use the Generic Extracts workflow, be aware that the system also requires the same prefix logic to sort extracts in a custom order. You must prefix the sorting parameter with ALLEXTRACTS_ or FeedType_. For example, ALLEXTRACTS_sorting. For more information about sorting, see Control Message Required and Optional Parameters in the EagleML section.
Using FeedType_ Prefix
customWhere parameter is supported for eagle_wrf_generic_extract only with the FeedType_ prefix.
The FeedType_ prefix allows you to address a feedtype individually.
As an example, you are extracting records of three feedtypes: SMFEXTRACT, ENTITYEXTRACT, WRHSTRADEEXTRACT.
You want to limit the number of records of each type to 20, 10 and 5. The obvious choice here is the maxrows filter, but you should add corresponding feedtype prefixes like this:
<taskParameter>
<name>SMFEXTRACT_maxrows</name>
<dataType>S</dataType>
<value>20</value>
</taskParameter>
<taskParameter>
<name>ENTITYEXTRACT_maxrows</name>
<dataType>S</dataType>
<value>10</value>
</taskParameter>
<taskParameter>
<name>WRHSTRADEEXTRACT_maxrows</name>
<dataType>S</dataType>
<value>5</value>
</taskParameter>
If you use this prefix, there are two parameters that are required to be set: FeedType_CustomWhere and FeedType_ExtractNamePatternEx.
Parameter | Example of Value | Comments |
---|---|---|
FeedType_CustomWhere |
<taskParameter>
<name>SMFEXTRACT_CustomWhere</name>
<dataType>S</dataType>
<value>securitydbo.security_master.security_alias ='15' and rownum < 10</value>
</taskParameter>
| CustomWhere CM parameter allows to insert additional code into the WHERE part of the SQL query of an extract. NOTE: You cannot use OR operator in the expression for CustomWhere parameter.
|
FeedType_ExtractNamePatternEx |
<taskParameter>
<name>SMFEXTRACT_ExtractNamePatternEx</name>
<dataType>S</dataType>
<value>tst_@FeedType_my.xml</value>
</taskParameter>
| Customizes output file name according to the pattern specified.
|
Any filter listed below can be used in a similar manner – but it is not required in their case.
When you use the Generic Extracts workflow, be aware that the system also requires the same prefix logic to sort extracts in a custom order. You must prefix the sorting parameter with ALLEXTRACTS_ or FeedType_. For example, ACCOUNTINGTRADEEXTRACT_sorting. For more information about sorting, see Control Message Required and Optional Parameters in the EagleML section.
Object Group Filters
The following table describes which filters are used for each object group.
Object Group Name | Filter Name | Comments |
---|---|---|
ENTITY | entityselectiontype | For more information, see the Available Filters page in the EagleML wiki. |
| entityselectionvalue |
|
| entityselectiontype2 |
|
| entityselectionvalue2 |
|
| UsePrimaryBasisOnly |
|
SMF | processingsecuritytype | For more information, see the Available Filters page in the EagleML wiki. |
| securitytype |
|
| securityalias |
|
| releasestatus |
|
| primaryassetid |
|
| investmenttype |
|
| xrefid |
|
| xrefidtype |
|
| ticker |
|
| historyonlyflag | For more information, see the Available Filters page in the EagleML wiki. |
Security Related (SMF, Warehouse, Accounting and Reference) | smfrelatedflag | This parameter works with Generic Extract workflow only.
|
Default | SendNotification |
|
| ACKDeliveryMethod |
|
| ReplyDeliveryMethod |
|
| CustomAckLocation |
|
| CustomReplyLocation |
|
Common | maxrows | For more information, see the Available Filter page in the EagleML wiki. |
| DeltaBased | For more information, see the Available Filter page in the EagleML wiki.
|
| DoNotPublishOnError | For more information, see the Format the Control Message page in the EagleML wiki.
|
| XSDValidation | For more information, see the Format the Control Message page in the EagleML wiki.
|
| QueryProfileName |
|
Held | onlyheld | For more information, see the Available Filter page in the EagleML wiki.
|
| heldpositionsources |
|
| heldcashactivitysources |
|
| includecurrencyassets |
|
Source | sourcename | For more information, see the Available Filter page in the EagleML wiki.
|
| datasources |
|
Date | effectivedate | For more information, see the Available Filter page in the EagleML wiki.
|
| fromdate |
|
| fromeffectivedate |
|
| updatedate |
|
| todate |
|
| toeffectivedate |
|
Default | ACKDeliveryMethod | For more information, see the EJM Job Notifications Overview page in the EagleML wiki.
|
| CustomAckLocation |
|
| CustomReplyLocation |
|
| ReplyDeliveryMethod |
|
| SendNotification |
|
Release Date Filters | fromreleasedate |
|
| releasedate |
|
| toreleasedate |
|
Issuer Filters | issueralias |
|
| issuerid |
|
| issuername |
|
Warehouse Filters | BatchMode |
|
| ExcludeCurrentDay |
|
GL Activity Filters | FromGLAccount |
|
| GLBasic |
|
| GLClass |
|
| GLDateType |
|
| GLFromDate |
|
| GLSector |
|
| GLToDate |
|
| ToGLAccount |
|
GL Balances Filters | accountingdate |
|
| fromaccountingdate |
|
| frommonthendaccountingdate |
|
| GLBasic |
|
| monthendaccountingdate |
|
| toaccountingdate |
|
| tomonthendaccountingdate |
|
Nav Filters | fromvaluationdate |
|
| tovaluationdate |
|
| valuationdate |
|
Code Category Filters | codecategory |
|
| codecategoryname |
|
Code Value Filters | codevalue |
|
| codevaluename |
|
Code Translation Filters | fromcodecategory |
|
| fromcodecategoryname |
|
| fromcodevalue |
|
| fromcodevaluename |
|
| fromsourcecode |
|
| tocodecategory |
|
| tocodecategoryname |
|
| tocodevalue |
|
| tocodevaluename |
|
| tosourcecode |
|
Calendar Business Filters | CalendarBusinessName |
|
| CalendarType |
|
| DateTypeMacro |
|
| OnlyBusinessCalendar |
|
| ProcessCenterName |
|
Packer Parameters | CustomExtractLocation | For more information, see the Archive Parameters. |
| ExtractDeliveryMethod |
|
| FromFolder |
|
| OutputZipFileName |
|
| OutputZipFileNamePattern |
|
| SendDataToFTP |
|
| ToFolder |
|
Filter Parameters
In the Control Message, filter parameters are specified in the <taskParameter> element. You can set a date filter for all object groups at once by using Common Date Filters or you can specify a filter for each object group. Specific filters have a higher priority than the Common Date filters. If both filters are used, priority is given to the filter for the specific object group.
The following table lists the supported filter parameters.
Parameter | Example of Value | Default Value | Comments |
---|---|---|---|
Common Date Filters |
|
|
|
fromdate | (yyyy-mm-dd) |
| The date filter sets a range of update and effective date for all objects. |
todate |
|
|
|
updatedate |
|
|
|
fromeffectivedate |
|
|
|
toeffectivedate |
|
|
|
effectivedate |
|
|
|
Please note, that the filters below are designed to be specific for a group of feedtypes. These parameters work with Generic Extract workflow only. |
|
|
|
Reference Date Filters |
|
|
|
reffromdate | (yyyy-mm-dd) |
| The date filter sets a range of update and effective date for all Objects. |
reftodate |
|
|
|
refupdatedate |
|
|
|
reffromeffectivedate |
|
|
|
reftoeffectivedate |
|
|
|
refeffectivedate |
|
|
|
Entity Date Filters |
|
|
|
entityfromdate | (yyyy-mm-dd) |
| Date filter for the ENTITY object group. |
entitytodate |
|
|
|
entityupdatedate |
|
|
|
entityfromeffectivedate |
|
|
|
entitytoeffectivedate |
|
|
|
entityeffectivedate |
|
|
|
SMF Date Filters |
|
|
|
smffromdate | (yyyy-mm-dd) |
| Date filter for the SMF extract. |
smftodate |
|
|
|
smfupdatedate |
|
|
|
smffromeffectivedate |
|
|
|
smftoeffectivedate |
|
|
|
smfeffectivedate |
|
|
|
Financial Event Date Filters |
|
|
|
fineventfromdate | (yyyy-mm-dd) |
| Date filter for the Financial Event extract. |
fineventtodate |
|
|
|
Warehouse Date Filters |
|
|
|
wrhsfromdate | (yyyy-mm-dd) |
| Date filter for the Warehouse extract. |
wrhstodate |
|
|
|
wrhsupdatedate |
|
|
|
wrhsfromeffectivedate |
|
|
|
wrhstoeffectivedate |
|
|
|
wrhseffectivedate |
|
|
|
Corporate Actions Date Filters |
|
|
|
cafromdate | (yyyy-mm-dd) |
| Date filter for the Corporate Actions extract. |
catodate |
|
|
|
caupdatedate |
|
|
|
cafromeffectivedate |
|
|
|
catoeffectivedate |
|
|
|
caeffectivedate |
|
|
|
Accounting Date Filters |
|
|
|
accfromdate | (yyyy-mm-dd) |
| Date filter for the Accounting extract. |
acctodate |
|
|
|
accupdatedate |
|
|
|
accfromeffectivedate |
|
|
|
acctoeffectivedate |
|
|
|
acceffectivedate |
|
|
|
Using Custom Expressions to Filter the Extract
Generic Extract workflow supports custom expressions, for example,
IF StringLength(:param_filter1:)>0 then "rulesdbo.entity.user_field1 like '":param_filter1:"%'" Else "rulesdbo.entity.ENTITY_ID like '%'" is formatted as:
EXPR#iif(StringLength(:param_filter1:)!=0, 'rulesdbo.entity.user_field1 like "':param_filter1: '%" ', 'rulesdbo.entity.ENTITY_ID like "%"')