Class SoLists
Inherited Members
Namespace: SuperOffice.CRM.Lists
Assembly: SoDataBase.dll
Syntax
public static class SoListsMethods
GetAmountClassList()
MDO List for table AmountClass:
Declaration
public static ISoListProvider GetAmountClassList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetAmountClassList(Boolean)
MDO List for table AmountClass:
Declaration
public static ISoListProvider GetAmountClassList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetAmountClassList(Int32[])
MDO List for table AmountClass:
Declaration
public static ISoListProvider GetAmountClassList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetArchiveList(String, String, ArchiveRestrictionInfo)
MDO list based on an underlying Archive Provider.
Declaration
public static ISoListProvider GetArchiveList(string providerName, string commaSeparatedColumns, ArchiveRestrictionInfo singleRestriction)Parameters
| Type | Name | Description |
|---|---|---|
| String | providerName | Name of archive provider |
| String | commaSeparatedColumns | String containing a comma-separated list of columns, like 'name,department,hasInfoText' |
| ArchiveRestrictionInfo | singleRestriction | One restriction, to be passed to the archive provider |
Returns
| Type | Description |
|---|---|
| ISoListProvider | MDO list provider for the archive |
Remarks
Items will contain concatenated values of the desired columns in the order they are given. Rows will be ordered by the first possible column. If a column is of type icon in the archive provider, it will be used for the icon hint instead of being part of the item name. Tooltips from all non-icon columns are concatenated to be the tooltip for the item.
A maximum of
The extraInfo field of the list item will contain the entity name, a colon, and the actual primary key of the row. If the archive provider only has one entity, then the primary key will also be used for the list item id. If the archive has more than one entity, the primary key cannot be used for the list item id since primary keys may overlap between entities. In that case, the list item id will be an arbitrary integer.
Note that complex archives may apply further restrictions by themselves - Activity Archives will apply your current Filter settings,
etc. This will influence the result set. Also note that culture-dependent data, such as dates, are returned in the format
set up by
GetArchiveList(String, String, ArchiveRestrictionInfo, String)
MDO list based on an underlying Archive Provider and search value, which is applied to the first column.
Declaration
public static ISoListProvider GetArchiveList(string providerName, string commaSeparatedColumns, ArchiveRestrictionInfo singleRestriction, string searchValue)Parameters
| Type | Name | Description |
|---|---|---|
| String | providerName | Name of archive provider |
| String | commaSeparatedColumns | String containing a comma-separated list of columns, like 'name,department,hasInfoText'. The search value will be applied to the FIRST of these, using StartsWith(String) and ToLowerInvariant(). |
| ArchiveRestrictionInfo | singleRestriction | One restriction, to be passed to the archive provider |
| String | searchValue |
Returns
| Type | Description |
|---|---|
| ISoListProvider | MDO list provider for the archive |
Remarks
Items will contain concatenated values of the desired columns in the order they are given. Rows will be ordered by the first possible column. If a column is of type icon in the archive provider, it will be used for the icon hint instead of being part of the item name. Tooltips from all non-icon columns are concatenated to be the tooltip for the item.
A maximum of
The extraInfo field of the list item will contain the entity name, a colon, and the actual primary key of the row. If the archive provider only has one entity, then the primary key will also be used for the list item id. If the archive has more than one entity, the primary key cannot be used for the list item id since primary keys may overlap between entities. In that case, the list item id will be an arbitrary integer.
Note that complex archives may apply further restrictions by themselves - Activity Archives will apply your current Filter settings,
etc. This will influence the result set. Also note that culture-dependent data, such as dates, are returned in the format
set up by
GetArchiveList(String, String[], ArchiveRestrictionInfo[])
MDO list based on an underlying Archive Provider.
Declaration
public static ISoListProvider GetArchiveList(string providerName, string[] columns, ArchiveRestrictionInfo[] restrictions)Parameters
| Type | Name | Description |
|---|---|---|
| String | providerName | Name of archive provider |
| String[] | columns | Array of column names to fetch |
| ArchiveRestrictionInfo[] | restrictions | Array of restrictions to apply on the archive provider |
Returns
| Type | Description |
|---|---|
| ISoListProvider | MDO list provider for the archive |
Remarks
Items will contain concatenated values of the desired columns in the order they are given. Rows will be ordered by the first possible column. If a column is of type icon in the archive provider, it will be used for the icon hint instead of being part of the item name. Tooltips from all non-icon columns are concatenated to be the tooltip for the item.
A maximum of
The extraInfo field of the list item will contain the entity name, a colon, and the actual primary key of the row. If the archive provider only has one entity, then the primary key will also be used for the list item id. If the archive has more than one entity, the primary key cannot be used for the list item id since primary keys may overlap between entities. In that case, the list item id will be an arbitrary integer.
Note that complex archives may apply further restrictions by themselves - Activity Archives will apply your current Filter settings,
etc. This will influence the result set. Also note that culture-dependent data, such as dates, are returned in the format
set up by
GetArchiveList(String, String[], ArchiveRestrictionInfo[], String)
MDO list based on an underlying Archive Provider and search value, which is applied to the first column.
Declaration
public static ISoListProvider GetArchiveList(string providerName, string[] columns, ArchiveRestrictionInfo[] restrictions, string searchValue)Parameters
| Type | Name | Description |
|---|---|---|
| String | providerName | Name of archive provider |
| String[] | columns | Array of column names to fetch. The search value will be applied to the FIRST of these, using StartsWith(String) and ToLowerInvariant(). |
| ArchiveRestrictionInfo[] | restrictions | Array of restrictions to apply on the archive provider |
| String | searchValue |
Returns
| Type | Description |
|---|---|
| ISoListProvider | MDO list provider for the archive |
Remarks
Items will contain concatenated values of the desired columns in the order they are given. Rows will be ordered by the first possible column. If a column is of type icon in the archive provider, it will be used for the icon hint instead of being part of the item name. Tooltips from all non-icon columns are concatenated to be the tooltip for the item.
A maximum of
The extraInfo field of the list item will contain the entity name, a colon, and the actual primary key of the row. If the archive provider only has one entity, then the primary key will also be used for the list item id. If the archive has more than one entity, the primary key cannot be used for the list item id since primary keys may overlap between entities. In that case, the list item id will be an arbitrary integer.
Note that complex archives may apply further restrictions by themselves - Activity Archives will apply your current Filter settings,
etc. This will influence the result set. Also note that culture-dependent data, such as dates, are returned in the format
set up by
GetAssociateList()
MDO List for Associate: Associate records of type employee (type = 0)
Declaration
public static ISoListProvider GetAssociateList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetAssociateList(Boolean)
MDO List for Associate: Associate records of type employee (type = 0)
Declaration
public static ISoListProvider GetAssociateList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetAssociateList(Int32[])
MDO List for Associate: Associate records of type employee (type = 0)
Declaration
public static ISoListProvider GetAssociateList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetBusinessList()
MDO List for table Business:
List of valid business types
Declaration
public static ISoListProvider GetBusinessList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetCategoryList()
MDO List for table Category:
List of valid category types
Declaration
public static ISoListProvider GetCategoryList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetCategoryList(Boolean)
MDO List for table Category:
List of valid category types
Declaration
public static ISoListProvider GetCategoryList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetCategoryList(Int32[])
MDO List for table Category:
List of valid category types
Declaration
public static ISoListProvider GetCategoryList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetComptrList()
MDO List for table Comptr:
List of all possible competitors (sale).
Declaration
public static ISoListProvider GetComptrList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetComptrList(Boolean)
MDO List for table Comptr:
List of all possible competitors (sale).
Declaration
public static ISoListProvider GetComptrList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetComptrList(Int32[])
MDO List for table Comptr:
List of all possible competitors (sale).
Declaration
public static ISoListProvider GetComptrList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetContIntList()
MDO List for table ContInt:
List-text of all valid contact interest types.
Declaration
public static ISoListProvider GetContIntList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetContIntList(Boolean)
MDO List for table ContInt:
List-text of all valid contact interest types.
Declaration
public static ISoListProvider GetContIntList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetContIntList(Int32[])
MDO List for table ContInt:
List-text of all valid contact interest types.
Declaration
public static ISoListProvider GetContIntList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetCountryList()
MDO List for table Country:
Country list
Declaration
public static ISoListProvider GetCountryList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetCreditedList()
MDO List for table Credited:
List of who is to be credited for the sale.
Declaration
public static ISoListProvider GetCreditedList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetCreditedList(Boolean)
MDO List for table Credited:
List of who is to be credited for the sale.
Declaration
public static ISoListProvider GetCreditedList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetCreditedList(Int32[])
MDO List for table Credited:
List of who is to be credited for the sale.
Declaration
public static ISoListProvider GetCreditedList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetCurrencyList()
MDO List for table Currency:
Currency list
Declaration
public static ISoListProvider GetCurrencyList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetCurrencyList(Boolean)
MDO List for table Currency:
Currency list
Declaration
public static ISoListProvider GetCurrencyList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetCurrencyList(Int32[])
MDO List for table Currency:
Currency list
Declaration
public static ISoListProvider GetCurrencyList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetDiaryOwnerList()
MDO List for DiaryOwner: Associates records of type employee (type = 0), AND resources (type = 1)
Declaration
public static ISoListProvider GetDiaryOwnerList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetDiaryOwnerList(Boolean)
MDO List for DiaryOwner: Associates records of type employee (type = 0), AND resources (type = 1)
Declaration
public static ISoListProvider GetDiaryOwnerList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetDiaryOwnerList(Int32[])
MDO List for DiaryOwner: Associates records of type employee (type = 0), AND resources (type = 1)
Declaration
public static ISoListProvider GetDiaryOwnerList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetDocTmplList()
MDO List for table DocTmpl:
Describes templates available for writing new documents
Declaration
public static ISoListProvider GetDocTmplList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetDocTmplList(Boolean)
MDO List for table DocTmpl:
Describes templates available for writing new documents
Declaration
public static ISoListProvider GetDocTmplList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetDocTmplList(Int32[])
MDO List for table DocTmpl:
Describes templates available for writing new documents
Declaration
public static ISoListProvider GetDocTmplList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetExtAppList()
MDO List for table ExtApp:
Applications startable from SuperOffice
Declaration
public static ISoListProvider GetExtAppList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetExtAppList(Boolean)
MDO List for table ExtApp:
Applications startable from SuperOffice
Declaration
public static ISoListProvider GetExtAppList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetExtAppList(Int32[])
MDO List for table ExtApp:
Applications startable from SuperOffice
Declaration
public static ISoListProvider GetExtAppList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetGroupViewList()
MDO List for GroupView: GroupView records of type employee (type = 0)
Declaration
public static ISoListProvider GetGroupViewList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetGroupViewList(Boolean)
MDO List for GroupView: GroupView records of type employee (type = 0)
Declaration
public static ISoListProvider GetGroupViewList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetGroupViewList(Int32[])
MDO List for GroupView: GroupView records of type employee (type = 0)
Declaration
public static ISoListProvider GetGroupViewList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetIntentList()
MDO List for table Intent:
Declaration
public static ISoListProvider GetIntentList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetIntentList(Boolean)
MDO List for table Intent:
Declaration
public static ISoListProvider GetIntentList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetIntentList(Int32[])
MDO List for table Intent:
Declaration
public static ISoListProvider GetIntentList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetMrMrsList()
MDO List for table MrMrs:
List of salutations
Declaration
public static ISoListProvider GetMrMrsList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetMrMrsList(Boolean)
MDO List for table MrMrs:
List of salutations
Declaration
public static ISoListProvider GetMrMrsList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetMrMrsList(Int32[])
MDO List for table MrMrs:
List of salutations
Declaration
public static ISoListProvider GetMrMrsList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetOptCatList()
MDO List for table OptCat:
This table is not used in SuperOffice CRM 5 - reserved for Japan
Declaration
public static ISoListProvider GetOptCatList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetOptCatList(Boolean)
MDO List for table OptCat:
This table is not used in SuperOffice CRM 5 - reserved for Japan
Declaration
public static ISoListProvider GetOptCatList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetOptCatList(Int32[])
MDO List for table OptCat:
This table is not used in SuperOffice CRM 5 - reserved for Japan
Declaration
public static ISoListProvider GetOptCatList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetOptDecList()
MDO List for table OptDec:
This table is not used in SuperOffice 5.0 - reserved for Japan
Declaration
public static ISoListProvider GetOptDecList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetOptDecList(Boolean)
MDO List for table OptDec:
This table is not used in SuperOffice 5.0 - reserved for Japan
Declaration
public static ISoListProvider GetOptDecList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetOptDecList(Int32[])
MDO List for table OptDec:
This table is not used in SuperOffice 5.0 - reserved for Japan
Declaration
public static ISoListProvider GetOptDecList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetOptIntList()
MDO List for table OptInt:
This table is not used in SuperOffice CRM 5 - reserved for Japan
Declaration
public static ISoListProvider GetOptIntList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetOptIntList(Boolean)
MDO List for table OptInt:
This table is not used in SuperOffice CRM 5 - reserved for Japan
Declaration
public static ISoListProvider GetOptIntList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetOptIntList(Int32[])
MDO List for table OptInt:
This table is not used in SuperOffice CRM 5 - reserved for Japan
Declaration
public static ISoListProvider GetOptIntList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetOptStateList()
MDO List for table OptState:
This table is not used in SuperOffice CRM 5 - reserved for Japan
Declaration
public static ISoListProvider GetOptStateList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetOptStateList(Boolean)
MDO List for table OptState:
This table is not used in SuperOffice CRM 5 - reserved for Japan
Declaration
public static ISoListProvider GetOptStateList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetOptStateList(Int32[])
MDO List for table OptState:
This table is not used in SuperOffice CRM 5 - reserved for Japan
Declaration
public static ISoListProvider GetOptStateList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetOptTypeList()
MDO List for table OptType:
This table is not used in SuperOffice CRM 5 - reserved for Japan
Declaration
public static ISoListProvider GetOptTypeList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetOptTypeList(Boolean)
MDO List for table OptType:
This table is not used in SuperOffice CRM 5 - reserved for Japan
Declaration
public static ISoListProvider GetOptTypeList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetOptTypeList(Int32[])
MDO List for table OptType:
This table is not used in SuperOffice CRM 5 - reserved for Japan
Declaration
public static ISoListProvider GetOptTypeList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetOwnerContactList()
List of owner contacts
Declaration
public static ISoListProvider GetOwnerContactList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetPersIntList()
MDO List for table PersInt:
List of Person interests.
Declaration
public static ISoListProvider GetPersIntList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetPersIntList(Boolean)
MDO List for table PersInt:
List of Person interests.
Declaration
public static ISoListProvider GetPersIntList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetPersIntList(Int32[])
MDO List for table PersInt:
List of Person interests.
Declaration
public static ISoListProvider GetPersIntList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetPersPosList()
MDO List for table PersPos:
Contact person position list
Declaration
public static ISoListProvider GetPersPosList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetPersPosList(Boolean)
MDO List for table PersPos:
Contact person position list
Declaration
public static ISoListProvider GetPersPosList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetPersPosList(Int32[])
MDO List for table PersPos:
Contact person position list
Declaration
public static ISoListProvider GetPersPosList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetPMembTypeList()
MDO List for table PMembType:
List text of titles (member types) for project members.
Declaration
public static ISoListProvider GetPMembTypeList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetPMembTypeList(Boolean)
MDO List for table PMembType:
List text of titles (member types) for project members.
Declaration
public static ISoListProvider GetPMembTypeList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetPMembTypeList(Int32[])
MDO List for table PMembType:
List text of titles (member types) for project members.
Declaration
public static ISoListProvider GetPMembTypeList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetPriorityList()
MDO List for table Priority:
Used with appointments, “low”, “high”…
Declaration
public static ISoListProvider GetPriorityList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetProbList()
MDO List for table Prob:
Probability, used in sale.
Declaration
public static ISoListProvider GetProbList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetProbList(Boolean)
MDO List for table Prob:
Probability, used in sale.
Declaration
public static ISoListProvider GetProbList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetProbList(Int32[])
MDO List for table Prob:
Probability, used in sale.
Declaration
public static ISoListProvider GetProbList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetProjectList()
Declaration
public static ISoListProvider GetProjectList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetProjectList(String)
Declaration
public static ISoListProvider GetProjectList(string searchValue)Parameters
| Type | Name | Description |
|---|---|---|
| String | searchValue |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetProjStatusList()
MDO List for table ProjStatus:
Project status.
Declaration
public static ISoListProvider GetProjStatusList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetProjStatusList(Boolean)
MDO List for table ProjStatus:
Project status.
Declaration
public static ISoListProvider GetProjStatusList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetProjStatusList(Int32[])
MDO List for table ProjStatus:
Project status.
Declaration
public static ISoListProvider GetProjStatusList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetProjTypeList()
MDO List for table ProjType:
List of valid Project types.
Declaration
public static ISoListProvider GetProjTypeList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetProjTypeList(Boolean)
MDO List for table ProjType:
List of valid Project types.
Declaration
public static ISoListProvider GetProjTypeList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetProjTypeList(Int32[])
MDO List for table ProjType:
List of valid Project types.
Declaration
public static ISoListProvider GetProjTypeList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetReasonList()
MDO List for table Reason:
Why we lost the sale (list)
Declaration
public static ISoListProvider GetReasonList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetReasonList(Boolean)
MDO List for table Reason:
Why we lost the sale (list)
Declaration
public static ISoListProvider GetReasonList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetReasonList(Int32[])
MDO List for table Reason:
Why we lost the sale (list)
Declaration
public static ISoListProvider GetReasonList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetRejectReasonList()
MDO List for table RejectReason:
Declaration
public static ISoListProvider GetRejectReasonList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetRejectReasonList(Boolean)
MDO List for table RejectReason:
Declaration
public static ISoListProvider GetRejectReasonList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetRejectReasonList(Int32[])
MDO List for table RejectReason:
Declaration
public static ISoListProvider GetRejectReasonList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetRelationDefinitionList()
MDO List for table RelationDefinition:
List of all valid relation types.
This table defines the relations that can exist in the database. Each relation has an active text and a passive text. The table RelationTarget specifies which pairs of tables this relation can connect. Use of the active and passive texts is dependent on which direction the relation is viewed in, e.g., active text = “Owns” and passive text = “Is owned by”.
Declaration
public static ISoListProvider GetRelationDefinitionList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetRelationDefinitionList(Boolean)
MDO List for table RelationDefinition:
List of all valid relation types.
This table defines the relations that can exist in the database. Each relation has an active text and a passive text. The table RelationTarget specifies which pairs of tables this relation can connect. Use of the active and passive texts is dependent on which direction the relation is viewed in, e.g., active text = “Owns” and passive text = “Is owned by”.
Declaration
public static ISoListProvider GetRelationDefinitionList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetRelationDefinitionList(Int32[])
MDO List for table RelationDefinition:
List of all valid relation types.
This table defines the relations that can exist in the database. Each relation has an active text and a passive text. The table RelationTarget specifies which pairs of tables this relation can connect. Use of the active and passive texts is dependent on which direction the relation is viewed in, e.g., active text = “Owns” and passive text = “Is owned by”.
Declaration
public static ISoListProvider GetRelationDefinitionList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetResourceList()
MDO List for Resource: Associate records of type Resource (type = 1)
Declaration
public static ISoListProvider GetResourceList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetResourceList(Boolean)
MDO List for Resource: Associate records of type Resource (type = 1)
Declaration
public static ISoListProvider GetResourceList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetResourceList(Int32[])
MDO List for Resource: Associate records of type Resource (type = 1)
Declaration
public static ISoListProvider GetResourceList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetRolesList(RoleType)
MDO List for Roles specified by RoleType.
Declaration
public static ISoListProvider GetRolesList(RoleType roleType)Parameters
| Type | Name | Description |
|---|---|---|
| RoleType | roleType | RoleType to get the list for. |
Returns
| Type | Description |
|---|---|
| ISoListProvider | MDO list provider for the Roles list |
GetSalutationList()
MDO List for table Salutation:
Declaration
public static ISoListProvider GetSalutationList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetSalutationList(Boolean)
MDO List for table Salutation:
Declaration
public static ISoListProvider GetSalutationList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetSalutationList(Int32[])
MDO List for table Salutation:
Declaration
public static ISoListProvider GetSalutationList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetSearchCatList()
MDO List for table SearchCat:
List of selection types.
Declaration
public static ISoListProvider GetSearchCatList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetSearchCatList(Boolean)
MDO List for table SearchCat:
List of selection types.
Declaration
public static ISoListProvider GetSearchCatList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetSearchCatList(Int32[])
MDO List for table SearchCat:
List of selection types.
Declaration
public static ISoListProvider GetSearchCatList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetSourceList()
MDO List for table Source:
Source for sale (list)
Declaration
public static ISoListProvider GetSourceList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetSourceList(Boolean)
MDO List for table Source:
Source for sale (list)
Declaration
public static ISoListProvider GetSourceList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetSourceList(Int32[])
MDO List for table Source:
Source for sale (list)
Declaration
public static ISoListProvider GetSourceList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetTaskList()
MDO List for table Task:
The activity types, like “Phone”, “Meeting”…
Declaration
public static ISoListProvider GetTaskList()Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetTaskList(Boolean)
MDO List for table Task:
The activity types, like “Phone”, “Meeting”…
Declaration
public static ISoListProvider GetTaskList(bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetTaskList(Int32[])
MDO List for table Task:
The activity types, like “Phone”, “Meeting”…
Declaration
public static ISoListProvider GetTaskList(int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetUserDefinedList(Int32)
MDO List for UserDefined lists (from the udlist multi-list table)
Declaration
public static ISoListProvider GetUserDefinedList(int udListId)Parameters
| Type | Name | Description |
|---|---|---|
| Int32 | udListId | ID of the user-defined list to fetch items from |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetUserDefinedList(Int32, Boolean)
MDO List for UserDefined lists (from the udlist multi-list table)
Declaration
public static ISoListProvider GetUserDefinedList(int udListId, bool bForceFlat)Parameters
| Type | Name | Description |
|---|---|---|
| Int32 | udListId | ID of the user-defined list to fetch items from |
| Boolean | bForceFlat | Force the list to be flattened. Note that filtering according to the group_link tables will still be performed if the list has been set to 'Enable grouping and filtering' in the Admin application; only the result will always be flat. |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetUserDefinedList(Int32, Int32[])
MDO List for UserDefined lists (from the udlist multi-list table)
Declaration
public static ISoListProvider GetUserDefinedList(int udListId, int[] historyIds)Parameters
| Type | Name | Description |
|---|---|---|
| Int32 | udListId | ID of the user-defined list to fetch items from |
| Int32[] | historyIds | Array of item id's to return as 'history' items |
Returns
| Type | Description |
|---|---|
| ISoListProvider |
GetUserGroupList()
List of user groups
Declaration
public static ISoListProvider GetUserGroupList()Returns
| Type | Description |
|---|---|
| ISoListProvider |