Table of Contents

RecRef Functions

Helper functions for RecordRefs and FieldRefs.

Object Definition

Object TypeCodeunit
Object ID70327086
Object NameQWETB RecRef Functions

Procedures

Name Description
AddFiltersFromView(RecordRef; Text) Adds filters from a view to a RecordRef, in the current FilterGroup.
BlankFldValue(FieldRef) Clears the value of a FieldRef.
CopyRecRef(RecordRef; RecordRef) Copies all fields from one RecordRef to another RecordRef.
FieldExists(Integer; Integer): Boolean Checks if a field exist in a given table.
FieldValueIsBlank(FieldRef): Boolean Check if a value of a FieldRef is blank.
GetFieldCaption(Integer; Integer): Text Gets the caption of a field, including dynamic captions as global dimension captions.
GetFieldCaption(Integer; Integer; Text): Text Gets the caption of a field, including dynamic captions as global dimension captions.
GetFieldCaption(Record Field): Text Gets the caption of a field, including dynamic captions as global dimension captions.
GetFilteredFieldsFromView(Text): Dictionary of [Integer, Text] Gets the filtered fields from a view text.
GetSystemId(RecordRef): Guid Gets the SystemId of a RecordRef.
GetValueBool(Text; Boolean): Boolean Formats a value as a boolean.
GetValueDate(Text; Boolean): Date Formats a value as a date.
GetValueDateFormula(Text; Boolean): DateFormula Formats a value as a DateFormula.
GetValueDateTime(Text; Boolean): DateTime Formats a value as a datetime.
GetValueDec(Text; Boolean): Decimal Formats a value as a decimal.
GetValueDuration(Text; Boolean): Duration Formats a value as a Duration.
GetValueGuid(Text; Boolean): Guid Formats a value as a guid.
GetValueInt(Text; Boolean): BigInteger Formats a value as an integer.
GetValueOption(FieldRef; Text; Boolean): BigInteger Formats a value as an Option or Enum value ordinal.
GetValueRecordId(Text; Boolean): RecordId Formats a value as a RecordId.
GetValueTime(Text; Boolean): Time Formats a value as a time.
GetViewFromWhereClause(Text): Text Gets a view text from a WHERE clause.
GetWhereClauseFromView(Text): Text Gets the WHERE clause from a view text.
InitializeIfCrmTable(Integer) Initializes the CDS or CRM Integration connections if the table is a CRM table.
IsBlank(Variant): Boolean Check if a value of any datatype is blank.
IsEqual(Variant; Variant): Boolean Check if two values, of any datatype, are identical. This function used the XML Format function for the comparison.
IsFieldInPK(Integer; Integer): Boolean Used to check if a field is part of the Primary Key (PK).
IsFieldRefInPK(FieldRef): Boolean Used to check if a field is part of the Primary Key (PK).
IsPk(RecordRef; Integer): Boolean Used to check if a field is the Primary Key (PK) of a table.
LookupFieldNo(Integer; Integer; Boolean): Boolean Shows a Lookup page with the fields for the selected table.
LookupFieldNo(Integer; Integer; Record Field): Boolean Shows a Lookup page with the fields for the selected table.
LookupValue(RecordRef; Integer; Text): Boolean Shows a lookup page for a selected field in a given table.
RecordsAreIdentical(Variant; Variant): Boolean Checks if two records are identical.
SetFldRange(FieldRef; Text; Boolean) Calls the SetRange method on provided FieldRef.
SetFldValue(FieldRef; Text; Boolean) Sets the value of a FieldRef from a text value.
TableExists(Integer): Boolean Checks if a table do exist.
TransferFieldsRecRef(RecordRef; RecordRef; Boolean) Copies all fields from one RecordRef to another RecordRef, similar to the Record.TransferFields() method.
TransferSelectedFieldsRecRef(RecordRef; RecordRef; Boolean; Integer; Integer) Copies a range of fields from one RecordRef to another RecordRef.
TrySetFldValue(FieldRef; Text; Boolean) Sets the value of a FieldRef from a text value.
TryValidateFldValue(FieldRef; Text; Boolean) Sets the value of a FieldRef from a text value and validates the field.
ValidateFldValue(FieldRef; Text; Boolean) Sets the value of a FieldRef from a text value and validates the field.

Events

Name Description
OnBeforeLookupRelatedValue(RecordRef; RecordRef) Raised by the LookupValue function, before the lookup page of the related table is shown.

This documentation is generated from Smart Toolbox v27.1