Click or drag to resize

SOFind Interface

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.SuperOfficeDB
Assembly:  SuperOfficeDB.Interop (in SuperOfficeDB.Interop.dll) Version: 8.0.0.0
Syntax
public interface SOFind : IFind

The SOFind type exposes the following members.

Methods
  NameDescription
Public methodCode exampleAllMatches
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' Perform a "poor mans" SQL query to find list of field values using another field as the key.
(Inherited from IFind.)
Public methodCode exampleAppointments
Find collection of Appointments for a particular associate between two dates Get a collection of Appointments for a given associate within a specified range of dates
(Inherited from IFind.)
Public methodCode exampleContactsByEmail
find collection of Contacts using e-mail addresses Search and retrieve contacts by their email address. This will return all contacts that have an email address like the email given as search string. Does not accept partial address, but wildcards does work
(Inherited from IFind.)
Public methodCode exampleContactsByName
Find collection of Contacts. If name ends in % then a begins with search is done. Search and retrieve contacts by their name. This will return all contacts that start with the name given as search name
(Inherited from IFind.)
Public methodCode exampleContactsByPhone
find collection of Contacts using phone numbers Search and retrieve contacts by their phone number
(Inherited from IFind.)
Public methodCode exampleContactsLike
Find collection of Contacts using soundex. Search and retrieve contacts by their name. Name is stripped to a Soundex version, and then searched for
(Inherited from IFind.)
Public methodCode exampleContactsWithActiveStatusMonitor
Returns list of contacts with matching status monitors. Search by status monitor name or the status monitor id.
(Inherited from IFind.)
Public methodCode exampleContactsWithLastCompletedActivity
Returns list of contacts with matching appointment/document counters. Search by date.
(Inherited from IFind.)
Public methodCode exampleContactsWithLastCompletedSale
Returns list of contacts with matching sale counters. Search by date.
(Inherited from IFind.)
Public methodCode exampleContactsWithLastCreatedActivity
Returns list of contacts with matching appointment/document counters. Search by date.
(Inherited from IFind.)
Public methodCode exampleContactsWithLastCreatedSale
Returns list of contacts with matching sale counters. Search by date.
(Inherited from IFind.)
Public methodCode exampleContactsWithLastDoByActivity
Returns list of contacts with matching appointment/document counters. Search by date.
(Inherited from IFind.)
Public methodCode exampleContactsWithNumActivitiesCreatedPeriod
Returns list of contacts with matching appointment/document counters. Search by total number of appointments/documents.
(Inherited from IFind.)
Public methodContactsWithNumActivitiesCreatedTotal
Returns list of contacts with matching appointment/document counters. Search by total number of appointments/documents.
(Inherited from IFind.)
Public methodCode exampleContactsWithNumActivitiesNotCompletedPeriod
Returns list of contacts with matching appointment/document counters. Search by total number of appointments/documents.
(Inherited from IFind.)
Public methodCode exampleContactsWithNumActivitiesNotCompletedTotal
Returns list of contacts with matching appointment/document counters. Search by total number of appointments/documents.
(Inherited from IFind.)
Public methodCode exampleContactsWithNumSalesCreatedPeriod
Returns list of contacts with matching sale counters. Search by total number of sales.
(Inherited from IFind.)
Public methodCode exampleContactsWithNumSalesCreatedTotal
Returns list of contacts with matching sale counters. Search by total number of sales.
(Inherited from IFind.)
Public methodCode exampleContactsWithNumSalesNotCompletedPeriod
Returns list of contacts with matching sale counters. Search by total number of sales.
(Inherited from IFind.)
Public methodCode exampleContactsWithNumSalesNotCompletedTotal
Returns list of contacts with matching sale counters. Search by total number of sales.
(Inherited from IFind.)
Public methodCode exampleFirstMatch
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' Perform a "poor mans" SQL query to find list of field values using another field as the key.
(Inherited from IFind.)
Public methodCode exampleIdFromForeignKey
get record id based on foreignkeyvalue - returns 0 if no record is found Get the record id based on foreign key value - returns 0 if no record is found
(Inherited from IFind.)
Public methodCode exampleIdsFromForeignKey
get record ids based on foreignkeyvalue - returns an array with the record ids
(Inherited from IFind.)
Public methodCode examplePersonsByEmail
find collection of Persons using e-mail addresses Search and retrieve persons by their email address. This will return all persons that have an email address like the email given as search string. Does not accept partial address, but wildcards does work
(Inherited from IFind.)
Public methodCode examplePersonsByName
find collection of Persons by first and/or last name Search and retrieve persons by their name
(Inherited from IFind.)
Public methodCode examplePersonsByPhone
find collection of Persons using phone numbers Search and retrieve persons by their phone number
(Inherited from IFind.)
Public methodCode exampleProjectsByName
Find collection of Projects using names. If name ends in % then a begins with search is done. Search and retrieve a collection of projects based on project name (starts with)
(Inherited from IFind.)
Public methodCode exampleProjectsLike
Find collection of Projects using soundex. Search and retrieve all projects that soundex-match the given name
(Inherited from IFind.)
Public methodCode exampleProjectsWithActiveStatusMonitor
Returns list of Projects with matching status monitors. Search by status monitor name or the status monitor id.
(Inherited from IFind.)
Public methodCode exampleProjectsWithLastCompletedActivity
Returns list of Projects with matching appointment/document counters. Search by date.
(Inherited from IFind.)
Public methodCode exampleProjectsWithLastCompletedSale
Returns list of Projects with matching sale counters. Search by date.
(Inherited from IFind.)
Public methodCode exampleProjectsWithLastCreatedActivity
Returns list of Projects with matching appointment/document counters. Search by date.
(Inherited from IFind.)
Public methodCode exampleProjectsWithLastCreatedSale
Returns list of Projects with matching sale counters. Search by date.
(Inherited from IFind.)
Public methodCode exampleProjectsWithLastDoByActivity
Returns list of Projects with matching appointment/document counters. Search by date.
(Inherited from IFind.)
Public methodCode exampleProjectsWithNumActivitiesCreatedPeriod
Returns list of Projects with matching appointment/document counters. Search by toal number of appointments/documents.
(Inherited from IFind.)
Public methodCode exampleProjectsWithNumActivitiesCreatedTotal
Returns list of Projects with matching appointment/document counters. Search by toal number of appointments/documents.
(Inherited from IFind.)
Public methodCode exampleProjectsWithNumActivitiesNotCompletedPeriod
Returns list of Projects with matching appointment/document counters. Search by toal number of appointments/documents.
(Inherited from IFind.)
Public methodCode exampleProjectsWithNumActivitiesNotCompletedTotal
Returns list of Projects with matching appointment/document counters. Search by toal number of appointments/documents.
(Inherited from IFind.)
Public methodCode exampleProjectsWithNumSalesCreatedPeriod
Returns list of Projects with matching sale counters. Search by total number of sales.
(Inherited from IFind.)
Public methodCode exampleProjectsWithNumSalesCreatedTotal
Returns list of Projects with matching sale counters. Search by total number of sales.
(Inherited from IFind.)
Public methodCode exampleProjectsWithNumSalesNotCompletedPeriod
Returns list of Projects with matching sale counters. Search by total number of sales.
(Inherited from IFind.)
Public methodCode exampleProjectsWithNumSalesNotCompletedTotal
Returns list of Projects with matching sale counters. Search by total number of sales.
(Inherited from IFind.)
Public methodCode exampleSoundex
Returns the soundex form of the name

Return the soundex version of the Name string.

Note that the soundex algorithm has changed between CRM 5 and SIX. The upgrade process updates all the soundex fields with new values.

(Inherited from IFind.)
Top
See Also