IFindProjectsWithLastDoByActivity Method |
Returns list of Projects with matching appointment/document counters. Search by date.
Namespace:
SuperOffice.COM.SuperOfficeDB
Assembly:
SuperOfficeDB.Interop (in SuperOfficeDB.Interop.dll) Version: 8.0.0.0
SyntaxSOProjects ProjectsWithLastDoByActivity(
EnAppointType Type,
IListTextItem intent,
EnDirection direction,
EnFindOperator op,
DateTime Value
)
Function ProjectsWithLastDoByActivity (
Type As EnAppointType,
intent As IListTextItem,
direction As EnDirection,
op As EnFindOperator,
Value As DateTime
) As SOProjects
Dim instance As IFind
Dim Type As EnAppointType
Dim intent As IListTextItem
Dim direction As EnDirection
Dim op As EnFindOperator
Dim Value As DateTime
Dim returnValue As SOProjects
returnValue = instance.ProjectsWithLastDoByActivity(Type,
intent, direction, op, Value)
SOProjects^ ProjectsWithLastDoByActivity(
[InAttribute] EnAppointType Type,
[InAttribute] IListTextItem^ intent,
[InAttribute] EnDirection direction,
[InAttribute] EnFindOperator op,
[InAttribute] DateTime Value
)
Parameters
- Type
- Type: SuperOffice.COM.SuperOfficeDBEnAppointType
- intent
- Type: SuperOffice.COM.SuperOfficeDBIListTextItem
The intention of the activities, NULL equals all intentions - direction
- Type: SuperOffice.COM.SuperOfficeDBEnDirection
- op
- Type: SuperOffice.COM.SuperOfficeDBEnFindOperator
- Value
- Type: SystemDateTime
Date to use in comparison with the operator
Return Value
Type:
SOProjectsSOProjects - a collection of projects matching the query
ExamplesDim objSO
Dim myProjs
Dim myProj
enAppointAllCounters = 10
enDirectionAllCounters = 3
enFindOpMoreThanOrEqual = 5
Set objSO = CreateObject("SuperOfficeDB.Database")
If not (objSO is nothing) Then
objSO.login "USERID", "PASSWORD"
Set myProjs = objSO.Find.ProjectsWithLastDoByActivity(enAppointAllCounters, Nothing, enDirectionAllCounters, enFindOpMoreThanOrEqual, #1/1/2007#)
Set myProj = myProjs.GetFirst
While Not myProjs.EOF
msg = msg & myProj.Name & vbCrLf
Set myProj = myProjs.GetNext
Wend
If msg <> "" Then
MsgBox msg, vbInformation & vbOKOnly, "Projects matching search"
Else
MsgBox "No match"
End If
Else
MsgBox "Could not log in"
End If
Set objSO = Nothing
See Also