Skip to main content

%FileMan.Field

deprecated persistent class %FileMan.Field extends %Library.Persistent

SQL Table Name: %FileMan.Field

This file stores the descriptive information for all fields in a file for a FileMan managed database.

Note: The FileMan toolset is available and fully supported in InterSystems IRIS for existing FileMan users. InterSystems recommends against starting new development projects using FileMan.

Property Inventory

Parameters

parameter READONLY = 1;
Inherited description: READONLY = 1 means that objects can be created, opened but not saved or deleted. Tables are projected to SQL as READONLY.

Properties

property CHARACTERISTICS as %String;
Property methods: CHARACTERISTICSDisplayToLogical(), CHARACTERISTICSGet(), CHARACTERISTICSIsValid(), CHARACTERISTICSLogicalToDisplay(), CHARACTERISTICSLogicalToOdbc(), CHARACTERISTICSNormalize(), CHARACTERISTICSSet()
property DESCRIPTION as list of %String;
Property methods: DESCRIPTIONBuildValueArray(), DESCRIPTIONCollectionToDisplay(), DESCRIPTIONCollectionToOdbc(), DESCRIPTIONDisplayToCollection(), DESCRIPTIONDisplayToLogical(), DESCRIPTIONGet(), DESCRIPTIONGetObject(), DESCRIPTIONGetObjectId(), DESCRIPTIONGetSwizzled(), DESCRIPTIONIsValid(), DESCRIPTIONLogicalToDisplay(), DESCRIPTIONLogicalToOdbc(), DESCRIPTIONNormalize(), DESCRIPTIONOdbcToCollection(), DESCRIPTIONSet(), DESCRIPTIONSetObject(), DESCRIPTIONSetObjectId()
relationship FILE as %FileMan.File [ Required , Inverse = FIELDS , Cardinality = parent ];
Property methods: FILEGet(), FILEGetObject(), FILEGetObjectId(), FILEGetSwizzled(), FILEIsValid(), FILENewObject(), FILEOnDelete(), FILERClose(), FILERExec(), FILERFetch(), FILERelate(), FILESQLCompute(), FILESet(), FILESetObject(), FILESetObjectId(), FILEUnRelate(), FILEUnSwizzle()
property NAME as %String;
Property methods: NAMEDisplayToLogical(), NAMEGet(), NAMEIsValid(), NAMELogicalToDisplay(), NAMELogicalToOdbc(), NAMENormalize(), NAMESet()
property NUMBER as %Numeric [ Required ];
Property methods: NUMBERDisplayToLogical(), NUMBERGet(), NUMBERIsValid(), NUMBERLogicalToDisplay(), NUMBERNormalize(), NUMBERSet()

Queries

query AllFields(file As %Library.String)
SQL Query:
SELECT NUMBER,NAME FROM %FileMan.Field WHERE "FILE" = :file OR :file IS NULL ORDER BY NUMBER
query AllFieldsByName(file As %Library.String)
SQL Query:
SELECT NUMBER,NAME FROM %FileMan.Field WHERE "FILE" = :file OR :file IS NULL ORDER BY NAME

Indexes

index (IdKey on NUMBER) [IdKey, PrimaryKey, Type = key, Unique];
Index methods: IdKeyCheck(), IdKeyDelete(), IdKeyExists(), IdKeyOpen(), IdKeySQLCheckUnique(), IdKeySQLExists(), IdKeySQLFindPKeyByConstraint(), IdKeySQLFindRowIDByConstraint()

Inherited Members

Inherited Methods

Storage

Storage Model: SQLStorage

Maps: 1

  • Map number 1 is named Master

    thismap.Global: ^DD

  • ^DD({%FileMan.File.NUMBER},{NUMBER})
    =
    Node Delimiter Piece Name
    0 "^" 1 NAME
    0 "^" 2 CHARACTERISTICS
    DESCRIPTION
FeedbackOpens in a new tab