
Webinar with Certificate | Recorded Webinar | Additional Resources | Others from this presenter | Related Questions
|
|
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
Presenter Webinars Participation
Overview
Content Tools
Apps
Activity
10 Comments
VistA Community Member
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
Greg Kreis
Was some of your expectations met?
VistA Community Member
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 #?
Greg Kreis
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.
VistA Community Member
Is there some kind of mechanism by which multiples can automagically journal some metadata (like date/time) when they're updated?
Greg Kreis
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).
VistA Community Member
Fild Name recognition: Why "ST,1" was understood as "Street Address 1"? How come "State" was not picked?
Greg Kreis
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!
VistA Community Member
We were told to use P^DI instead of Q^DI. What is the difference when getting into File Man?
Greg Kreis
The P entry point cleans out variables from the symbol table where as the Q entry point leaves them alone.