Robert, there seems to be something missing from your results below. Here is a URL to list the 3 records where the Name begins with "ACETAMINOPHEN" and the ACTIVE INGREDIENTS multiple (ActvIngr) contains "ALCOHOL"
http://vista.vmth.ucdavis.edu/query?dbfile=50.68&index=Name&filter=ActvIngr%5B%22ALCOHOL%22&find=ACETAMINOPHEN&format=INGREDIENTS The decoded query parameters are: dbfile=50.68 - the file number (or name) index=Name - an iteration specifier (in this case the name of one) filter=ActvIngr["ALCOHOL" - a MUMPS logical condition list find=ACETAMINOPHEN - a search pattern to be applied to the index format=INGREDIENTS - a named format (this one includes the ActvIngr multiple) Here is another URL to list the 7 records where ActvIngr["ALCOHOL" and ActvIngr["ACETAMINOPHEN" http://vista.vmth.ucdavis.edu/query?dbfile=50.68&index=Name&filter=ActvIngr%5B%22ALCOHOL%22%2CActvIngr%5B%22ACETAMINOPHEN%22&format=INGREDIENTS The decoded query parameters are: dbfile=50.68 index=Name filter=ActvIngr["ALCOHOL",ActvIngr["ACETAMINOPHEN" format=INGREDIENTS Notice that ACETAMINOPHEN 130MG/5ML SOLN,ORAL is included in both lists. Also notice that this is a different way of searching subfiles than I have mentioned before. Robert DeWayne wrote: >Kevin I think the solution is easier than you think, do an inquiry on >the product that you think has both ingredients and you'll see, it >contains no alcohol. Not sure why FileMan is showing it the way it >does. > >NAME: ACETAMINOPHEN 130MG/5ML SOLN,ORAL > VA GENERIC NAME: ACETAMINOPHEN DOSAGE FORM: SOLN,ORAL > STRENGTH: 130 UNITS: MG/5ML > NATIONAL FORMULARY NAME: ACETAMINOPHEN SOLN,ORAL > VA PRINT NAME: ACETAMINOPHEN 130MG/5ML SOLN > VA PRODUCT IDENTIFIER: A0009 TRANSMIT TO CMOP: YES > VA DISPENSE UNIT: ML >ACTIVE INGREDIENTS: ACETAMINOPHEN STRENGTH: 130 > UNITS: MG/5ML --------------------------------------- Jim Self Systems Architect, Lead Developer VMTH Computer Services, UC Davis (http://www.vmth.ucdavis.edu/us/jaself) ------------------------------------------------------- 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
