Class SoLists

Inheritance

Object

SoLists

Namespace: SuperOffice.CRM.Lists

Assembly: SoDataBase.dll

Syntax

public static class SoLists : Object

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