Widgets

DUO uses doc-able widgets for almost everything.  This means they can be reused in multiple screens.

·         Defining/designing these widgets is similar to MYOB Exo widgets but with extra parameter capabilities.

·         Widgets are stored in the same DASHBOARDS table as the MYOB Exo widgets so the DUO Widget maintenance screen can also see these. 

·         For a widget to be DUO-only simply set Exo Modula availability to none (un-tick all modules).

·         Widget classes are the same as for MYOB Exo:

Class No

Type

Description

1

Clarity

Preview a Clarity report in a window

2

URL

Display a web page or file

3

Form  {Frame }

A specialist widget supported by program code

4

Pivot

A Pivot chart

5

Grid

A data grid

6

Unused

 

7

Check List

A check list of things to do

·         Widgets of Class Form require supporting program code. The supporting code in MYOB Exo and DUO for various form types is different so are incompatible.

·         Unlike MYOB Exo, Grid widgets may also specify a Frame name to run a specialist frame that enhances the Grid (e.g. History notes show the highlighted grid line properties in a panel below the grid) .

·         DUO installs with over 80 additional widgets that are essential for running the Forms/Windows that are also installed.

To illustrate maintenance of one of the more complex widgets we will choose the one for orders of type Stock Loan.  Note that DUO uses the same Frame (program code) to drive all order type widgets.

The Detail tab is similar to the MYOB Exo Widget maintenance screen; however SQL parameters are maintained in separate Header and Grid tabs. 

·         The Header tab only appears for widgets of type Form.

·         The Grid tab will appear for widgets of classes Form, Pivot and Grid

Details Tab

The details tab has the following properties.

Field

Description

Widget Name

Name of the widget

This is not the widget caption. The Caption is defined on each Form

Widget Type

Combo Box to select widget type

Refresh Freq

Exo only. Not used in DUO.

Exo Modules

CheckListBox of valid Exo Modules. All unchecked = DUO only

Frame Name

Name of programmatic driver frame

Grid Click To

For Exo only. Not used in DUO

Security Profiles

CheckListBox of valid Security Profiles. DUO only. {not implemented yet}

Settings

A Notepad containing various {free format} parameters. These will vary based on widget type. See list below.

 

Widget Classes

Widget classes are the same as for MYOB Exo:

Class No

Type

Description

1

Clarity

Preview a Clarity report in a window

2

URL

Display a web page or file

3

Form  {Frame }

A specialist widget supported by program code

4

Pivot

A Pivot chart

5

Grid

A data grid

6

Unused

 

7

Check List

A check list of things to do

 

Frame Names

DUO has a default Frame for each widget class. Frame Name is optional.

Exo Frame

 SalesSummary

InvoiceList

OrderList

StockSummary

ActivitySearch

RecentItems

Opportunity Search

Company Search

Contacts Search

StocksSearch

ContactQuickAdd

CompanyQuickAdd

OpportunityQuickAdd

ActivityQuickAdd

BudgetPivotWidget

MyLinkedIn

MyFaceBook

MyTwitter

CampaignSearch

ControlAccRecon

GeneralLedgerGraph

StockAnalysis

DebtorAnalysis

CreditorAnalysis

GLAnalysis

DUO Frame

ContactForm

DesignForm

DocumentForm

EmailForm

EntityForm

ExtraFieldsForm

GLForm

ManifestForm

PickListForm

PolicyForm

StaffForm

StockForm

SUForm

TaskForm

WidgetForm

OpportunityForm

OrderForm

HistNote

GenericForm

 

Settings

SQL settings are only displayed on the Header and Grid tabs. All other settings are shown in the Settings notepad on the Details tab.

Setting

Applies To

Description

ReportName

Clarity

e.g. DashCRAgedBals.CLR /A=Y

ZoomSetting

Clarity

A numeric percentage

URL

URL

A hyperlink or file link

ColWidths

Form, Grid

Comma separated list of column widths (pixels)

ColClasses

Form, Grid

Comma separated list of column Classes

  Classes can be Entities, Functions, or Formats

  e.g.  eptStock, faNartv (narrative link),  fmtQty (format)

ColEditors

Form

Comma separated list of editor types (IDed by number)

  A bank entry means non-editable

Control

Form

Link a form control to a header SQL column

  Optionally change the Entity class

  e.g. Control=edbAccount=0=eptDebtor (default is eptCoy)

  Account editbox is linked to column 0 of the SQL, is Debtor

  e.g. Control=memoAddress=7

  Address memo is linked to columns 7-12

Caption

Form

Optionally change the caption associated with a control

  e.g. Caption=lblAccount=Debtor (default is Account)

{various}

Pivot

These should only be changed via Exo

StatusTable

Checklist

e.g. CL_END_OF_PERIOD

ContextID

Checklist

e.g. GL Period

ContextTableName

Checklist

e.g. PERIOD_STATUS

ContextKeyFieldName

Checklist

e.g. SEQNO

ContextDisplayFiledName

Checklist

e.g. PERIODNAME

WhereClause

Checklist

e.g. LEDGER=’G’

OrderByFieldNames

Checklist

e.g. AGE

 

Header Tab

This shows the SQL used to read header rows in header/lines type widgets such as those with Frame = OrderForm

Note: These are mapped to form controls with the Control= entries on the Details tab.

Grid Tab

This shows the SQL associate with the widget’s grid. For widgets such as those with Frame=OrderForm, this is the SQL for the order lines grid.

The bottom grid is populated by the Check toolbar button

Note that Col Width, Attribute (Class), and Editor are specified on the Details tab.

DUO for EXO     DUO for EXO     © Dyameta Technology Ltd                     Previous Topic           Next Topic           Home