Skip to main content

MDO List Providers

List of MDO table names

List of other valid MDO providers

activelanguage

activitystatus

MDO provider for the ActivityStatus enum - NotStarted, Started, Completed

addressformat

MDO list provider for AddressFormats Id returned is the layout_id, not the addressformat_id.

allpersonsearch

Provider for selecting a Person, including search on contacts that match as well as persons. This provider will return a mix of contact and person records. The type is indicated in the Type property of the item, and the contact ID is always in the extraInfo. Uses freetext to perform a speedy search on the contact and person tables. Does not include sub-tables, like userdefined fields, text records etc.

allpersonwithassociatesearch

Provides the same baseline functionality as <see cref="T:SuperOffice.CRM.Lists.AllPersonListSearchProvider" />, but additionally adds the associateId of the person to the extrainfo and changes the iconhint if the person is an associate. Uses freetext to perform a speedy search on the contact and person tables. Does not include sub-tables, like userdefined fields, text records etc.

allpreferencekeys

MDO Provider that retrieves all preference keys

amountclass

GenericMDOProvider reads MDO lists with default settings

amountclass

GenericMDOProvider reads MDO lists with default settings

appointment

appointmentcategory

appointmentcautionwarning

Appointment.CautionWarning. Appointment and invitation synchronization info

appointmentcompleted

Appointment completed statuses - AppointmentStatus.NotStarted, AppointmentStatus.Completed

appointmentfavourite

MDO list provider for Favourites

appointmentgroup

Appointment grouping types - TaskType.Appointment, Phone, ToDo

appointmentresource

appointmenttask

MDO list provider for the task list of the AppointmentDialog. This list extends the basic &lt;see cref="T:SuperOffice.CRM.Rows.TaskRow" /&gt; with specialized icons based on the &lt;see cref="T:SuperOffice.Data.TaskType" /&gt;.

appointmenttextid

Special case of appointment list where we get the id value from the Text table. For use when we want to represent an appointment with the text.

appointmenttype

List of AppointmentType values - inDiary, inChecklist, Note, Document, SavedReport, BookingForDiary, BookingForChecklist

archiveprovider

MDO provider for available archive providers for Configurable screens. The items will be added by scanning ArchiveProviderFactory.KnownArchiveProviders for this pattern;

area

List provider for the Heading table. While this table looks like an MDO table, it lacks the standardized grouplink and headinglink companion tables for good reason, since it is the heading table itself.

associate

associaterestrictions

Public MDO provider based on the AssociateRestrictionsMDOProviderBase.

associatewithmail

Returns associates with their email addresses in the format "Full Name &lt;email&gt;". Associates without an e-mail address are returned as "Full Name".

attachment

business

GenericMDOProvider reads MDO lists with default settings

category

GenericMDOProvider reads MDO lists with default settings

categorygroup

MDO provider for the CategoryGroup enum.

chartselection

chatbot

List of all script folders that contain a script named like "%bot%register%". Returns script id + folder name as flat list.

chatchannel

chatservice

chatsessionstatus

Chat session status values

chatuser

colorindex

List of named colors from the "ColorIndex" enum. Steps to change the palette - 1. Add to the end of the ColorIndex enum (in Modelling) 2. Add to this provider. The color palette in SCIL uses the color code in the styleHint field 3. Update colors in fullcalendar.so.less so that css class colorX has the same color code returned by this list.

combinedcontactpersonsearch

Consider using the ContactAndPersonListFreetextSearchProvider/"contact_and_person_freetextsearch" MDO list instead of this one. Provider for selecting a Person or a Contact, including search on contacts that match as well as persons. this provider will return a mix of contact and person records. The type is indicated in the Type property of the item, and the contact ID is always in the extraInfo.

comptr

GenericMDOProvider reads MDO lists with default settings

consentpurpose

MDO list provider for ConsentPurpose

consentsource

MDO list provider for Consent source

contact

Provider for selecting a Contact - without person search

contact_and_person_freetextsearch

Provider for selecting a Contact or a Person Does keyword matching and scoring across multiple string fields. Checks name, department, soundex fields. Additional - <list type="bullet"><item>Name = Person or PersonContact or ContactPerson</item><item>AddContact = true or false - add a contact item for person items</item><item>ExpandContact = TRUE or false - add all persons for a contact items</item><item>SkipRetired = TRUE or false - skip retired persons</item><item>ContactId = 123 - boost persons belonging to contact id in results rank</item></list>

contact_and_person_freetextsearch_hierarchical

contact_freetextsearch

Provider for selecting a Contact - without person search. Does keyword matching and scoring across multiple string fields. Checks name, department, soundex fields.

contact_new

Provider for selecting a Contact - without person search. Does keyword matching and scoring across multiple string fields. Checks name, department, soundex fields.

contactfavourite

MDO list provider for Favourites

contactperson_freetextsearch

Provider for selecting a Contact - with person search. Does keyword matching and scoring across multiple string fields. Checks name, department, soundex fields.

contactphone

contactrelationdefinition

MDO list provider for contact/person relation definitions. This provider is a takes a mandatory additionalInfo parameter, that specifies what kind of relation should be fetched.

contactwithpersonsearch

Provider for selecting a Contact, including search on persons that match as well as contacts. this provider will return a mix of contact and person records. The type is indicated in the Type property of the item, and the contact ID is always in the extraInfo.

contactwithpersonsearch_new

