Skip to end of metadata
Go to start of metadata

 Webinar with Certificate | Recorded Webinar |  Additional Resources | Others from this presenter | Related Questions





Thumbnail Page Comment

Greg Kreis

Greg Kreis worked for the Veterans Administration as a programmer and projects manager from 1983-1985. He then implemented VistA systems for two companies before starting Pioneer Data Systems in 1989.


Webinar Overview
DSS, Inc. supports native VistA Fileman query and reporting within vxCPRS. This model provides extensive and unique capabilities, making complimentary availability a necessity when relying on the vxVistA Enterprise EHR for everyday and cyclical data reporting requirements. 

FileMan is the native database management system for MUMPS (M) and is very tightly woven into the structures of both the database and the data itself. Computed code values, standard lookups, array definition, powerful formatting tools, and many other features make this an ideal tool for ad hoc queries by advanced staff entrusted by your organization to perform lookups and research. FileMan is also able to be used for “canned” reporting with stored report formats called upon by end-users with significant frequency and made available via screen or print output formats.

Course with Certificate

Recorded Webinar

Additional resources

Pioneer Data Systems Website

Presenter Webinars Participation

Recent Questions


  1. 0


  1. One thing I am hoping to get from this webinar are pointers to how one can explore VistA data by typing stuff directly to the M prompt

    1. Was some of your expectations met?

  2. If I have Field # .01 and Piece 1 with global location SRF (D0, 13, D1, 1, D2, 0). 
    How would I search for this field in FM to find the exact field #?

    1. The global map format of the List FIle Attributes option on the Data Dictionary menu of FM will show the layout of the node in question.

  3. Is there some kind of mechanism by which multiples can automagically journal some metadata (like date/time) when they're updated?

    1. Sure.  Create a field in the data base that is a date and time field.  Then create a FM Trigger (a kind of traditional cross-reference) on the field that is being monitored (in this example, the .01 field of the multiple).  When a multiple entry is created (ie. when the .01 field gets a value) the trigger will update the new date/time field with whatever value your specify (NOW or perhaps TODAY).

  4. Fild Name recognition: Why "ST,1" was understood as "Street Address 1"? How come "State" was not picked?

    1. When FM sees the comma is turns it into a search using the text before the comma, followed by a test to see if any found values also contain the value found after the comma.  Sort of a filtered lookup on the fly!

  5. We were told to use P^DI instead of Q^DI.  What is the difference when getting into File Man?

    1. The P entry point cleans out variables from the symbol table where as the Q entry point leaves them alone.