Siebel ePharma Handheld Guide for Windows-Powered Devices > Data Filtering > Predefined Query Filters >

Configuring Default PDQs


The default PDQs that are included in Siebel ePharma Handheld are designed to be placeholders for the PDQs that your users will need. Table 13 shows the PDQs that must be created and set as the default PDQs.

Table 13.  Default PDQs for ePharma
Business Object
PDQ Name
PDQ Value
Account
PDADef_AccountSyncFilter
'Account'.Search = "[Account Status]=""Active"" AND [My Position Id] = PositionId()"
Action
PDADef_ActionSyncFilter
'Action'.Search = "([Due] >= Today() - 30) AND ([Due] <= Today() + 30)"
Contact
PDADef_ContactSyncFilter
'Contact'.Search = "[My Position Id] = PositionId () AND [Status]=""Active"""
Pharma Account Call - CE
PDADef_Last45DaysandPlannedAcctCalls
'Pharma Account Call - CE'.Search = "([Start Date] >= Today() - 30 AND [Start Date] <= Today() + 7) AND [Account Status] = ""Active"" AND EXISTS ([Owned By Id] = PositionId())"
Pharma Professional Call - CE
PDADef_Last45DaysandPlannedProfCalls
'Pharma Professional Call - CE'.Search = "([Start Date] >= Today() - 30 AND [Start Date] <= Today() + 30) AND [Contact Status] = ""Active"" AND EXISTS ([Owned By Id] = PositionId())"


 Siebel ePharma Handheld Guide for Windows-Powered Devices 
 Published: 18 July 2003