SOFind Methods |
The SOFind type exposes the following members.
Name | Description | |
---|---|---|
![]() ![]() | AllMatches | 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.) |
![]() ![]() | Appointments | 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.) |
![]() ![]() | ContactsByEmail | 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.) |
![]() ![]() | ContactsByName | 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.) |
![]() ![]() | ContactsByPhone | find collection of Contacts using phone numbers
Search and retrieve contacts by their phone number (Inherited from IFind.) |
![]() ![]() | ContactsLike | 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.) |
![]() ![]() | ContactsWithActiveStatusMonitor | Returns list of contacts with matching status monitors. Search by status monitor name or the status monitor id. (Inherited from IFind.) |
![]() ![]() | ContactsWithLastCompletedActivity | Returns list of contacts with matching appointment/document counters. Search by date. (Inherited from IFind.) |
![]() ![]() | ContactsWithLastCompletedSale | Returns list of contacts with matching sale counters. Search by date. (Inherited from IFind.) |
![]() ![]() | ContactsWithLastCreatedActivity | Returns list of contacts with matching appointment/document counters. Search by date. (Inherited from IFind.) |
![]() ![]() | ContactsWithLastCreatedSale | Returns list of contacts with matching sale counters. Search by date. (Inherited from IFind.) |
![]() ![]() | ContactsWithLastDoByActivity | Returns list of contacts with matching appointment/document counters. Search by date. (Inherited from IFind.) |
![]() ![]() | ContactsWithNumActivitiesCreatedPeriod | Returns list of contacts with matching appointment/document counters. Search by total number of appointments/documents. (Inherited from IFind.) |
![]() | ContactsWithNumActivitiesCreatedTotal | Returns list of contacts with matching appointment/document counters. Search by total number of appointments/documents. (Inherited from IFind.) |
![]() ![]() | ContactsWithNumActivitiesNotCompletedPeriod | Returns list of contacts with matching appointment/document counters. Search by total number of appointments/documents. (Inherited from IFind.) |
![]() ![]() | ContactsWithNumActivitiesNotCompletedTotal | Returns list of contacts with matching appointment/document counters. Search by total number of appointments/documents. (Inherited from IFind.) |
![]() ![]() | ContactsWithNumSalesCreatedPeriod | Returns list of contacts with matching sale counters. Search by total number of sales. (Inherited from IFind.) |
![]() ![]() | ContactsWithNumSalesCreatedTotal | Returns list of contacts with matching sale counters. Search by total number of sales. (Inherited from IFind.) |
![]() ![]() | ContactsWithNumSalesNotCompletedPeriod | Returns list of contacts with matching sale counters. Search by total number of sales. (Inherited from IFind.) |
![]() ![]() | ContactsWithNumSalesNotCompletedTotal | Returns list of contacts with matching sale counters. Search by total number of sales. (Inherited from IFind.) |
![]() ![]() | FirstMatch | 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.) |
![]() ![]() | IdFromForeignKey | 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.) |
![]() ![]() | IdsFromForeignKey | get record ids based on foreignkeyvalue - returns an array with the record ids (Inherited from IFind.) |
![]() ![]() | PersonsByEmail | 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.) |
![]() ![]() | PersonsByName | find collection of Persons by first and/or last name
Search and retrieve persons by their name (Inherited from IFind.) |
![]() ![]() | PersonsByPhone | find collection of Persons using phone numbers
Search and retrieve persons by their phone number (Inherited from IFind.) |
![]() ![]() | ProjectsByName | 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.) |
![]() ![]() | ProjectsLike | Find collection of Projects using soundex.
Search and retrieve all projects that soundex-match the given name (Inherited from IFind.) |
![]() ![]() | ProjectsWithActiveStatusMonitor | Returns list of Projects with matching status monitors. Search by status monitor name or the status monitor id. (Inherited from IFind.) |
![]() ![]() | ProjectsWithLastCompletedActivity | Returns list of Projects with matching appointment/document counters. Search by date. (Inherited from IFind.) |
![]() ![]() | ProjectsWithLastCompletedSale | Returns list of Projects with matching sale counters. Search by date. (Inherited from IFind.) |
![]() ![]() | ProjectsWithLastCreatedActivity | Returns list of Projects with matching appointment/document counters. Search by date. (Inherited from IFind.) |
![]() ![]() | ProjectsWithLastCreatedSale | Returns list of Projects with matching sale counters. Search by date. (Inherited from IFind.) |
![]() ![]() | ProjectsWithLastDoByActivity | Returns list of Projects with matching appointment/document counters. Search by date. (Inherited from IFind.) |
![]() ![]() | ProjectsWithNumActivitiesCreatedPeriod | Returns list of Projects with matching appointment/document counters. Search by toal number of appointments/documents. (Inherited from IFind.) |
![]() ![]() | ProjectsWithNumActivitiesCreatedTotal | Returns list of Projects with matching appointment/document counters. Search by toal number of appointments/documents. (Inherited from IFind.) |
![]() ![]() | ProjectsWithNumActivitiesNotCompletedPeriod | Returns list of Projects with matching appointment/document counters. Search by toal number of appointments/documents. (Inherited from IFind.) |
![]() ![]() | ProjectsWithNumActivitiesNotCompletedTotal | Returns list of Projects with matching appointment/document counters. Search by toal number of appointments/documents. (Inherited from IFind.) |
![]() ![]() | ProjectsWithNumSalesCreatedPeriod | Returns list of Projects with matching sale counters. Search by total number of sales. (Inherited from IFind.) |
![]() ![]() | ProjectsWithNumSalesCreatedTotal | Returns list of Projects with matching sale counters. Search by total number of sales. (Inherited from IFind.) |
![]() ![]() | ProjectsWithNumSalesNotCompletedPeriod | Returns list of Projects with matching sale counters. Search by total number of sales. (Inherited from IFind.) |
![]() ![]() | ProjectsWithNumSalesNotCompletedTotal | Returns list of Projects with matching sale counters. Search by total number of sales. (Inherited from IFind.) |
![]() ![]() | Soundex | Returns the soundex form of the name
(Inherited from IFind.)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. |