Re: [Hardhats-members] Dificulty with Fileman search

[Greg Kreis]

I wonder what INTERNAL(ENTERED BY) would do for the search criteria....  This function returns the value directly from the global.  I suspect you would have to compare the value to the IEN of the record you wanted to match. That would be inconvenient.....  but maybe, just maybe, FM could see the field that is passed to the function and do a lookup on it at time of the selecting the matching value....  but I am probably dreaming. Greg Woodhouse wrote: Just a thought: I believe you could create a cross-reference that would all you to search on this field, after all. --- "Holloway, Thomas (EDS)" <[EMAIL PROTECTED]> wrote: Kevin, Greg W. was basically correct that "=" SHOULD work but it turns out that there's a twist. I was surprised that it didn't work, so I tested things a little. I added an "ENTERED BY" field to a small test file that I use. I started with it just plain vanilla: a pointer to #200 with no extra characteristics. I populated that field on 5 records. Then I performed a Search using "=" and selecting the EDITED BY person by entering initials as you did. The Search found all 5 records. I then went back and added an OUTPUT TRANSFORM to the field and tried the Search again. This time I got 0 records. Obviously the Output Transform plays a critical role in the matching process. You found your records with the 'Contains' condition because you entered exactly what the Output Transform produces (i.e. it's what you saw on the Inquire). I guess the conclusion is that one really needs to know their database when constructing Searches. If there's an Output Transform on the field you are searching, you have to take it into consideration. Thom H. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Kevin Toppenberg Sent: Tuesday, March 08, 2005 9:58 PM To: Hardhats Sourceforge Subject: [Hardhats-members] Dificulty with Fileman search I am having trouble with the Fileman search function. Will it only search on fields that have an index? I am trying to do a simple search for field 1302 (ENTERED BY)=MANAGER,TRANSCRIPTION (initials: tmgr), I will then try to follow instructions from Thomas' post about changing this to another user. I know that many records have a value of tmgr for this field. But it doesn't find them in the search. First I'll show that ENTERED BY contains 'tmgr' for at least one record: -------------------------- Include COMPUTED fields: (N/Y/R/B): NO// b BOTH Computed Fields and Record Num ber (IEN) NUMBER: 5901 DOCUMENT TYPE: OFFICE VISIT PATIENT: 15377 PARENT DOCUMENT TYPE: OFFICE NOTES CLASS STATUS: COMPLETED EPISODE BEGIN DATE/TIME: FEB 28, [EMAIL PROTECTED]:12:46 VISIT TYPE: A ENTRY DATE/TIME: FEB 28, [EMAIL PROTECTED]:17:48 AUTHOR/DICTATOR: THWING,PHILIP T EXPECTED SIGNER: THWING,PHILIP T HOSPITAL LOCATION: Laughlin_Office VISIT LOCATION: Laughlin_Office DIVISION: Medical Group of Greeneville REFERENCE DATE: FEB 24, [EMAIL PROTECTED]:00 ENTERED BY: tmgr CAPTURE METHOD: remote procedure SIGNATURE DATE/TIME: FEB 28, [EMAIL PROTECTED]:10:42 SIGNED BY: THWING,PHILIP T SIGNATURE BLOCK NAME: PHILIP T THWING SIGNATURE MODE: electronic COSIGNATURE NEEDED: NO REPORT TEXT: xxxxxxxxxx -------------------------- Now I will show that a search for this record fails: ------------------------- OUTPUT FROM WHAT FILE: TIU DOCUMENT// -A- SEARCH FOR TIU DOCUMENT FIELD: enterED BY -A- CONDITION: eQUALS -A- EQUALS NEW PERSON: tmgr MANAGER,TRANSCRIPTION tmgr TRANSCRIP TIONIST -B- SEARCH FOR TIU DOCUMENT FIELD: IF: A// ENTERED BY EQUALS 101 (MANAGER,TRANSCRIPTION) STORE RESULTS OF SEARCH IN TEMPLATE: SORT BY: NUMBER// START WITH NUMBER: FIRST// FIRST PRINT FIELD: .01 DOCUMENT TYPE THEN PRINT FIELD: Heading (S/C): TIU DOCUMENT SEARCH// DEVICE: TELNET TIU DOCUMENT SEARCH MAR 8,2005 21:47 PAGE 1 DOCUMENT TYPE ------------------------------------------------------------------------ -------- 0 MATCHES FOUND. Press RETURN to continue... ---------------------------- What am I doing wrong? Thanks Kevin __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_ide95&alloc_id396&op=click _______________________________________________ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members ===== A practical man is a man who practices the errors of his forefathers. --Benjamin Disraeli ==== Greg Woodhouse [EMAIL PROTECTED] [EMAIL PROTECTED] ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members -- Greg Kreis http://www.PioneerDataSys.com "You are today where your thoughts have brought you, you will be tomorrow where your thoughts take you." (James Lane Allen)