Provider for selecting a Contact, including search on persons that match as well as contacts. this provider will return a mix of contact and person records. The type is indicated in the Type property of the item, and the contact ID is always in the extraInfo.

contint

GenericMDOProvider reads MDO lists with default settings

contint

GenericMDOProvider reads MDO lists with default settings

country

country2

Same as CountryProvider, but with icon hints based on the countrys name.

createdocumenttemplateplugin

List of document plugins that can create document templates.

credentialgroup

List of user groups supported by a named creditial plugin, sorted by group name.

credited

GenericMDOProvider reads MDO lists with default settings

crmfields

crmscript

Archive of CRMScripts. Returns script id + name of script as hierarchy.

culture

culturesolanguage

List of SuperOffice cultures with old-style SO Culture name in ExtraInfo. ( 1031, "German","GE" )

currency

GenericMDOProvider reads MDO lists with default settings

currentudeffields

Get a list of udef fields for a given type. Pass the type as AdditionalInfo. Optionally it is possible to exclude page one fields by adding extrainfo ( 'Contact,excludepageone' )

customerlanguage

Customer Languages list. From the CustLang table.

customobjectfavourite

customobjectlist

<see cref="T:SuperOffice.CRM.Lists.CustomObjectListProvider" /> creates tree list of the custom objects

customobjectrelation

MDO list provider for custom object relations Custom object's name is passed as additionalInfo parameter

dashboard

MDO list provider for Dashboard, can be used by Navigator.

dashboardcurrency

dashboardentity

dashboardtheme

dashboardtile

MDO list provider for Dashboard tiles If the DashboardTileEntityType parameter is given in the ExtraInfo, only this type will be shown in list, so no tree view in that case. Example - DashboardTileEntityType=Company

dashboardtileentitytype

List of dashboard tile types - Company, Project, Sale, Product, Activity, Web Panel

dashtilemeasure

dayofmonth

MDO provider for the hard-coded list of day alternatives in the recurrence dialog.

deliveryterms

GenericMDOProvider reads MDO lists with default settings

deliveryterms

GenericMDOProvider reads MDO lists with default settings

deliverytype

GenericMDOProvider reads MDO lists with default settings

deliverytype

GenericMDOProvider reads MDO lists with default settings

diaryowner

List provider that returns diary owners, i.e., our own employees plus resources

direction

Document and Task directions - TaskDirection.Incoming, Outgoing

disconnectpersonactions

List of actions to perform when disconnecting a contact from a company

doctmpl

GenericMDOProvider reads MDO lists with default settings

doctmpl

GenericMDOProvider reads MDO lists with default settings

document

MDO list provider for documents.

documentcategory

documentcompleted

Document completed status list - Not done, Done.

documentfavourite

MDO list provider for Favourites

documentgroup

Document types - TaskType.Document, Email, Fax, Merge draft, Merge Final.

documenthandler

documentmailing

Document shipments (mail merges).

documentmailingtemplate

Document mailing templates

documenttemplatelanguage

MDO Provider for Document Template langauges.

documenttemplatesfiltered

MDO Provider for Document Templates, excluding Document details and quote mail templates, which are for system use rather than end-user choosing.

documenttypes

List of document types for the given plugin. ExtraInfo = document plugin-id.

efd_13

Extra fields dropdown lists. Contains list of string values defined on the extra_field. List names are 'EFD_123' where 123 is the extra field id.

ejcategory

EjCategoryProvider creates a flat or tree list based on the table - EJ_CATEGORY

ejuser

emailaddress

List of e-mail addresses matching the search value Searches e-mail address, person name, company name. E-mail address matches - return e-mail addresses + owner name (person or contact name) Person name matches - return all e-mail addresses for matched persons Company name matches. return all persons + first e-mail address for matched persons.

emailflow

List provider for EmailFlow

emailfolder

EmailFolderProvider gives you the folder hierarchy of a given mail account

emailfromtype

MDO provider for the EmailFromType enum

emailphone

List of e-mail addresses and phone numbers matching the search value Searches e-mail address, phone number, person name, company name. E-mail address/phone number matches - return e-mail addresses/phone numbers + owner name (person or contact name) Person name matches - return all e-mail addresses/phone numbers for matched persons Company name matches. return all persons + first e-mail address/phone number for matched persons.

emailpriorityprovider

MDO List provider for email priority - Highest, High, Normal, Low, Lowest, No Priority. Enum value in the extrainfo field

emailreplytotype

MDO provider for the EmailReplyToType enum

enrichcontact

List of possible contacts to import from outside sources.

erpactortype

erpconnections

Retrieve the list of all defined Erp Connections (not Connectors, that's another list)

erpconnectors

Retrieve the list of all defined Erp Connectors (not Connections, that's another list)

erpdeliveryterms

erpdeliverytype

erpfields

erppaymentterms

erppaymenttype

erpproductcategory

erpproductfamily

erpproducttype

eventhandlertype

Screen trigger event types - members of <see cref="T:SuperOffice.Data.EventHandlerType" /> enum.

everymonth

MDO provider for the hard-coded list of day month in the recurrence dialog.

executeonevent

List of windows client events to execute tasks on - Logon, Logoff, LocalUpdate

exporttemplate

MDO provider for the list of template files for the 'export to file' function in the Selection Task pane. These are .sxf files found in so_arc/template, as well as in the so_arc/&lt;username&gt; directory of the current user. Impersonation is used if specified by the config file to access the document directories. The file name is returned as the list item name, while the full path is in the extrainfo.

extapp

GenericMDOProvider reads MDO lists with default settings

extapp

GenericMDOProvider reads MDO lists with default settings

faqcategory

faqreplytemplate

faqreplytemplatefavourite

MDO list provider for Favourites

favouritetype

MDO list provider for Favourite types

filterassociates

Associate list for the Filter dialog. This associate list differs from the standard list in two ways - a) It contains even former employees (you may wnat to filter in our out their activites, even though they have gone); and b) It is of type Selectable, with the currently selected associates marked as such.

