Announcement

Collapse
No announcement yet.

Listing of Overdue Queries

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Listing of Overdue Queries

    Hi Beth,

    Use the Queries Patient View in the Listing module and construct a where clause similar to the following:

    date() - datepart(issueddate) > 30 and status='O'

    We also will look into a report, which will make obtaining this easier.

    Regards,
    Greg Wagner-


    -----Original Message-----
    From: Beth Oakland
    Sent: Friday, April 13, 2007 3:23 PM
    To: Support
    Subject: ClinPlus Question

    Hi,

    If we want to know which queries have been out for more than 30 days, what would we put in the SAS Where Field?

    Thanks.
    Beth Oakland
    Data Manager
Working...
X