[Hardhats-members] Fileman search broken?

[Kevin Toppenberg]

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