RE: [Hardhats-members] Fileman search broken?

[Nevius, Gordon D.]

Kevin is not doing anything wrong, the Search can not do this because he is searching on the .01 field of the multiple and obviously the .01 field can not be equal to acetaminophen and alcohol at the same time, so Kevin needs to do a "double search". Example entry: ============== Select OPTION: INQUIRE TO FILE ENTRIES    OUTPUT FROM WHAT FILE: VA PRODUCT// Select VA PRODUCT NAME: ACETAMINOPHEN 130MG/5ML SOLN,ORAL  ANOTHER ONE: STANDARD CAPTIONED OUTPUT? Yes//   (Yes) Include COMPUTED fields:  (N/Y/R/B): NO//  - No record number (IEN), no Computed  Fields DISPLAY AUDIT TRAIL? No//   NO   NAME: ACETAMINOPHEN 130MG/5ML SOLN,ORAL [snip] ACTIVE INGREDIENTS: ALCOHOL             STRENGTH: 10   UNITS: % ACTIVE INGREDIENTS: ACETAMINOPHEN       STRENGTH: 130   UNITS: MG/5ML   PRIMARY VA DRUG CLASS: CN103          NATIONAL FORMULARY INDICATOR: YES   INACTIVATION DATE: SEP 07, 2000       DSS NUMBER: 19   Here is the "how to": ===================== Select OPTION:    SEARCH FILE ENTRIES   OUTPUT FROM WHAT FILE: VA PRODUCT//     -A- SEARCH FOR VA PRODUCT FIELD:    ACTIVE INGREDIENTS   (multiple)       -A- SEARCH FOR VA PRODUCT ACTIVE INGREDIENTS SUB-FIELD:    ACTIVE INGREDIENT S     -A- CONDITION: EQUALS      -A- EQUALS DRUG INGREDIENTS: ACETAMINOPHEN           ...OK? Yes//   (Yes)       -B- SEARCH FOR VA PRODUCT ACTIVE INGREDIENTS SUB-FIELD:     -B- SEARCH FOR VA PRODUCT FIELD:   IF: A//     VA PRODUCT ACTIVE INGREDIENTS EQUALS 105 (ACETAMINOPHEN)   DO YOU WANT THIS SEARCH SPECIFICATION TO BE CONSIDERED TRUE FOR CONDITION -A-         1) WHEN AT LEAST ONE OF THE 'ACTIVE INGREDIENTS' MULTIPLES SATISFIES IT         2) WHEN ALL OF THE 'ACTIVE INGREDIENTS' MULTIPLES SATISFY IT     CHOOSE 1-2: 1//   STORE RESULTS OF SEARCH IN TEMPLATE: ZZSO ACETAMINOPHEN   Are you adding 'ZZSO ACETAMINOPHEN' as a new SORT TEMPLATE? No// Y  (Yes) DESCRIPTION:   No existing text   Edit? NO//   SORT BY: NAME// START WITH NAME: FIRST// FIRST PRINT FIELD: <--no print field because we don't care. Heading (S/C): VA PRODUCT SEARCH// DEVICE:   IRMS BLDG 74 ROOM 227E    Right Margin: 80// VA PRODUCT SEARCH                              JAN  5,2006  15:13    PAGE 1 --------------------------------------------------------------------------------                                250 MATCHES FOUND.       Select OPTION: PRINT FILE ENTRIES    OUTPUT FROM WHAT FILE: VA PRODUCT// SORT BY: NAME// [ZZSO ACETAMINOPHEN                                    (Jan 05, [EMAIL PROTECTED]:13) User #29386 File #50.68  SEAR CH    WITHIN 'ZZSO ACETAMINOPHEN' NUMBER, SORT BY: ACTIVE INGREDIENTS    (multiple)   ACTIVE INGREDIENTS SUB-FIELD: .01  ACTIVE INGREDIENTS   START WITH ACTIVE INGREDIENTS: FIRST// ALCOHOL   GO TO ACTIVE INGREDIENTS: LAST// ALCOHOL     WITHIN ACTIVE INGREDIENTS, SORT BY: STORE IN 'SORT' TEMPLATE: FIRST PRINT FIELD: NAME  THEN PRINT FIELD: Heading (S/C): VA PRODUCT LIST// START AT PAGE: 1// DEVICE: 0;P-OTHER;80;99999  IRMS BLDG 74 ROOM 227E VA PRODUCT LIST                                JAN  5,2006  15:14    PAGE 1 NAME --------------------------------------------------------------------------------              ACTIVE INGREDIENTS: ALCOHOL CODEINE 12MG/ACETAMINOPHEN 120MG/5ML ELIXIR ACETAMINOPHEN 130MG/5ML SOLN,ORAL APAP 108MG/CTM 0.6MG/DM 3.3MG/PSEUDEFED 10MG/5ML LIQUID APAP 125MG/DM 5MG/GG 50MG/PSEUDEFED 15MG/5ML LIQUID APAP 167MG/DM 5MG/DOXYLAMINE 1.25MG/PSEUDEFED 10MG/5ML LIQUID ACETAMINOPHEN 500MG/DIPHENHYDRAMINE HCL 25MG/15ML LIQUID ACETAMINOPHEN 250MG/DEXTROMETHORPHAN 7.5MG/5ML LIQUID           Select OPTION:         From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Toppenberg Sent: Thursday, January 05, 2006 11:56 AM To: Hardhats Sourceforge Subject: [Hardhats-members] Fileman search broken?   Fileman UI search doesn't seem to work the way it seems it should. Below is a screen log of a search.  It is searching for all records in the VA PRODUCT file with the multiple field ACTIVE INGREDIENTS having a .01 field (ACTIVE INGREDIENTS) having both ACETAMINOPHEN and ALCOHOL I'll put some comments in the screen log below (marked with ***), then finish up at the end. ;================================== GTM>d ^DIS OUTPUT FROM WHAT FILE: VA PRODUCT//   -A- SEARCH FOR VA PRODUCT FIELD: active INGREDIENTS     (multiple)     -A- SEARCH FOR VA PRODUCT ACTIVE INGREDIENTS SUB-FIELD: active INGREDIENTS     -A- CONDITION: [  CONTAINS     -A- CONTAINS: acetaminophen     -B- SEARCH FOR VA PRODUCT ACTIVE INGREDIENTS SUB-FIELD:   -B- SEARCH FOR VA PRODUCT FIELD: IF: A//               VA PRODUCT ACTIVE INGREDIENTS CONTAINS (case-insensitive) "ACETAMI NOPHEN" DO YOU WANT THIS SEARCH SPECIFICATION TO BE CONSIDERED TRUE FOR CONDITION -A-         1) WHEN AT LEAST ONE OF THE 'ACTIVE INGREDIENTS' MULTIPLES SATISFIES IT         2) WHEN ALL OF THE 'ACTIVE INGREDIENTS' MULTIPLES SATISFY IT     CHOOSE 1-2: 1// STORE RESULTS OF SEARCH IN TEMPLATE: SORT BY: NAME// START WITH NAME: FIRST// FIRST PRINT FIELD: .01  NAME THEN PRINT FIELD: active INGREDIENTS    (multiple)   THEN PRINT ACTIVE INGREDIENTS SUB-FIELD: active INGREDIENTS   THEN PRINT ACTIVE INGREDIENTS SUB-FIELD: Heading (S/C): VA PRODUCT SEARCH// DEVICE:   TELNET VA PRODUCT SEARCH                              JAN  5,2006  14:47    PAGE 1 NAME     ACTIVE INGREDIENTS -------------------------------------------------------------------------------- ACETAMINOPHEN 100MG/ML (SF) DROPS,ORAL     ACETAMINOPHEN ACETAMINOPHEN 100MG/ML DROPS,ORAL     ACETAMINOPHEN ACETAMINOPHEN 120MG SUPP,RTL     ACETAMINOPHEN ACETAMINOPHEN 120MG/5ML ELIXIR     ACETAMINOPHEN ACETAMINOPHEN 125MG SUPP,RTL     ACETAMINOPHEN ACETAMINOPHEN 130MG/5ML SOLN,ORAL     ALCOHOL    <----------------- *** NOTE this entry contains ALCOHOL and ACETAMINOPHEN     ACETAMINOPHEN ACETAMINOPHEN 160MG SPRINKLE CAP     ACETAMINOPHEN **** NOTICE that there are matches when searching for ACETAMINOPHEN, and even one that also contains ALCOHOL GTM>d ^DIS OUTPUT FROM WHAT FILE: VA PRODUCT//   -A- SEARCH FOR VA PRODUCT FIELD: ACTIVE INGREDIENTS     (multiple)     -A- SEARCH FOR VA PRODUCT ACTIVE INGREDIENTS SUB-FIELD: ACTIVE INGREDIENTS     -A- CONDITION: [  CONTAINS     -A- CONTAINS: ALCOHOL     -B- SEARCH FOR VA PRODUCT ACTIVE INGREDIENTS SUB-FIELD:   -B- SEARCH FOR VA PRODUCT FIELD: IF: A//               VA PRODUCT ACTIVE INGREDIENTS CONTAINS (case-insensitive) "ALCOHOL " DO YOU WANT THIS SEARCH SPECIFICATION TO BE CONSIDERED TRUE FOR CONDITION -A-         1) WHEN AT LEAST ONE OF THE 'ACTIVE INGREDIENTS' MULTIPLES SATISFIES IT         2) WHEN ALL OF THE 'ACTIVE INGREDIENTS' MULTIPLES SATISFY IT     CHOOSE 1-2: 1// 1 STORE RESULTS OF SEARCH IN TEMPLATE: SORT BY: NAME// START WITH NAME: FIRST// FIRST PRINT FIELD: .01  NAME THEN PRINT FIELD: ACTIVE INGREDIENTS    (multiple)   THEN PRINT ACTIVE INGREDIENTS SUB-FIELD: ACTIVE INGREDIENTS   THEN PRINT ACTIVE INGREDIENTS SUB-FIELD: VA PRODUCT SEARCH                              JAN  5,2006  14:28    PAGE 30 NAME     ACTIVE INGREDIENTS -------------------------------------------------------------------------------- BENZOCAINE 2.5%/CETALKONIUM CL 0.02% LOTION     ALCOHOL     BENZOCAINE     CETALKONIUM CHLORIDE BENZOCAINE 6.3%/PHENOL 0.5% GEL,ORAL     PHENOL     ALCOHOL     BENZOCAINE BENZOCAINE 6.3%/PHENOL 0.5% SOLN,DENT     PHENOL     ALCOHOL     BENZOCAINE     POVIDONE IODINE BENZOCAINE 6.3%/PHENOL 0.5% SOLN,DENT     PHENOL     ALCOHOL     BENZOCAINE ^                          91 MATCHES FOUND. *** NOTICE that there are entries when searching for ALCOHOL GTM>d ^DIS OUTPUT FROM WHAT FILE: VA PRODUCT//   -A- SEARCH FOR VA PRODUCT FIELD: active INGREDIENTS     (multiple)     -A- SEARCH FOR VA PRODUCT ACTIVE INGREDIENTS SUB-FIELD: active INGREDIENTS     -A- CONDITION: [  CONTAINS     -A- CONTAINS: alcohol     -B- SEARCH FOR VA PRODUCT ACTIVE INGREDIENTS SUB-FIELD: active INGREDIENTS     -B- CONDITION: [  CONTAINS     -B- CONTAINS: acetaminophen     -C- SEARCH FOR VA PRODUCT ACTIVE INGREDIENTS SUB-FIELD:   -C- SEARCH FOR VA PRODUCT FIELD: IF: A&B         CONDITION -B- WILL APPLY TO THE SAME MULTIPLE AS CONDITION -A-         ...OK? Yes//   (Yes)     VA PRODUCT ACTIVE INGREDIENTS CONTAINS (case-insensitive) "ALCOHOL"                 together with VA PRODUCT ACTIVE INGREDIENTS CONTAINS (case-insen sitive) "ACETAMINOPHEN" DO YOU WANT THIS SEARCH SPECIFICATION TO BE CONSIDERED TRUE FOR CONDITION -A-         1) WHEN AT LEAST ONE OF THE 'ACTIVE INGREDIENTS' MULTIPLES SATISFIES IT         2) WHEN ALL OF THE 'ACTIVE INGREDIENTS' MULTIPLES SATISFY IT     CHOOSE 1-2: 1// OR: STORE RESULTS OF SEARCH IN TEMPLATE: SORT BY: NAME// START WITH NAME: FIRST// FIRST PRINT FIELD: .01  NAME THEN PRINT FIELD: active INGREDIENTS    (multiple)   THEN PRINT ACTIVE INGREDIENTS SUB-FIELD: active INGREDIENTS   THEN PRINT ACTIVE INGREDIENTS SUB-FIELD: THEN PRINT FIELD: Heading (S/C): VA PRODUCT SEARCH// DEVICE:   TELNET VA PRODUCT SEARCH                              JAN  5,2006  14:21    PAGE 1 NAME     ACTIVE INGREDIENTS --------------------------------------------------------------------------------                          0 MATCHES FOUND. ;======================================== But notice that when trying to combine these two searches, then there are no matches. Am I doing something wrong?  Or is it not designed to do such a search?  Or is it just not working? Kevin