filterfuturedate

MDO provider for the hard-coded list of future date alternatives in the Filter dialog. Each items' extraInfo contains the number of days into the future that this choice represents, slightly simplified (30 days per month and no leap years).

filtergroups

User groups, filtered according to the usergroups selected in the filter dialog.

findproduct

QuickSearch for the Add Quote Line dialog, where a single-line user input is passed to the correct QuoteConnection FindProduct method, and results are returned in a standard or specified format back. The format can be specified by setting a columnLayout part in the extrainfo. For example "columnLayout=Code\tName\tUnitListPrice\tQuantityUnit"

font

List provider for availablefonts table.

fontsize

List of font types

fonttype

List of font types

form

Get all forms with folder hierarchy. Set ExtraInfo "onlyActive=true" if you only want to get active forms and "onlyNewTicket=true" if only forms that create tickets. Set extrainfo "onlyForms=true" if you do not want form templates.

formfields

List of customizable fields for forms

formfolder

FormFolderProvider creates a flat or tree list based on the table - s_picture_folder

formmailings

formratingdice

formratingnps

formratingsmileys

formratingstars

MDO provider for the Ratings as used in forms

formratingthumbs

formsubmissionstatusprovider

freetextsearchentity

List provider that returns the entities supported by free text search. The extraInfo field contains the programmatic table name, which can be used as input for the OwnerEntityName restriction of the <see cref="T:SuperOffice.CRM.ArchiveLists.FreetextCountProvider" />. The ID of each item is the table number corresponding to the entity, and can also be used as a restriction value.

functionrights

FunctionRightsListProvider returns a MDO list of function rights in the database. Additional Info = "role=123;languageId=1024;roleType=1"

genericperson

List of persons with mail. Supports Selection(any type), project and associate. Uses an inner provider <see cref="T:SuperOffice.CRM.Lists.PersonListGenericContactProjectProvider" />.

genericpersonwithmail

List of persons with mail. Supports Selection(any type), project and associate. Uses an inner provider <see cref="T:SuperOffice.CRM.Lists.PersonWithMailListProvider" />.

groupview

GroupViewMDOProvider uses the AssociateMDOProvider + DiaryView to create the MDOlist for Groupview in Diary view.

heading

List provider for the Heading table. While this table looks like an MDO table, it lacks the standardized grouplink and headinglink companion tables for good reason, since it is the heading table itself.

hierarchy

List provider for the Hierarchy table. Pass the domain using Additional info. MDO can be nested arbitrary levels deep. Fullname contains path separated. returns a list of domains if no domain is specified.

htmlmailing

MDO provider for the different types of Mailings

htmlmailingtemplate

MDO provider for the different types of Mailing templates

importblankaction

Import actions for blank values - Use Person Name, Skip

importcontactduplicatematch

List of fields to match contact imports.

importduplicateaction

Import Duplicate actions - Add, Merge, Replace, Skip

importduplicateactionwithoutadd

Import duplicate; Merge, Replace, Skip

importfields

MDO provider for column headers used in import

importnewlistitem

Import list items - Add item, use default, use blank

importnewpositionitem

Import position items - Add to list, set to blank

importnewproductlistitem

Import product list items - add, use blank

importpersonduplicatematch

Import Person Fields to match on - Name, E-mail, phone, number, id, None

importphoneurlsemail

Import phone/url/email values - Add, Replace, Skip

importproductduplicatematch

Import product detect duplicates based on field - Name, Code, Name+Code

importproductfields

MDO provider for column headers used in import

intent

GenericMDOProvider reads MDO lists with default settings

invitationtemplatelanguage

iso639language

kbaccesslevel

MDO provider for the KbAccessLevel enum

kbentry

kbworkflow

MDO list provider for KB Workflow.

landingpage

language

leadstatus

List provider for LeadStatus

legalbase

MDO list provider for Legal base

lists

List provider for the Heading table. While this table looks like an MDO table, it lacks the standardized grouplink and headinglink companion tables for good reason, since it is the heading table itself.

locatecontact

Provider for selecting a Contact, including search on persons that match as well as contacts. this provider will return contact records.

locatecontact_new

Provider for selecting a Contact, including search on persons that match as well as contacts. this provider will return contact records, even for person matches.

locateperson

Person list with contact name.

location

Implements the mdo provider for the list of avaiable locations. This list aggregates elements from different sources like contact, person, associate, participants and resources to build a list that represents all the relevant, available locations that can be used when creating a new appointment. The provider uses a set of name/value pairs in the additionalinfo parameter used in the construct() function. The available names are - ownercontactid (mandatory) - id of the contact for the owner of the appointment currentassociate (mandatory) - currently logged in associate appointmentcontactid - id of the contact in the appointment appointmentpersonid - id of the person in the appointment appointmentid - id of existing appointment startdate - startdate used for conflict resolution enddate - enddate used for conflict resolution participantpersonidlist - comma separated list of existing participant person ids participantassociateidlist - comma separated list of existing participant associate ids(resources) skipresourcelocation - Skip resource locations

