ADDRECORDREF Function

  • Article

Adds filter control for a table to a filter page. The table is specified by a recordref variable that is passed to the function .

This creates a filter control on the filter page, where users can set filter table data.

[Name :=] FilterPageBuilder.ADDRECORDREF(ItemName, RecordRef)

Parameters

  • ItemName
    Type: Text The text to display as the caption for the filter control for the specified table.

    Note

    Within the collection of filter controls on the filter page, you cannot assign the same ItemName to different table IDs; otherwise a runtime an error occurs.

  • RecordRef
    Type: RecordRef The record reference to use in the filter control.

Return Value

Type: Text

The name assigned to the item or an empty string if an error occurred. An error message will be shown if the return value is not used.

Remarks

In the filter page that is rendered in the Microsoft Dynamics NAV client, the ADDRECORDREF function defines a filter control for the specified table where the user can add and set the filters on the table.

Fields in the table that already have filters are automatically included in the filter control. Filters in the record reference passed to the function will not be modified by any function in the FilterPageBuilder object.

Example

The following example initializes a filter page object that includes a filter control that uses the Date system table. The filter control has the caption of Date record. The example set two filters are on the Date record variable, which results in a filter control that includes two fields by default.

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

Variable name DataType SubType

varDateItem

Text

varDateRecord

Record

Date

varDateRecordRef

RecordRef

varFilterPageBuilder

FilterPageBuilder

 
varDateItem := 'Date record';
varDateRecord.SETFILTER("Period End",'12122015D');
varDateRecord.SETFILTER("Period Start",'01012015D');
varDateRecordRef.GetTable(varDateRecord);
varFilterPageBuilder.ADDRECORDREF(varDateItem,varDateRecordRef);

See Also

Reference

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