Table 9. Service Handheld Filters
Business Object
|
PDA Name
|
Query
|
Account
|
PDADef_*No Accounts
|
'Account'.Search = "[Id] IS NULL" 'Asset Mgmt - Asset'.Search = "[Id] IS NULL" 'FS Asset Warranty'.Search = "[Id] IS NULL" "'Entitlement Account'.Search = "[Id] IS NULL""
|
ActionSHCE
|
PDADef_Today's Activities
|
'Action'.Search = "[Planned] = Today() OR ([Planned] = """" AND [Created] = Today() AND [Created By] = LoginId())" "'Action'.Sort = "Planned""
|
Contact
|
PDADef_*No Contacts
|
'Contact'.Search = [Id] IS NULL""
|
SHCE Asset Management
|
PDADef_*No Assets
|
'FS Asset Measurement Characteristics'.Search = [Id] IS NULL""
|
Service Request
|
PDADef_*No Service Requests
|
'Service Request'.Search = "[Id] IS NULL" 'FS Invoice'.Search = "[Id] IS NULL" 'FS Invoice Line Items'.Search = "[Id] IS NULL" "'Order Entry - Line Items'.Search = "[Id] IS NULL""
|
ActionSHCE
|
PDADef_Today's Activities
|
'Action'.Search = "[Planned] = Today() OR ([Planned] = """" AND [Created] = Today() AND [Created By] = LoginId())" "'Action'.Sort = "Planned""
|
ActionSHCE
|
PDA_Past Due and Today
|
'Action'.Search = "[Planned] <= Today() OR ([Planned] = """" AND [Created] = Today() AND [Created By] = LoginId())" "'Action'.Sort = "Planned""
|
ActionSHCE
|
PDA_Past Due till Tomorrow
|
'Action'.Search = "[Planned] <= Today() + 1 OR ([Planned] = """" AND [Created] = Today() AND [Created By] = LoginId())" "'Action'.Sort = "Planned""
|
ActionSHCE
|
PDA_Today Due and Tomorrow
|
'Action'.Search = "[Planned] = Today() OR [Planned] = Today()+1 OR ([Planned] = """" AND [Created] = Today() AND [Created By] = LoginId())" "'Action'.Sort = "Planned""
|
Account
|
PDAAll_All Accounts
|
'Account'.Search = "" "'Account'.Sort = "Name, Location""
|
ActionSHCE
|
PDAAll_All Activities
|
'Action'.Search = "" "'Action'.Sort = "Planned""
|
Contact
|
PDAAll_All Contacts
|
'Contact'.Search = "" "'Contact'.Sort = "Last Name, First Name""
|