mailclient

mailhtmltemplate

List provider for the Mailtemplates.

mailing

All mailings - history ids

mailingdomains

MDO list provider for Mailing domains, including leading @

mailingfavourite

MDO list provider for Favourites

mailingstatus

mailingsubscriptiontype

Mailing subscription types; Invitations, news, etc

mailingtemplate

General mailing templates

mailingtype

Mailing types - Html mail, SMS, Word Document

mailtemplate

List provider for the Mailtemplates.

mergedocument

MDO list provider for documents marked as type <see cref="F:SuperOffice.Data.TaskType.MailMergeDraft" />.

mergetags

month

MDO provider for the hard-coded list of "of" months in the recurrence dialog.

mrmrs

GenericMDOProvider reads MDO lists with default settings

mrmrs

GenericMDOProvider reads MDO lists with default settings

newsfeeditemstatusprovider

MDO List provider for news feed item status - Normal, Handling, Handled. Enum value in the extrainfo field.

ofmonth

MDO provider for the hard-coded list of "of" months in the recurrence dialog.

onlinefontlibrary

MDO provider for the available fonts from the Online Template Library.

ownercontact

MDO provider for listing owner contacts.

paymentterms

GenericMDOProvider reads MDO lists with default settings

paymentterms

GenericMDOProvider reads MDO lists with default settings

paymenttype

GenericMDOProvider reads MDO lists with default settings

paymenttype

GenericMDOProvider reads MDO lists with default settings

period

Period values - Day, Week, Month, Quarter, Year

periods

Period values - Day, Week, Month, Quarter, Year

persint

GenericMDOProvider reads MDO lists with default settings

persint

GenericMDOProvider reads MDO lists with default settings

person

List of persons from the Archive provider

person_freetextsearch

Provider for selecting a Person - without contact search. Does keyword matching and scoring across multiple tables using freetext index.

personcontact_freetextsearch

Provider for selecting a Person - with contact search. Does keyword matching and scoring across multiple tables using freetext index. First does BEGINS and CONTAINS searches in parallel. If neither results in anything, then falls back to SOUNDEX search.

personcontactfavourite

MDO list provider for Favourites

personemailaddress

List of e-mail addresses matching the search value, possibly restricted to a given company or person.

personfavourite

MDO list provider for Favourites

personphone

Search phone numbers for matching values, restricted to a given company or person.

personrestrictions

Implements a person mdolist provider that uses the conflicts detector to append information on conflicts

personurl

List of urls (web pages) matching the search value, possibly restricted to a given company or person.

personwithmail

List of persons fetched based on provided criteria Output is in format - "Person Full Name &lt;person@mail.com&gt;" Optional - Get multiple emails pr. person. (getallemails)

perspos

GenericMDOProvider reads MDO lists with default settings

perspos

GenericMDOProvider reads MDO lists with default settings

phonesearch

Search phone numbers for matching stripped numbers, across person and contacts. Return company name + department, or person name. Use AdditionInfo to restrict search to just Person or Contact phone numbers using "P" or "C".

plugin

List of installed and available Document plugins

pmembtype

GenericMDOProvider reads MDO lists with default settings

pmembtype

GenericMDOProvider reads MDO lists with default settings

prefdescline

PrefDesc creates a MDO list of prefdesclines for a given prefdesc id.

preferencekey

MDO Provider that retrieves a list of preference keys corresponding to a given section

preferencelineitem

MDO Provider for preferences that have a list of possible values in the database

preferencesection

MDO Provider that retrieves a list of preference sections

pricelist

List of pricelists from the PriceList table. Supported values in the AdditionalInfo - <list type="bullet"><item><term>all</term><description>true|false. If true is specified, inactive items is also returned.</description></item><item><term>QuoteConnectionId</term><description>Gets items for a specific Quote connection. If not specified, only SuperOffice pricelists (where IsErpCopy=false) will be returned.</description></item></list><example>AdditionalInfo string - "all=true&amp;QuoteConnectionId=2"</example>

priceunit

GenericMDOProvider reads MDO lists with default settings

priceunit

GenericMDOProvider reads MDO lists with default settings

priority

GenericMDOProvider reads MDO lists with default settings

privacytemplate

This is a variant of the DocTmpl list - document templates - restricted to those that are of some privacy document type.

prob

GenericMDOProvider reads MDO lists with default settings

productcategory

GenericMDOProvider reads MDO lists with default settings

productcategory

GenericMDOProvider reads MDO lists with default settings

productfamily

GenericMDOProvider reads MDO lists with default settings

productfamily

GenericMDOProvider reads MDO lists with default settings

productimage

Return product images from the blob table

producttype

GenericMDOProvider reads MDO lists with default settings

producttype

GenericMDOProvider reads MDO lists with default settings

project

Provider for selecting a project.

project_freetextsearch

Provider for selecting a Project. Does keyword matching and scoring across multiple string fields. Checks name, description, soundex fields.

project_new

Provider for selecting a project. Returns search results in rank order Supports searching across project text fields. Respects the Project.SkipCompletedProjects user preference.

projectassociate

MDO provider for associates that are members of a project

projectfavourite

MDO list provider for Favourites

