Cameron, OK. How would everyone feel about adding some simple instructions to the code so that others won't be stumped at that same point?
Or would that be "dumbing-down" the code too much... Thanks Kevin --- Cameron Schlehuber <[EMAIL PROTECTED]> wrote: > You've defined "A" and "B", at the IF: prompt simply > enter A&B or A!B, etc. > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > On Behalf Of Kevin > Toppenberg > Sent: Thursday, January 20, 2005 8:31 AM > To: [email protected] > Subject: Re: [Hardhats-members] How to make custom > reports with Fileman? > > 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" :-\ > > === message truncated === __________________________________ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail ------------------------------------------------------- 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
