networkserv.jpg (38409 bytes)

Filter Recordset

JobNumber
JobStatus
JobType
RequestDate
ScheduledDate
CompletionDate
SuperBillingName
Building
Room
JobDescription

Text Comparison:Contains  Starts With   Exactly   
Connect all fields using:AND  OR

Instructions

Simple Entry Method (Enter the Value to be found):
Examples:  O'Neal    O'Neal OR Jones    19.95    5/31/99    Aluminum AND Engine


Error: Invalid dbFilterFlds field(s) - [style=simple]

Or

Advanced Entry Method (Enter the Comparison to be used):
Examples:  >10    ='Barnes and Noble'   (>= 1 AND <99)     BETWEEN #1/1/99# AND #12/31/99#
Available comparison operators:  >   <   >=   <=   =   !=   (or any valid SQL syntax)

The following data is the associated Line number(s) and IP addresse(s) for the displayed job.
There may not be any records associated with the job.

Error: No record found
SELECT COUNT(1) FROM Unumber,ActivityType A,ConnectionType C WHERE A.activitytypecode = Unumber.activitytypecode and C.connectiontypecode = Unumber.connectiontypecode and Unumber.Jobnumber ='1108'

 


 


©1998 MSCNS Washington University Medical School
For Questions or Comments Email web@msnotes.wustl.edu