projectimage

Project images from the blob table

projectmembereventparticipantstatus

List of project member event status fields.

projectmemberwithmail

projectstatus

List of project guide steps status values.

projecttype

Project type list. Encodes Default project duration in extra info.

projecttypeflatlist

Project type list. Encodes Default project duration in extra info.

projstatus

GenericMDOProvider reads MDO lists with default settings

projstatus

GenericMDOProvider reads MDO lists with default settings

projtype

GenericMDOProvider reads MDO lists with default settings

projtype

GenericMDOProvider reads MDO lists with default settings

quotealternatives

Quote alternative selector for one Quote Version. Send QuoteVersionId=&lt;id&gt; in ExtraInfo to specify quote version id

quoteapprovalassociate

MDO provider for associates that are allowed to approve a quote.

quoteapprovers

Retrieve the list of all users that can approve quotes

quoteapprreason

GenericMDOProvider reads MDO lists with default settings

quoteapprreason

GenericMDOProvider reads MDO lists with default settings

quoteconnections

Retrieve the list of all defined Quote Connections - i.e. not the connectors (DLLs). ExtraInfo - "connectorname=Name-of-connector" - restricts results to connections defined by one particular connector.

quoteconnectors

Retrieve the list of all installed (i.e., loaded assemblies) Quote Connectors

quotedenyreason

GenericMDOProvider reads MDO lists with default settings

quotedenyreason

GenericMDOProvider reads MDO lists with default settings

quotedocumentgroupfields

Possible choices for fields that you can GROUP BY in quote detail documents.

quotedocumentorderbyfields

Possible choices for fields you can ORDER BY, within a group (or without grouping)

quotedocuments

MDO provider for the list of current / candidate "main document" for a given quote

quotedocumenttype

List of quote document types - assumes ExtraInfo is the name of RecordType enum value

quotelinestatus

Hard-coded list of values for the QuoteLine.Status field, see <see cref="T:SuperOffice.Data.QuoteStatus" /> enum.

quotetemplate

This is a variant of the DocTmpl list - document templates - restricted to those that are of some quote document type. Use AdditionalInfo 'DocTmplQuoteType=&lt;a valid DocTmplQuoteType enum string value&gt;' to specify which one it should be

quoteversion

Quote version selector for one Quote. Send QuoteId=&lt;id&gt; in ExtraInfo to specify quote id

quoteversionstate

List provider for the <see cref="T:SuperOffice.Data.QuoteVersionState" /> enum

reason

GenericMDOProvider reads MDO lists with default settings

reasonsold

GenericMDOProvider reads MDO lists with default settings

reasonsold

GenericMDOProvider reads MDO lists with default settings

reasonstalled

GenericMDOProvider reads MDO lists with default settings

reasonstalled

GenericMDOProvider reads MDO lists with default settings

recentnavigation

MDO list provider for the Recent navigation history of the current associate - the ranked list of recently visited entities written by the ViewState agent's <c>UpsertRecentNavigation</c> operation. Items are returned most-recent first (descending <c>navigation_history.rank</c>). Keys of the form <c>&lt;table&gt;|&lt;pkfield&gt;=&lt;id&gt;</c> (e.g. <c>person|person_id=123</c>) are resolved to display names for known tables (currently contact, person, dashboard, email_flow, selection, project, sale, ticket and the virtual mailitem); anything else falls back to the raw key as name. An entry of a known table that resolves to nothing — the record was deleted, or the associate's rights changed and the sentry-filtered lookup no longer sees it — is left OUT of the list - it can no longer be opened, so it must not linger as a raw key. (The stored row stays; it ages out.) A key of a table with no resolver here is still returned raw, but the CRM client drops any entity key it receives still labelled with its own key — so a newly recorded entity table needs a resolver in one of the two layers or its entries never reach the user. That drop rule makes the return-field order load-bearing - row-level access filtering happens on the FIRST return field's table (<c>SoDataReader</c> checks <c>RF</c> on it), so every fetcher below puts the entity's own primary key first. Reordering <c>ReturnFields</c> would move the sentry onto a joined table and silently change which entries survive, not just how they are labelled. The name follows the functional spec's entry format (§4.1-4.9) - the record's own name followed by its context in parentheses — "Rema 1000 (Purchasing)", "John Smith (Rema 1000)". A record whose icon carries information of its own (the company's country flag §4.2, the sale's Sold/Lost/Stalled marker §4.4) also returns an <see cref="P:SuperOffice.CRM.Lists.ISoListItem.IconHint" /> that replaces the generic entity icon.

recipientfavourite

MDO list provider for Favourites

recordtype

A complete and generic mapping of record types to resource strings. This is a simple, hard-coded list corresponding to Task table <see cref="!:SuperOffice.CRM.Data.Task" /> record_type column which is defined by a typed field <see cref="T:SuperOffice.Data.SQL.TaskTypeFieldInfo" /> using the TaskType enum AN.

recurrenceweekcycle

MDO provider for the hard-coded list of week cycle alternatives in the recurrence dialog.

rejectreason

GenericMDOProvider reads MDO lists with default settings

rejectreason

GenericMDOProvider reads MDO lists with default settings

relateddatafields

relationdefinition

