Page Comparison

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 the About Filters page in the EagleML wiki http://eagle.helpdocsonline.com/about-filters$Custom_Filters. ??EagleML reference

Info

title	Note

customWhere parameter is supported for eagle_wrf_generic_extract only with the FeedType_ prefix.

...

Parameter

Example of Value

Comments

FeedType{_}CustomWhere

Code Block

language	xml

<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.

FeedType{_}ExtractNamePatternEx

Code Block

language	xml

<taskParameter>
    <name>SMFEXTRACT_ExtractNamePatternEx</name>
    <dataType>S</dataType>
    <value>tst_@FeedType_my.xml</value>
</taskParameter>

Customizes output file name according to the pattern specified.
List of valid expressions:

@CorrelationID replaced by initial CorrID (must be always specified, required parameter)

Info

title	Note

If the process is launched via PACE Event Scheduler, its correlation Id is built as a combination of the tag 1177 value given in the PACE event's stream parameters and 'yyyymmddThhmmss' timestamp of the start of the event.

@DateTimeStamp – date-time stamp in format YYYYMMDDHHMISS
@DateStamp – date stamp in format YYYYMMDD
@RecordCount – count of extracted records
@EntityList – passed entity list filter
@EntityID – passed entity id filter
@FeedType – passed feed type
@entityselectiontype – passed value of "entityselectiontype" task parameter
@entityselectiontype2 – passed value of "entityselectiontype2" task parameter
@entityselectionvalue – passed value of "entityselectionvalue" task parameter
@entityselectionvalue2 – passed value of "entityselectionvalue2" task parameter

...

Object Group Name	Filter Name	Comments
ENTITY	entityselectiontype	http://eagle.helpdocsonline.com/available-filters [Entity Filter] See the Available Filters page in the EagleML wiki. ??EagleML reference
	entityselectionvalue
	entityselectiontype2
	entityselectionvalue2
	UsePrimaryBasisOnly
SMF	processingsecuritytype	http://eagle.helpdocsonline.com/available-filters [Security Master File (SMF) Filter] See the Available Filters page in the EagleML wiki. ??EagleML reference
	securitytype
	securityalias
	releasestatus
	primaryassetid
	investmenttype
	xrefid
	xrefidtype
	ticker
	historyonlyflag	http://eagle.helpdocsonline.com/available-filters [History Only Filter] See the Available Filters page in the EagleML wiki. ??EagleML reference
Security Related (SMF, Warehouse, Accounting and Reference)	smfrelatedflag	This parameter works with Generic Extract workflow only. Valid values: Y or N When you set smfrelatedflag to Y and specify some SMF-related feedtypes The filters are applied to SMF records, the SMFs are extracted by default A set of security aliases is created based on extracted SMFs SMF-related extracts are performed using the security aliases from the set defined on Step 2.
Default	SendNotification
	ACKDeliveryMethod
	ReplyDeliveryMethod
	CustomAckLocation
	CustomReplyLocation
Common	maxrows	http://eagle.helpdocsonline.com/available-filters [Common Filter] See the Available Filter page in the EagleML wiki. ??EagleML reference
	DeltaBased	http://eagle.helpdocsonline.com/available-filters [Delta Based Filter] See the Available Filter page in the EagleML wiki. ??EagleML reference
	DoNotPublishOnError	http://eagle.helpdocsonline.com/format-control-message See the Format Control Message page in the EagleML wiki. ??EagleML reference
	XSDValidation	http://eagle.helpdocsonline.com/format-control-message See the Format Control Message page in the EagleML wiki. ??EagleML reference
	QueryProfileName
Held	onlyheld	http://eagle.helpdocsonline.com/available-filters [Held Securities Filter] See the Available Filter page in the EagleML wiki. ??EagleML reference
	heldpositionsources
	heldcashactivitysources
	includecurrencyassets
Source	sourcename	http://eagle.helpdocsonline.com/available-filters [Sources Filter] See the Available Filter page in the EagleML wiki. ??EagleML reference
	datasources
Date	effectivedate	http://eagle.helpdocsonline.com/available-filters [Date Filter] See the Available Filter page in the EagleML wiki. ??EagleML reference
	fromdate
	fromeffectivedate
	updatedate
	todate
	toeffectivedate
Default	ACKDeliveryMethod	http://eagle.helpdocsonline.com/ejm-jobs-notifications See the EJM Jobs Notifications Overview page in the EagleML wiki. ??EagleML reference
	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	Archive Parameters
	ExtractDeliveryMethod
	FromFolder
	OutputZipFileName
	OutputZipFileNamePattern
	SendDataToFTP
	ToFolder

...

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.

...

Versions Compared

Old Version 4

New Version 5

Key