Frequently Asked Questions (FAQs)
Search Issues
"Problem": When performing a search on a field that is a pointer to another file, the search seems to fail. For example:
OUTPUT FROM WHAT FILE: TIU DOCUMENT//
-A- SEARCH FOR TIU DOCUMENT FIELD: author OF NOTE AUTHOR/DICTATOR -A- CONDITION: = EQUALS -A- EQUALS NEW PERSON: ptt THWING,PHILIP T ptt PHYSICIAN
-B- SEARCH FOR TIU DOCUMENT FIELD: enterED BY -B- CONDITION: = EQUALS -B- EQUALS NEW PERSON: kst TOPPENBERG,KEVIN S kst PHYSICIAN
-C- SEARCH FOR TIU DOCUMENT FIELD:
IF: A&B AUTHOR/DICTATOR EQUALS 74 (THWING,PHILIP T)
and ENTERED BY EQUALS 73
(TOPPENBERG,KEVIN S) OR:
STORE RESULTS OF SEARCH IN TEMPLATE: [TMG SET
(Mar 20, 2005@00:07)
User #73 File #8925 SEARCH
DATA ALREADY STORED THERE....OK TO PURGE? NO// y YES
DESCRIPTION:
This can be used to store sets of records, for working
with multiple
records etc.
Edit? NO//
SORT BY: NUMBER// START WITH NUMBER: FIRST// FIRST PRINT FIELD: .01 DOCUMENT TYPE THEN PRINT FIELD: Heading (S/C): TIU DOCUMENT SEARCH// DEVICE: TELNET TIU DOCUMENT SEARCH MAR 20,2005 00:09 PAGE 1 DOCUMENT TYPE
0 MATCHES FOUND.
Press RETURN to continue...
And here is one (of about 1000+ documents that it
should have found.)
NUMBER: 4299 DOCUMENT TYPE:
OFFICE VISIT
PATIENT: xxxxxxxxxx,xxxxx x STATUS:
COMPLETED
EPISODE BEGIN DATE/TIME: NOV 05, 2004 EPISODE END DATE/TIME: NOV 05, 2004 LINE COUNT: 18 ENTRY DATE/TIME: FEB 07, 2005@21:03:39 AUTHOR/DICTATOR: THWING,PHILIP T EXPECTED
SIGNER: THWING,PHILIP T
HOSPITAL LOCATION: Main_Office ATTENDING
PHYSICIAN: THWING,PHILIP T
VISIT LOCATION: Main_Office REFERENCE
DATE: NOV 05, 2004
ENTERED BY: kst CAPTURE
METHOD: upload
SERVICE: FAMILY PRACTICE SIGNED BY:
THWING,PHILIP T
REPORT TEXT: xxx
This has something to do with initials being an output transform. If
you use INTERNAL(ENTERED BY), EQUALS, 73 it should work.
Lloyd
The problem arises when there is a pointer field that has an Output transform on it. Try this to fix the problem of searching on such a field: In the DIS1 routine, add eight characters:
OUTX .I $D(^(2)),$P(^(0),U,2)'["D",DV'["=" ......
Yours,
George Timson