RelationsSearchListProviderAppointmentActive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderAppointmentAppointmentActive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderAppointmentAppointmentPassive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderAppointmentDocumentActive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderAppointmentDocumentPassive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderAppointmentPassive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderAppointmentSaleActive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderAppointmentSalePassive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderContactActive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderContactContactActive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderContactContactPassive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderContactPassive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderContactPersonActive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderContactPersonPassive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderDocumentActive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderDocumentAppointmentActive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderDocumentAppointmentPassive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderDocumentDocumentActive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderDocumentDocumentPassive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderDocumentPassive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderDocumentSaleActive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderDocumentSalePassive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderPersonActive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderPersonContactActive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderPersonContactPassive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderPersonPassive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderPersonPersonActive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderPersonPersonPassive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderSaleActive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderSaleAppointmentActive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderSaleAppointmentPassive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderSaleDocumentActive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderSaleDocumentPassive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderSalePassive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderSaleSaleActive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

RelationsSearchListProviderSaleSalePassive

Serve the active and passive texts of relations, with a given table as source (active) or destination (passive).

replytemplate

replytemplateaccesslevel

MDO provider for the ReplyTemplateAccessLevel enum

resource

MDO provider for resources (from the associate table)

resourcerestrictions

MDO provider for resources (from the associate table) that uses restrictions to include conflict checking

restrictionoperators

This SoList provider will generate the operator list for a given search criterion data type. The data type is passed in as the extraInfo parameter, and is generally one of the constants in <see cref="!:SuperOffice.CRM.ArchiveLists.ArchiveListConstants.ColumnTypes" />. The <see cref="T:SuperOffice.CRM.ArchiveLists.RestrictionOperations" /> class is the source of the data, so this list will change if that class is extended.

roles

RoleListProvider creates a MDO list of roles in the database. Default list are the employee roles. Use ExtraInfo to get other RoleTypes. ExtraInfo - "0" Default, to get employee roles ExtraInfo - "1" to get external users roles ExtraInfo - "2" to get anonymous roles. ExtraInfo - "3" to get system user roles.

saintactivitytype

This SoList provider generates the appointment/task type list for the Saint criteria. This is a simple, hard-coded list corresponding to the type field of the <see cref="!:SuperOffice.CRM.Rows.DocTmpl" /> and <see cref="!:SuperOffice.CRM.Rows.Task" /> tables. Tasks are both appointments and documents.

saintamountclass

This SoList provider generates the amount class list for the Saint criteria. This list is an extension of the basic AmountClass MDO list, with the addition of an ALL choice with ID 0.

saintdirection

This SoList provider generates the appointment/task direction list for the Saint criteria. This is a simple, hard-coded list corresponding to the direction field of the <see cref="!:SuperOffice.CRM.Rows.DocTmpl" /> and <see cref="!:SuperOffice.CRM.Rows.Task" /> tables. Tasks are both appointments and documents.

saintintention

This SoList provider generates the Intent list for the Saint criteria. This list is an extension of the basic Intent MDO list, with the addition of an ALL choice with ID 0.

saintsalestatus

This SoList provider generates the sale status list for the Saint criteria. This is a simple, hard-coded list corresponding to the status field of the <see cref="!:SuperOffice.CRM.Rows.Sale" /> table.

saintticketcategory

This SoList provider generates the eJournal top-level categories, meant for the saint system

saintticketstatus

This SoList provider generates the ticket status list for the Saint criteria. This is a simple, hard-coded list, special for this context

sale

List of sales. Skips completed sales SkipCompletedSales userpref is set. Skips sales without quotes if AdditionalInfo contains "hasQuoteOnline=1". Skips sales without stakeholders if AdditionalInfo contains "stakeholderOnly=1". Filter sales according to currency if AdditionalInfo contains "hasCurrency=(currency-id)"

sale_freetextsearch

Provider for selecting a Sale. Does keyword matching and scoring across multiple string fields. Checks name, description, soundex fields as well as contact, person and project tables linked to sale. Supports cross-table matching - "Guttorm Teacup" will find sales from person "Guttorm" with title containing "Teacup", as well as from person "Guttorm" in project "Teacup".

sale_new

List of sales. Searches sale + company names + person names. Skips completed sales SkipCompletedSales userpref is set. Skips sales without quotes if AdditionalInfo contains "hasQuoteOnline=1". Skips sales without stakeholders if AdditionalInfo contains "stakeholderOnly=1". Filter sales according to currency if AdditionalInfo contains "hasCurrency=(currency-id)"

salecategory

saledone

Sale Done status - SaleDone.Done or NotDone.

salefavourite

MDO list provider for Favourites

saleguidestage

MDO provider for the stage list, customized for the sale guide stage button row

saleprobability

MDO list provider for the probability list of the Sale dialog. This list extends the basic <see cref="!:ProbRow" /> list with a leading 'lost' and a trailing 'sold' item, and specialized icons. It also adds the probability as part of the text, and again in the extraInfo field.

salesource

MDO list provider for the source list of the Sale dialog. This list extends the basic <see cref="!:SourceRow" /> list with icons

salestage

Provider for selecting a stage. AdditionalInfo is used as criteria to filter stages based on SaleType.

salestatus

List for the Sale.Status field - Open, Lost, Sold, Stalled.

saletype

List of sale types, with default sale duration in minutes in extra info.

saletype

List of sale types, with default sale duration in minutes in extra info.

saletypecat

GenericMDOProvider reads MDO lists with default settings

saletypecat

GenericMDOProvider reads MDO lists with default settings

saletypecategories

SaleTypeCategories creates a MDO list of sale type categories in the database.

