Show / Hide Table of Contents

Class SoLists

Inheritance
Object
SoLists
Inherited Members
Object.ToString()
Object.Equals(Object)
Object.Equals(Object, Object)
Object.ReferenceEquals(Object, Object)
Object.GetHashCode()
Object.GetType()
Object.MemberwiseClone()
Namespace: SuperOffice.CRM.Lists
Assembly: SoDataBase.dll
Syntax
public static class SoLists

Methods

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 rows (currently 200) are fetched, since longer MDO lists are not really helpful. If more than 200 rows exist, then the last row will have primary key 0 and be an overflow marker.

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 and have to be decoded by that class before display. The resource manager system in Six.Web also has methods for decoding of complete strings that may contain such elements.

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 rows (currently 200) are fetched, since longer MDO lists are not really helpful. If more than 200 rows exist, then the last row will have primary key 0 and be an overflow marker.

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 and have to be decoded by that class before display. The resource manager system in Six.Web also has methods for decoding of complete strings that may contain such elements.

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 rows (currently 200) are fetched, since longer MDO lists are not really helpful. If more than 200 rows exist, then the last row will have primary key 0 and be an overflow marker.

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 and have to be decoded by that class before display. The resource manager system in Six.Web also has methods for decoding of complete strings that may contain such elements.

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 rows (currently 200) are fetched, since longer MDO lists are not really helpful. If more than 200 rows exist, then the last row will have primary key 0 and be an overflow marker.

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 and have to be decoded by that class before display. The resource manager system in Six.Web also has methods for decoding of complete strings that may contain such elements.

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
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Back to top