Click or drag to resize

IFind Interface

This object has lots of function for performing simple searches. If you need more complex queries then you should use the ADO connection instead of the Find object.

Namespace:  SuperOffice.COM.Application
Assembly:  SOCRM.Interop (in SOCRM.Interop.dll) Version: 8.0.0.0
Syntax
public interface IFind

The IFind type exposes the following members.

Methods
  NameDescription
Public methodAllMatches
find list of field values using another field as the key - poor mans SQL query Example: Find.Field("contact","contact_id","number1", "SUPER") returns an array with the contact ids where CODE = 'SUPER'
Public methodAppointments
Find collection of Appointments for a particular associate between two dates
Public methodContactsByEmail
find collection of Contacts using e-mail addresses
Public methodContactsByName
Find collection of Contacts. If name ends in % then a begins with search is done.
Public methodContactsByPhone
find collection of Contacts using phone numbers
Public methodContactsLike
Find collection of Contacts using soundex.
Public methodContactsWithActiveStatusMonitor
Returns list of contacts with matching status monitors. Search by status monitor name or the status monitor id.
Public methodContactsWithLastCompletedActivity
Returns list of contacts with matching appointment/document counters. Search by date.
Public methodContactsWithLastCompletedSale
Returns list of contacts with matching sale counters. Search by date.
Public methodContactsWithLastCreatedActivity
Returns list of contacts with matching appointment/document counters. Search by date.
Public methodContactsWithLastCreatedSale
Returns list of contacts with matching sale counters. Search by date.
Public methodContactsWithLastDoByActivity
Returns list of contacts with matching appointment/document counters. Search by date.
Public methodContactsWithNumActivitiesCreatedPeriod
Returns list of contacts with matching appointment/document counters. Search by total number of appointments/documents.
Public methodContactsWithNumActivitiesCreatedTotal
Returns list of contacts with matching appointment/document counters. Search by total number of appointments/documents.
Public methodContactsWithNumActivitiesNotCompletedPeriod
Returns list of contacts with matching appointment/document counters. Search by total number of appointments/documents.
Public methodContactsWithNumActivitiesNotCompletedTotal
Returns list of contacts with matching appointment/document counters. Search by total number of appointments/documents.
Public methodContactsWithNumSalesCreatedPeriod
Returns list of contacts with matching sale counters. Search by total number of sales.
Public methodContactsWithNumSalesCreatedTotal
Returns list of contacts with matching sale counters. Search by total number of sales.
Public methodContactsWithNumSalesNotCompletedPeriod
Returns list of contacts with matching sale counters. Search by total number of sales.
Public methodContactsWithNumSalesNotCompletedTotal
Returns list of contacts with matching sale counters. Search by total number of sales.
Public methodFirstMatch
find list of field values using another field as the key - poor mans SQL query Example: Find.Field("contact","contact_id","number1", "SUPER") returns the first contact where CODE = 'SUPER'
Public methodIdFromForeignKey
get record id based on foreignkeyvalue - returns 0 if no record is found
Public methodIdsFromForeignKey
get record ids based on foreignkeyvalue - returns an array with the record ids
Public methodPersonsByEmail
find collection of Persons using e-mail addresses
Public methodPersonsByName
find collection of Persons by first and/or last name
Public methodPersonsByPhone
find collection of Persons using phone numbers
Public methodProjectsByName
Find collection of Projects using names. If name ends in % then a begins with search is done.
Public methodProjectsLike
Find collection of Projects using soundex.
Public methodProjectsWithActiveStatusMonitor
Returns list of Projects with matching status monitors. Search by status monitor name or the status monitor id.
Public methodProjectsWithLastCompletedActivity
Returns list of Projects with matching appointment/document counters. Search by date.
Public methodProjectsWithLastCompletedSale
Returns list of Projects with matching sale counters. Search by date.
Public methodProjectsWithLastCreatedActivity
Returns list of Projects with matching appointment/document counters. Search by date.
Public methodProjectsWithLastCreatedSale
Returns list of Projects with matching sale counters. Search by date.
Public methodProjectsWithLastDoByActivity
Returns list of Projects with matching appointment/document counters. Search by date.
Public methodProjectsWithNumActivitiesCreatedPeriod
Returns list of Projects with matching appointment/document counters. Search by toal number of appointments/documents.
Public methodProjectsWithNumActivitiesCreatedTotal
Returns list of Projects with matching appointment/document counters. Search by toal number of appointments/documents.
Public methodProjectsWithNumActivitiesNotCompletedPeriod
Returns list of Projects with matching appointment/document counters. Search by toal number of appointments/documents.
Public methodProjectsWithNumActivitiesNotCompletedTotal
Returns list of Projects with matching appointment/document counters. Search by toal number of appointments/documents.
Public methodProjectsWithNumSalesCreatedPeriod
Returns list of Projects with matching sale counters. Search by total number of sales.
Public methodProjectsWithNumSalesCreatedTotal
Returns list of Projects with matching sale counters. Search by total number of sales.
Public methodProjectsWithNumSalesNotCompletedPeriod
Returns list of Projects with matching sale counters. Search by total number of sales.
Public methodProjectsWithNumSalesNotCompletedTotal
Returns list of Projects with matching sale counters. Search by total number of sales.
Public methodSoundex
Returns the soundex form of the name
Top
See Also