• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

ExtApp Table (133)

Some tooltip text!
• 9 minutes to read
 • 9 minutes to read

ExtApp MDO list item table. ExtApp list table. Applications startable from SuperOffice

Fields

Name Description Type Null
ExtApp_id Primary key PK
name The list item String(239)
rank Rank order UShort ●
tooltip Tooltip or other description String(254) ●
deleted 0 -> record is active 1 -> record is 'deleted' and should not be shown in lists UShort ●
path Path where the programfile is located; if empty, PATH is used String(239) ●
filename Filename of the programfile String(239)
parameters <template variable> <other template variable> String(239) ●
workdir Directory set to current when loading the application, if different from application's own String(239) ●
icon 0 indicates default Icon (from app exe file), otherwise reference to a predefined icon resource in SO UShort ●
availableInState When should this application be available from SO: 0=always, 1=on central db, 2=on travel db,4 on satellite. The value 5 (1+4) indicates that this application is available when logged in to a central or satellite db Enum AppAvailState
executeOnEvent Events that cause automatic execution of this app Enum ExecuteOnEvent
navigation 0=from menu, 1 = from Navigator(integration), 2 = From navigator Enum Navigation
showState Maximized / minimized / restored Enum ShowState
registered Registered when UtcDateTime
registered_associate_id Registered by whom FK associate
updated Last updated when UtcDateTime
updated_associate_id Last updated by whom FK associate
updatedCount Number of updates made to this record UShort
appType Application type: 1 = exe, 2 = integrated html, 3 = integrated url, 4 = browser url, 5 = external url Enum AppType ●
waitToFinish If 1, we wait synchronously for the pplication to finish before we go on Bool ●
windowName The window which the URL address is to open in (webpanel only) String(254) ●
url1 URL, supports long strings up to 1k String(1023) ●
url2 Obsolete - do not use this field String(254) ●
configInfo Extra configuration information String(2047) ●

ExtApp table relationship diagram

Value for the availableInState field in table ExtApp

The enums here may be combined.

availableInState ID Comment
Always 0 This application is always available
Central db  1 This application is only available on the Central database
Satellite db 2 This application is only available on a Satellite database
Travel db 4 This application is only available on a Travel database
Sales & Marketing web 8 This application is available on Sales & Marketing Web

Value for the executeOnEvent field in table ExtApp

executeOnEvent ID Comment
Never 0 This application is never executed automatically
Log on  1 Execute this application during logon
Log off 2 Execute this application before logoff
LocalUpdate 3 Execute this application before a local update (start travelling)
Wait 16384 When executing this application, wait for it to start
ShowState ID Comment
Minimized 0 Start application in minimized state
Maximized 1 Start application in maximized state
Default 2 Start application with default window size and position
Toolbar 256 Show the Browser toolbar
AddressBar 512 Show the Browser addressbar (where the user can type URLs)
StatusBar 1024 Show the Browser statusbar
MenuBar 2048 Show the Browser Menu bar (currently not implemeted)

Value for the navigation field in table ExtApp

navigation ID Comment
Invisible 0 This application is always available
ToolboxMenu  1 This application is only available on the Central database
NavigatorButton 2 This application is only available on a Satellite database
ViewMenu 3 This application is only available on a Travel database
SelectionTaskCard 4 (not yet implemented) This application appears as a Task in the Selection Task
ContactCard 5 This application (type IntegratedHTML or IntegratedURL) appears as a tab on
ContactArchive 6 This application (type IntegratedHTML or IntegratedURL)  appears as a tab on
ProjectCard 7 This application (type IntegratedHTML or IntegratedURL)  appears as a tab on
ProjectArchive 8 This application (type IntegratedHTML or IntegratedURL)  appears as a tab on the Project Archive
SaleCard 9 This application (type IntegratedHTML or IntegratedURL)  appears as a tab in
PersonDialog 10 This application (type IntegratedHTML or IntegratedURL)  appears as a tab in
ActivityDialog 11 This application (type IntegratedHTML or IntegratedURL)  appears as a tab in
DocumentDialog 12 This application (type IntegratedHTML or IntegratedURL)  appears as a tab in
BrowserPanel 13 In the Browser panel
ContSelectionTask 14 Task button visible on the Contact Selection task panel
AppntSelectionTask 15 Task button visible on the Appointment Selection task panel
SaleSelectionTask 16 Task button visible on the Sale Selection task panel
DocSelectionTask 17 Task button visible on the Document Selection task panel
ProjSelectionTask 18 Task button visible on the Project Selection task panel
CompanyMinicard 19 In company minicard
ProjectMinicard 20 In project minicard
DiaryMinicard 21 In diary minicard
SelectionMinicard 22 In selection minicard
ButtonPanelTask 23 In the main ButtonBar
AppointmentDialogTask 24 In the appointment dialog
SaleDialogTask 25 In the sale dialog
DocumentDialogTask 26 In the document dialog
PersonDialogTask 27 In the person dialog
SaleMinicard 28 In the sale minicard
SaleArchive 29 In the sale archive
AppntSelectionShadowTask 30 Task tab for appointment selection, while showing shadow selection
SaleSelectionShadowTask 31 Task tab for sale selection, while showing shadow selection
DocSelectionShadowTask 32 Task tab for document selection, while showing shadow selection
ProjSelectionShadowTask 33 Task tab for project selection, while showing shadow selection
DiaryArchive 34 Context (popup) menu in Diary archive
SelectionContactArchive 35 Context (popup) menu in Contact selection
SelectionProjectArchive 36 Context (popup) menu in Project archive
SelectionSaleArchive 37 Context (popup) menu in Sale archive
SelectionAppointmentArchive 38 Context (popup) menu in Appointment archive
SelectionDocumentArchive 39 Context (popup) menu in Document archive
ContSelectionCustomTask 40 Task card in Contact selection, when a custom archive is shown
AppntSelectionCustomTask 41 Task card in Appointment selection, when a custom archive is shown
SaleSelectionCustomTask 42 Task card in Sale selection, when a custom archive is shown
DocSelectionCustomTask 43 Task card in Document selection, when a custom archive is shown
ProjSelectionCustomTask 44 Task card in Project selection, when a custom archive is shown
CustomArchiveMiniCard 45
SelectionCard 46
ReportMinicard 47 In the Reporter panel minicard, so far only in Web
QuoteDialog 48
QuoteDialogTask 49
QuoteDialogArchive 50
QuoteLineDialogTask 51
QuoteLineDialog 52
QuoteLineSelectionMainTask 53
QuoteLineSelectionShadowTask 54
SelectionQuoteLineArchive 55
QuoteLineSelectionCustomTask 56
FindSystem 57

Indexes

Fields Types Description
ExtApp_id PK Clustered, Unique
name String(239) Unique

Relationships

Table Description
associate Employees, resources and other users - except for External persons
document Documents, this table is an extension of the Appointment table. There is always a corresponding appointment record; the relation between appointment and document is navigable in both directions. A document-type appointment record always has a corresponding document record and a record in VisibleFor specifying who may see this.
ExtAppGroupLink User group link table for ExtApp, for MDO item hiding
ExtAppHeadingLink Heading link table for ExtApp, for MDO headers

Replication Flags

  • Replicate changes DOWN from central to satellites and travellers.
  • Replicate changes UP from satellites and travellers back to central.
  • Copy to satellite and travel prototypes.

Security Flags

  • No access control via user's Role.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top