Table 20. Service Handheld Filters
|
|
|
Account |
Def_*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 |
Def_Today's Activities |
'Action'.Search = "[Planned] = Today() OR ([Planned] = """" AND [Created] = Today() AND [Created By] = LoginId())" "'Action'.Sort = "Planned"" |
Contact |
Def_*No Contacts |
'Contact'.Search = [Id] IS NULL"" |
SHCE Asset Management |
Def_*No Assets |
'FS Asset Measurement Characteristics'.Search = [Id] IS NULL"" |
Service Request |
Def_*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 |
Def_Today's Activities |
'Action'.Search = "[Planned] = Today() OR ([Planned] = """" AND [Created] = Today() AND [Created By] = LoginId())" "'Action'.Sort = "Planned"" |
ActionSHCE |
Past Due and Today |
'Action'.Search = "[Planned] <= Today() OR ([Planned] = """" AND [Created] = Today() AND [Created By] = LoginId())" "'Action'.Sort = "Planned"" |
ActionSHCE |
Past Due till Tomorrow |
'Action'.Search = "[Planned] <= Today() + 1 OR ([Planned] = """" AND [Created] = Today() AND [Created By] = LoginId())" "'Action'.Sort = "Planned"" |
ActionSHCE |
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 |
All_All Accounts |
'Account'.Search = "" "'Account'.Sort = "Name, Location"" |
ActionSHCE |
All_All Activities |
'Action'.Search = "" "'Action'.Sort = "Planned"" |
Contact |
All_All Contacts |
'Contact'.Search = "" "'Contact'.Sort = "Last Name, First Name"" |