Jim (and everyone else, too), replies below:
--- Jim Self <[EMAIL PROTECTED]> wrote:
> Kevin wrote:
> >Hey All,
> >
> >It seems to me that Fileman is missing a report
> >generator. Perhaps I am just overlooking it.
>
> You overlooked it.
> The Search and Print options from the
> roll-and-scroll interface give you quite powerful
> reporting capabilities.
Talk about "if it had been a snake it would have bit
me" Ha.
I had completely overlooked the "Search" Function.
This looks similar to what I want. But I still can't
figure out how it works. I'm clueless as to what it
wants at the "IF:" prompt. (Why can't Fileman be less
terse?) Here's a screen log of my attempts
OUTPUT FROM WHAT FILE: PATIENT//
-A- SEARCH FOR PATIENT FIELD: .01 NAME
-A- CONDITION: ?
Answer with CONDITION NUMBER, or NAME
Choose from:
1 NULL
2 CONTAINS
3 MATCHES
4 LESS THAN
5 EQUALS
6 GREATER THAN
YOU CAN NEGATE ANY OF THESE CONDITIONS BY PRECEDING
THEM WITH "'" OR "-"
SO THAT "'NULL'" MEANS "NOT NULL"
-A- CONDITION: 2 CONTAINS
-A- CONTAINS: wigle
-B- SEARCH FOR PATIENT FIELD: sex
-B- CONDITION: cONTAINS
-B- CONTAINS: male
ENTER A VALUE WHICH 'SEX'
MUST CONTAIN, IN ORDER FOR TRUTH CONDITION -B-
TO BE TRUE
Use EXTERNAL VALUE (from list on the right)
Enter 'M' for MALE, or 'F' for FEMALE.
Choose from:
M MALE
F FEMALE
-B- SEARCH FOR PATIENT FIELD: m
1 MARITAL STATUS
2 MEDICAID ELIGIBILE? ELIGIBLE FOR MEDICAID?
3 MEDICAID NUMBER
4 METHOD OF DETERMINATION
5 MILT RET DUE TO DISABILITY? DISABILITY RET.
FROM MILITARY?
Press <RETURN> to see more, '^' to exit this list, OR
CHOOSE 1-5: ^??
-B- SEARCH FOR PATIENT FIELD: sex
-B- CONDITION: cONTAINS
-B- CONTAINS: M
[ Will match 'MALE', and 'FEMALE' ]
-C- SEARCH FOR PATIENT FIELD:
IF: ? <?>??
IF: <TYPE '^' TO EXIT>??
IF: <TYPE '^' TO EXIT>??
IF: <TYPE '^' TO EXIT>??
IF: ?? <?>??
IF: 1 <1>??
IF: ^
Press RETURN to continue...
>
> If you augment Fileman with M2Web, then you will
> have additional capabilities for doing
> database queries from a web browser and a great many
> additional options for formatting the
> results on-the-fly, including switching the output
> type from html to xml or xls.
Again, I really want to sit down with your M2Web
technology someday and implement it. I just can't get
diverted right now. Too much on my plate. It looks
extremely powerful. I hope that it gets put formally
into Fileman, as was the object of a recent Friday
conference call.
>
> >A database should be able to easily allow the user
> to
> >say:
> >--Give me all reports
> >--Of the following date
> >--With field .12345=Value
> >
> >When I have written before about during searches on
> >multiple fields, I have been told to use FIND^DIC
> and
> >create custom screening code that checks for the
> >secondary and tertiary factors.
>
> Why was that? Was is because you were trying to do
> the searches from a non roll-and-scroll
> interface or because of some perceived inadequacy of
> the Search module?
Yes, I had been doing it programatically. And, as
above, I had overlooked the Search function
>
> >But does use of fileman require programming skills?
>
> Not really, but advanced users would benefit from
> knowing something about MUMPS functions
> and operators for specifying calculations on data
> values - and Fileman conventions for
> referring to data field values and for extending
> data field references from one file to
> another.
>
> >Furthermore, its a hassle to try to get one's
> entire
> >screening logic compressed into one line of
> screening
> >code.
> >
> >If this tool is not currently available, it seems
> it
> >should be fairly easy to create.
>
> If that would be easy for you, then you are a far
> better programmer than anyone I know and
> you are wasting your talents and valuable time
> working as a mere doctor. ;-) Perhaps you
> could help out with developing a general web
> interface to Fileman and VistA databases -
> that could be world changing. :-D
"Easy" is always a trap word. What I had in mind was
something similar to what is in the search function.
I had in mind taking each of the logical steps,
getting a list of matches and logically combining
them. I.e. allow a search like this:
.01:((Doe,J) OR (Doe,A)) AND .03:((1960) OR (1972))
Separate searches would be done for Doe,J in field
.01. and Doe,A in field .01. Combine these two lists
via OR logic. Then perform separate searches for 1960
in field .03 and 1972 in .03. Combine these two lists
via OR logic. Then combine the two resulting lists
via AND logic. "Easy" :-\
But as you can see in my other posts, I can't even
consistantly get FIND^DIC to find one single patient
(which I know is in the database), when searching on
just the .01 field.
So maybe I thought it should be "easy" for you experts
out there... LOL!
Thanks a lot
Kevin
__________________________________
Do you Yahoo!?
Yahoo! Mail - Easier than ever with enhanced search. Learn more.
http://info.mail.yahoo.com/mail_250
-------------------------------------------------------
This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
Tool for open source databases. Create drag-&-drop reports. Save time
by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
Download a FREE copy at http://www.intelliview.com/go/osdn_nl
_______________________________________________
Hardhats-members mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hardhats-members
