ADDFIELDNO Function

Adds a table field to the filter control for a table on the filter page.

[Ok :=] FilterPageBuilder.ADDFIELDNO(ItemName, FieldNo[,Filter])

Parameters

  • ItemName
    Type: Text The name that is assigned to the table in the filter control. This value must match the value of the ItemName parameter that was specified by ADDTABLE, ADDRECORD, or ADDRECORDREF function that adds the table to the filter control.
  • FieldNo
    Type: Integer The number that is assigned to the field in the table as specified by the Field No. Property.
  • Filter
    Type: Text A default filter on the field that is specified by the Field parameter.

Return Value

Type: Boolean

true if the field was added to the field list for the specified filter control; otherwise, false.

Remarks

The filter control that is specified by ItemName must already exist in the FilterPageBuilder object before the ADDFIELDNO function is called. This means that either the ADDTABLE, ADDRECORD, or ADDRECORDREF functions must be called before the ADDFIELD function.

If the filter page implementation will call a SETVIEW function, then the SETVIEW function must be called before the ADDFIELDNO function call, otherwise the default filter that is specified by the Filter parameter for field, if any, will be cleared by SETVIEW.

The filter that is specified by the Filter parameter will overwrite any previously defined filters for the field which were set by ADDVIEW function or read from the record or recordRef instance that defined the filter control.

Example

The following example initializes a filter page object that includes a filter control for the Date system table. The filter control has the caption of Date record. The example adds two fields of the Date record variable which will be available in the filter control on the filter page: Period End and Period Start. A default filter is set on the Period End field.

This example requires that you create the following variables in the C/AL Globals window.

Variable name DataType SubType

varDateItem

Text

varDateRecord

Record

Date

varFilterPageBuilder

FilterPageBuilder

varDateItem := 'Date record';
varFilterPageBuilder.ADDRECORD(varDateItem, varDateRecord);
varFilterPageBuilder.ADDFIELDNO(varDateItem, varDateRecord.FIELDNO(varDateRecord."Period End"),'03032014D');
varFilterPageBuilder.ADDFIELDNO=(varDateItem, varDateRecord.FIELDNO(varDateRecord."Period Start"));

See Also

Reference

ADDFIELD Function
ADDFIELDNO Function
ADDRECORD Function
ADDRECORDREF Function
GETVIEW function (FilterPageBuilder)
SETVIEW Function
COUNT Function (FilterPageBuilder)
NAME Function (FilterPageBuilder)
RUNMODAL Function (FilterPageBuilder)