Jim,
First, it needs to be intuitive. I think that Google has done a very good job of this. I like how they have basic searches and then Advanced searches.
So maybe to search in file NEW PERSON for patients with DOB before 1/1/1950 after 1/1/1980, you could have something like this:
Basic search or Advanced search? BASIC// BASIC
Search in which file? NEW PERSON// NEWPERSON
Which field? NAME// DOB
Search For? // > 1/1/1980 OR < 1/1/1950
(or the syntax might need to be made easier to guess...)
Here are your results:
xxx
Or for a more advanced search of patients before 1/1/1950 or after 1/1/1980 and sex of male
Basic search or Advanced search? BASIC// ADVANCED
Search in which file? NEW PERSON// NEWPERSON
Search in which field? NAME// DOB
Search For? // > 1/1/1980 OR < 1/1/1950
Additional field to search? DOB// SEX
Search for? // MALE
Additional field to search? SEX//
Here are your results:
xxx
I'd have to think about this more carefully to ensure that all possibilities of NOT, OR, AND etc. are covered, but that's a start.
Kevin
Jim Self <[EMAIL PROTECTED]> wrote:
Kevin wrote:
>Jim,
>
>On my "someday" list, I am going to put a task to get
>this search interface spruced up.
Providing a better search interface is on my project list also. This search module is
quite functional once you learn how to use it, but it appears to have changed very little
since incorporation of my fix to it about 23 years ago that enabled searching on
subfields. If we want to work together on it, we should start by describing what is good
and bad about it and how it could be improved.
>I think I would like to explore the M2Web now.
>
>I spent some time going through your web page
>http://www.vmth.ucdavis.edu/us/jaself
>But couldn't find a link re where to get the code.
>I'm probably overlooking it.
Sorry about that. That page had an outdated link on it to the M2Web demo site that I have
now fixed.
>Could you send me a URL?
The most recent instructions are "M2Web setup update 2004-12-20" at
http://vista.vmth.ucdavis.edu/notebook/index/48.html
>Thanks
>KEvin
>
>
>--- Jim Self <[EMAIL PROTECTED]>wrote:
>
>> Kevin wrote:
>>
>> > -B- SEARCH FOR PATIENT FIELD: sex
>> > -B- CONDITION: cONTAINS
>> > -B- CONTAINS: M
>> > [ Will match 'MALE', and 'FEMALE' ]
>>
>>
>> The operator "CONTAINS" does not appear to be
>> appropriate here.
>> If you want to get "MALE" but not "FEMALE", you must
>> use "EQUALS" instead.
>>
>> The operator "CONTAINS" matches on the external
>> value of the field, while "EQUALS" matches
>> on the internal value - a point of convenience and
>> confusion.
>>
>> I left out the part where you entered a lowercase
>> "m". When attempting to duplicate the
>> search and refresh my memory of how it worked, I
>> made almost the same mistake you did and
>> entered the "M" (you entered "m") in answer to
>> "SEARCH FOR PATIENT FIELD" question. I was
>> surprised to see that it then went into a seemingly
>> inescapable loop of presenting about
>> 20 guesses for cross-referenced fields after I had
>> already attempted to escape ("^") from
>> the question where it listed all the first-level
>> fields with names begining with M.
>>
>> I had not used Fileman's search module in quite a
>> long while, so I was somewhat dismayed
>> to see that this old user trap was still there and
>> appears to have gotten worse. :(
>>
>> >
>> > -C- SEARCH FOR PATIENT FIELD:
>> >
>> >IF: ? ??
>> >IF:??
>> >IF:??
>> >IF:??
>> >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.
>>
>> If you already have GT.M, VistA, and Apache
>> installed on Linux, then connecting it all up
>> with M2Web should take less than half an hour. Of
>> course, that would give you more to
>> learn about, but it would also make it easier to
>> understand much of the VistA stuff by
>> exposing it to you in a web browser and giving you
>> new ways to view it all.
>>
>> Also, I think that much of what you have already
>> done in feeding data to VistA from
>> external applications could be easily adapted to
>> work from M2Web and then expanded into a
>> full bidirectional interaction.
>>
>>
>>
>> >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.
>>
>> M2Web cannot be formally put *into* Fileman for a
>> number of reasons, one of which is that
>> it is broader in its intended scope than Fileman.
>> However, M2Web can work with Fileman
>> and/or with Fileman defined data. M2Web is a
>> collection of tools for connecting MUMPS
>> applications to the web. Only a part of M2Web is
>> directly concerned with database access
>> and that part is not limited to handling the type of
>> data structures defined by Fileman.
>>
>> One thing that can be done is to build interfaces
>> between Fileman and M2Web. One area that
>> is particularly interesting to me right now is
>> building a general web based interface for
>> editing data using the Fileman DBS API's.
>>
>> ---------------------------------------
>> Jim Self
>> Systems Architect, Lead Developer
>> VMTH Computer Services, UC Davis
>> (http://www.vmth.ucdavis.edu/us/jaself)
---------------------------------------
Jim Self
Systems Architect, Lead Developer
VMTH Computer Services, UC Davis
(http://www.vmth.ucdavis.edu/us/jaself)
-------------------------------------------------------
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
Hardhats-members@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hardhats-members
Do you Yahoo!?
Yahoo! Search presents - Jib Jab's 'Second Term'