salutation

GenericMDOProvider reads MDO lists with default settings

satellites

SatelliteProvider creates a MDO list of satellites.

searchcat

GenericMDOProvider reads MDO lists with default settings

searchcat

GenericMDOProvider reads MDO lists with default settings

selection

Provider for selecting a selection. Supported additionalInfo - kind=static or kind=dynamic to restrict to static or dynamic selections only. Otherwise you'll get both kinds. membertype=[tablename|tablenumber] to restrict to one kind of entities. Both tableNumber and table name can be used. Any combination of these are supported.

selection_freetextsearch

Provider for selecting a Selection. Does keyword matching and scoring across multiple string fields. Checks name, description, soundex fields.

selectioncriteriamembertype

selectionfavourite

MDO list provider for selection favourites. Supported additionalInfo - membertype=[tablename] to restrict to one kind of entities.

selectionmembertype

MDO provider for the selection archive providers types. The items will be added by scanning ArchiveProviderFactory.KnownArchiveProviders for this pattern; [TableName]Selection. If the prefix is a known table, the tablename will be added to list with the TableNumber as the ID.

selectionmembertypeclean

selectionmembertypev2

MDO provider for the selection archive providers types. The items will be added by scanning ArchiveProviderFactory.KnownArchiveProviders for this pattern; [TableName]Selection. If the prefix is a known table, the tablename will be added to list with the TableNumber as the ID.

selectionmemberwithmail

List of selection members fetched based on provided criteria Output is in format - "[ContactName, Department/PersonFullName] &lt;registered@email.com&gt;" Ex - "Contact, Department &lt;registered@email.com&gt;" "Person Name &lt;registered@email.com&gt;"

selectiontype

MDO provider for the hard-coded list of selection kinds - Static, Dynamic, Combined. Combined requires the Combined Selection CAL license.

selectionuniontype

Different ways to combine selections - Union, Intersect, Disjoin, Left or Right Subtraction.

sentiment

serviceassociate

MDO provider for associates that are allowed to approve a quote.

shipmentaddrstatusprovider

shipmentfolder

ShipmentFolderProvider creates a flat or tree list based on the table - s_picture_folder

shipmentlinks

Create a list of specified mailings (flow, form, regular mailing/shipment...), hierarchy optional

shipmenttype

MDO list provider for ConsentPurpose

simplemailingstatus

smsmailing

SMS Shipment names

smsmailingtemplate

SMS Mailing templates

source

GenericMDOProvider reads MDO lists with default settings

sourceproduct

Products - Sales &amp; Marketing, Customer Service

specifiedmailings

Create a list of mailings (flow, form, regular mailing/shipment...), hierarchy optional

stakeholderrole

GenericMDOProvider reads MDO lists with default settings

stakeholderrole

GenericMDOProvider reads MDO lists with default settings

statusdef

Return list of status monitors defined in the system. Additional info query parameter = "Contact" or "project".

statusmonitorimage

List of images for status monitors in the blob table.

subscriptionunit

GenericMDOProvider reads MDO lists with default settings

subscriptionunit

GenericMDOProvider reads MDO lists with default settings

suggestedappointment

Suggested Appointment Provider creates a MDO list of suggested appointments for a given guide stage.

suggesteddocument

SuggestedDocumentProvider creates a MDO list of suggested documents in the database.

systemeventtype

System event types - NoLogin, NoFreeText, NoTravel, Message-of-the-day

tags

GenericMDOProvider reads MDO lists with default settings

targetentitytype

TargetEntities

targetmeasurementunit

MeasurementUnits

targettypes

targetyear

Year MDO list. Includes the two coming years, this year, and previous 5 years

task

Task table MDO list. Optional include "None" as first value.

taskmenu

GenericMDOProvider reads MDO lists with default settings

taskmenu

GenericMDOProvider reads MDO lists with default settings

taskmenudestination

taskmenugroup

List of TaskMenus with visible for groups as commaseperated ids in extrainfo field. This list only makes sence if the setting use groups and heading are turned on for

templatevariables

ticket

Provider for selecting a ticket. Supported additionalInfo - nameformat=includePersonAndCompany or nameformat=includeTicketId indicates how to format item name. If not specified, includePersonAndCompany is used.

ticket_freetextsearch

Provider for selecting a Ticket - with contact and person search. Does keyword matching and scoring across multiple string fields. Checks ticket heading, from, author as well as contact, person and project tables. Supports cross-table matching - "Guttorm Teacup" will find tickets from person "Guttorm" with title containing "Teacup".

ticket_selection_freetextsearch

Provider for selecting Ticket Selection or a Ticket. Does keyword matching and scoring. Searches selection table and ticket table.

ticketalert

ticketfavourite

ticketorigin

Ticket Origin

ticketpriority

MDO list provider for ticket priorities.

ticketpriorityescalateevent

MDO list provider for ticket Priority EscalateEvents enum.

ticketread

ticketrelationdefinition

MDO list provider for ticket relation definitions.

ticketrelationtype

Ticket Relation Type

ticketselectionwithstaticmenu

Provider for selecting ticket selections

ticketslevel

Ticket Security Level

ticketstatus

Ticket status values - Open, Closed, Inactive, Deleted, Connected and Spam (if enabled).

ticketstatustimecounter

Ticket status timer count values - None, Internall, Externally, Queue

ticketstatuswithoutpostpone

