Sorry, I wasn't clear enough in my example, the logic seems a little hard to
follow at times, so here is a better/clearer example:
Select OPTION: SEARCH FILE ENTRIES
OUTPUT FROM WHAT FILE: VA PRODUCT// VA PRODUCT (17045 entries)
-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: MENTHO
1 MENTHOL
2 MENTHOL/PHENOL
CHOOSE 1-2: 1 MENTHOL
-B- SEARCH FOR VA PRODUCT ACTIVE INGREDIENTS SUB-FIELD: ACTIVE INGREDIENT
S
-B- CONDITION: EQUALS
-B- EQUALS DRUG INGREDIENTS: ACETONE
1 ACETONE
2 ACETONE SODIUM BISULFITE
CHOOSE 1-2: 1 ACETONE
-C- SEARCH FOR VA PRODUCT ACTIVE INGREDIENTS SUB-FIELD:
-C- SEARCH FOR VA PRODUCT FIELD:
IF: AB
CONDITION -B- WILL APPLY TO THE SAME MULTIPLE AS CONDITION -A-
...OK? Yes// N (No)
VA PRODUCT ACTIVE INGREDIENTS EQUALS 1471 (MENTHOL)
and VA PRODUCT ACTIVE INGREDIENTS EQUALS 1629 (ACETONE)
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
DO YOU WANT THIS SEARCH SPECIFICATION TO BE CONSIDERED TRUE FOR CONDITION -B-
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
OR:
STORE RESULTS OF SEARCH IN TEMPLATE:
SORT BY: NAME//
START WITH NAME: FIRST//
FIRST PRINT FIELD: NAME
THEN PRINT FIELD: ACTIVE INGREDIENTS (multiple)
THEN PRINT ACTIVE INGREDIENTS SUB-FIELD: .01 ACTIVE INGREDIENTS
THEN PRINT ACTIVE INGREDIENTS SUB-FIELD:
THEN PRINT FIELD:
Heading (S/C): VA PRODUCT SEARCH//
DEVICE: HOME// TELNET
VA PRODUCT SEARCH JAN 6,2006 09:19 PAGE 1
NAME
ACTIVE INGREDIENTS
--------------------------------------------------------------------------------
ABSORBINE JR LINIMENT
BENZETHONIUM CHLORIDE
MENTHOL
CHLOROXYLENOL
ACETONE
THYMOL
ZINC STEARATE
EXTRA STRENGTH ABSORBINE JR LINIMENT
POTASSIUM IODIDE
IODINE
MENTHOL
CHLOROXYLENOL
ACETONE
THYMOL
Robert DeWayne
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert DeWayne
Sent: Friday, January 06, 2006 9:20 AM
To: [email protected]
Subject: RE: [Hardhats-members] Fileman search broken?
The search feature is not broken, it works great.
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: CONTAINS
-A- CONTAINS: EPINEPHRINE
-B- SEARCH FOR VA PRODUCT ACTIVE INGREDIENTS SUB-FIELD: ACTIVE INGREDIENT
S
-B- CONDITION: CONTAINS
-B- CONTAINS: HYDROCHLORIDE
-C- SEARCH FOR VA PRODUCT ACTIVE INGREDIENTS SUB-FIELD:
-C- SEARCH FOR VA PRODUCT FIELD:
IF: AB
CONDITION -B- WILL APPLY TO THE SAME MULTIPLE AS CONDITION -A-
...OK? Yes// (Yes)
VA PRODUCT ACTIVE INGREDIENTS CONTAINS (case-insensitive) "EPINEPHRINE"
together with VA PRODUCT ACTIVE INGREDIENTS CONTAINS (case-insen
sitive) "HYDROCHLORIDE"
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// 2
OR:
STORE RESULTS OF SEARCH IN TEMPLATE:
SORT BY: NAME//
START WITH NAME: FIRST//
FIRST PRINT FIELD: NAME
THEN PRINT FIELD: ACTIVE INGREDIENTS (multiple)
THEN PRINT ACTIVE INGREDIENTS SUB-FIELD: .01 ACTIVE INGREDIENTS
THEN PRINT ACTIVE INGREDIENTS SUB-FIELD:
THEN PRINT FIELD:
Heading (S/C): VA PRODUCT SEARCH//
DEVICE: HOME// TELNET
VA PRODUCT SEARCH JAN 6,2006 08:53 PAGE 1
NAME
ACTIVE INGREDIENTS
--------------------------------------------------------------------------------
EPINEPHRINE 1MG/ML INJ
EPINEPHRINE HYDROCHLORIDE
EPINEPHRINE 1MG/ML INJ,SYRINGE,1ML
EPINEPHRINE HYDROCHLORIDE
EPINEPHRINE 1MG/ML INJ,TUBEX,1ML
EPINEPHRINE HYDROCHLORIDE
Robert DeWayne
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greg Woodhouse
Sent: Thursday, January 05, 2006 4:55 PM
To: [email protected]
Subject: RE: [Hardhats-members] Fileman search broken?
--- "Nevius, Gordon D." <[EMAIL PROTECTED]> wrote:
> 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".
>
I don't know if the technique I demonstrated (see my other post for a screen
capture) is an "undocumented feature" or not, but Fileman seems able to do a
self-join without requiring the user to explicitly create a sort template (not
that there's anything wrong with this approach), it just doesn't give any
indication that this capability is supported.
===
Gregory Woodhouse <[EMAIL PROTECTED]> "If you give someone Fortran, he has
Fortran.
If you give someone Lisp, he has any language he pleases."
--Guy L. Steele, Jr.
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes searching
your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Hardhats-members mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hardhats-members
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes searching
your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_idv37&alloc_id865&op=ick
_______________________________________________
Hardhats-members mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hardhats-members
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_idv37&alloc_id865&op=click
_______________________________________________
Hardhats-members mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hardhats-members
