Show / Hide 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.0

    Back to top Copyright © 2020 SmartApps
    Generated by DocFX