Share via


GETVIEW Function (Record)

Gets a string that describes the current sort order, key, and filters on a table.

Syntax

  
String := Record.GETVIEW([UseCaptions])  

Parameters

Record
Type: Record

Specifies a record in the table for which you want to get the key and filters.

UseCaptions
Type: Boolean

Indicates whether a field caption or field number should be returned.

This parameter is optional. If this parameter is true (default value) or if it is empty, then the returned string contains references to field captions in the table with which the record is associated. If this parameter is false, then the returned string contains references to field numbers.

Property Value/Return Value

Type: Text or code

The current sort order, key, and filters on a table. The string format is the same as the SourceTableView Property on pages.

Remarks

If the SETVIEW Function (Record) has been executed, then the function will return the value that is set by SETVIEW.

Example

The following example uses the GETVIEW function to retrieve the key, the current sort order, and the filters that are set on the CustomerRec record in the Customer table. The function starts by returning the current key on which the Customer table is sorted. No., which is the field caption, is returned because the UseCaptions parameter is omitted. The key is stored in the ViewString variable and displayed in a message box. The sort key is then changed to the Name field and a filter that selects records with No. field values between 10000 and 20000 is set by using the SETVIEW Function (Record). The function returns the keys, sort order, and filter again. The return value is stored in the ViewString variable and displayed in a message box. The values that are displayed are Name, Addrees, and City, for the WHERE No.= FILTER(10000…20000) filter. Finally, the function displays the field numbers instead of the captions because UseCaptions is set to false. The sort order that is displayed is Field2, Field5 and Field7 instead of the field names. The filter is also displayed. This example requires that you create the following variables in the C/AL Globals window.

Variable name DataType Subtype
CustomerRec Record Customer
ViewString Text Not applicable
ViewString := CustomerRec.GETVIEW;  
MESSAGE('The string:%1', ViewString);  
CustomerRec.SETVIEW('SORTING(Name) ORDER(Ascending) WHERE(No.=CONST(10000..20000))');  
ViewString := CustomerRec.GETVIEW;  
MESSAGE('The string:%1', ViewString);  
ViewString := CustomerRec.GETVIEW(FALSE);  
MESSAGE('The string:%1', ViewString);  

See Also

Record Data Type