VA FileMan V. 22.2 Programmer Manual Banner


 

Main Chapter Getting Started Manual Advanced User Manual

Database Server (DBS) API


VALUES^DILF(): FDA Values Retriever 

Reference Type Category ICR #
Supported Database Server (DBS) 2054
Description

The VALUES^DILF API returns values from an FDA for a specified field. The IENS associated with a particular value is also returned. Use the $$VALUE1^DILF(): FDA Value Retriever (Single) API if you want the single value associated with a particular file and field in a standard FDA.

Format
VALUES^DILF(file,field,fda_root,.result)
Input Parameters
file

(Required) File or subfile number.

field

(Required) Field number for which data is being requested.

fda_root

(Required) The root of the FDA from which data is being requested.

.result

(Required) Local array that receives output from the call. The array is KILLed at the beginning of each call.

REF: For the structure of the array, see the "Output" section.

Output

REF: See the .result input parameter.

The output from the call is returned in the array identified by result. Its structure is:

RESULT Number of values found for the specified field. If no node exists in the FDA for the field, RESULT=0.
RESULT(seq#) Value for a particular instance of the field. Seq# is an integer starting with 1 that identifies the value.
RESULT(seq#,"IENS") The IENS of the entry or subentry with the value in RESULT(seq#).
Example

Figure 192: VALUES^DILF API—Example: Input and Output

    >ZW MYFDA <Enter>
    MYFDA("DATA",16200,"33,",4)=FREE TEXT DATA
    MYFDA("DATA",16200.04,"1,33,",1)=16
    MYFDA("DATA",16200.04,"2,33,",1)=45

    >D VALUES^DILF(16200.04,1,"MYFDA(""DATA"")",.MYVALUES) <Enter>

    >ZW MYVALUES <Enter>
    MYVALUES=2
    MYVALUES(1)=16
    MYVALUES(1,"IENS")=1,33,
    MYVALUES(2)=45
    MYVALUES(2,"IENS")=2,33,
Error Codes Returned

None.


Reviewed/Updated: May 2026