SETVIEW Function

Sets the current filter view, which defines the sort order, key, and filters, for a record in a filter control on a filter page.

The view contains all fields that have default filters, but does not contain fields without filters.

[Ok :=] FilterPageBuilder.SETVIEW(ItemName, View)

Parameters

  • ItemName
    Type: Text or Code The name that is assigned to 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.

Return Value

Type: Boolean

true if view was applied to 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. Either the ADDTABLE, ADDRECORD, or ADDRECORDREF functions must be called before the SETVIEW function.

The SETVIEW function will overwrite any previously defined filters for the fields that are also included in the view.

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 filter fields to the filter control on the filter page as the result of applying a default view from the GETVIEW function.

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

varDefaultView

Text

varDateItem := 'Date record';
varDateRecord.SETFILTER("Period End", '12122015D');
varDateRecord.SETFILTER("Period Start", '01012015D');
varDefaultView := varDateRecord.GETVIEW;
varFilterPageBuilder.ADDTABLE(varDateItem, DATABASE::Date);
varFilterPageBuilder.SETVIEW(varDateItem, varDefaultView);

See Also

Reference

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