--- Kevin Toppenberg <[EMAIL PROTECTED]> wrote:
> 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
Do it like this:
Select VA FileMan 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: .01 ACTIVE
INGREDIE
NTS
-A- CONDITION: [ CONTAINS
-A- CONTAINS: ACETAMINOPHEN
-B- SEARCH FOR VA PRODUCT ACTIVE INGREDIENTS SUB-FIELD:
-B- SEARCH FOR VA PRODUCT FIELD: ACTIVE INGREDIENTS (multiple)
-B- SEARCH FOR VA PRODUCT ACTIVE INGREDIENTS SUB-FIELD: .01 ACTIVE
INGREDIE
NTS
-B- CONDITION: [ CONTAINS
-B- CONTAINS: ALCOHOL
-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// NO (No)
VA PRODUCT ACTIVE INGREDIENTS CONTAINS (case-insensitive)
"ACETAMINOPHEN"
and 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//
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//
OR:
STORE RESULTS OF SEARCH IN TEMPLATE:
SORT BY: NAME//
START WITH NAME: FIRST//
FIRST PRINT FIELD: .01 NAME
THEN PRINT FIELD:
Heading (S/C): VA PRODUCT SEARCH//
DEVICE: INCOMING TELNET Right Margin: 80//
VA PRODUCT SEARCH JAN 5,2006 16:42
PAGE 1
NAME
--------------------------------------------------------------------------------
ACETAMINOPHEN 250MG/DEXTROMETHORPHAN 7.5MG/5ML LIQUID
ACETAMINOPHEN 500MG/DIPHENHYDRAMINE HCL 25MG/15ML LIQUID
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
CODEINE 12MG/ACETAMINOPHEN 120MG/5ML ELIXIR
6 MATCHES FOUND.
Press RETURN to continue...
===
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