ticketstatuswithpostpone

ticketticketstatus

TicketTicketStatusProvider creates a flat list based on the table - TICKET_STATUS

tickettype

TicketTypeProvider creates a flat list based on the table - TICKET_TYPE

time

MDO provider for the hard-coded list of time alternatives in the appointment dialog and in edit/preferences The type field contains seconds past midnight for the items' hour/minute value; extrainfo contains hh:mm (always 2 + 2 digits and colon, regardless of culture); and name/tooltip contain a time value encoded with CultureDataFormatter.<see cref="M:SuperOffice.CRM.Globalization.CultureDataFormatter.EncodeTime(System.DateTime)" />.

timezone

timezoneiana

Provides the timezone list. The extrainfo contains the IANA-id of the timezone. The iconhint follows the structure 'Flag_[country_name]'.

timezonewithcode

Provides the timezone list. The country code is given in the type field. If no search value is passed in the list is restricted to 'available' timezones

typegroup

Type Group - Task, Activity, Document, Sale

typicalsearch

MDO provider for the TypicalSearch Title, Tooltip and Id ExtraInfo parameter specifies the entity of the typical search rows to fetch

udeffields

Get a list of udef fields for a given type. Optionally it is possible to exclude page one fields by adding extrainfo ( 'Contact,excludepageone' )

udeffieldswithchanges

Get a list of udef fields for a given type. Optionally it is possible to exclude page one fields by adding extrainfo ( 'Contact,excludepageone' )

udeffieldtype

List of UDef field types for a given owner table, and possibly restricted based on the current field type

udlist

MDO Provider for 'user-defined' lists, i.e., those that reside in the UDList table. Mandatory additionalInfo is the udListId, which identifies the actual sublist. There is also a dynamic provider that will make a provider called 'udlist&lt;id&gt;, for instance udlist123, where the sublist id is part of the name. Nice if you are in a situation where you can only get a list name and not the additionalInfo as a separate parameter.

udlist

MDO Provider for 'user-defined' lists, i.e., those that reside in the UDList table. Mandatory additionalInfo is the udListId, which identifies the actual sublist. There is also a dynamic provider that will make a provider called 'udlist&lt;id&gt;, for instance udlist123, where the sublist id is part of the name. Nice if you are in a situation where you can only get a list name and not the additionalInfo as a separate parameter.

udlist28

Dynamic MDO provider that will create a list with the name udlist&lt;id&gt; for each user-defined list in the UDListDefinition table. The actual fetching is done by an inner <see cref="T:SuperOffice.CRM.Lists.UdListMDOProvider" /> for whatever list is implicitly specified by the id suffix of the dynamic list name

udlist30002

MDO provider for the ChatService

urlencoding

usergroup

List provider for the UserGroup table. While this table looks like an MDO table, it lacks the standardized grouplink and headinglink companion tables (for good reason, since it is the group table itself).

usergroupwithhistoryall

List provider for the UserGroup table. While this table looks like an MDO table, it lacks the standardized grouplink and headinglink companion tables (for good reason, since it is the group table itself). This provider includes the 'History' and 'All' choices, with id's -1 and -2. The <see cref="T:SuperOffice.CRM.ArchiveLists.ParticipantsProvider" /> (actually, the <see cref="T:SuperOffice.CRM.ArchiveLists.ExplicitParticipantsAssociateProvider" /> subchannel), used in the Assign To dialog, has a groupRestrictionId restriction that correctly decodes these special values.

userplan

List provider for the UserPlan in the module license table. Returns all user plans except the one specified by additional-info "exclude_id"

usertype

Simple, hard-coded provider for the associate type - Employee, ExternalPerson, Resource, Anonymous, System, Invalid User Type

visiblefor

List provider for the VisibleFor dropdown control. Items are of type associate, usergroup or all, with a separate id space for each type. The current associate, its primary and secondary groups, and 'all' are the returned elements. MDO list sorting preferences for the UserGroup list are respected.

visibleforassociate

List provider that returns a list suitable for VisibleFor and PinTo (with groups and possibly some other special items like All).

visiblein

Visible in list for web panels.

visibleinmenu

Visible in menu list - Toolbox menu, View menu

visibleintask

Visible in list for tasks - places where task button can appear.

webhookentitylist

webhookeventlist

webpanel

List of WebPanels visible possible for use with groups and headings.

webpanelgroup

List of WebPanels with visible for groups as commaseperated ids in extrainfo field. This list only makes sence if the setting use groups and heading are turned on for

weekday

MDO provider for the hard-coded list of week days.

weeknumber

MDO provider for the hard-coded list of numbered weeks in the recurrence dialog.

workflowdefinitionstatus

MDO provider for the WorkflowDefinitionStatus enum

workflowgoaltype

MDO provider for the WorkflowGoalType enum

workflowinstancestatus

MDO provider for the WorkflowInstanceStatus enum

workflowsplitoptiontype

MDO provider for the WorkflowTriggerType enum

workflowsteptype

MDO provider for the WorkflowStepType enum

workflowtimewaitalgorithm

MDO provider for the WorkflowTimeWaitAlgorithm enum

workflowtimewaitintervaltype

MDO provider for the WorkflowTimeWaitIntervalType enum

workflowtriggertype

MDO provider for the WorkflowTriggerType enum

y_car

Extra tables lists. List names are 'y_xyz' - based on the custom table name. Contents of the list are based on the display_field for the table