Differences between Developer Studio features available for Mid Tier and Progressive Web Applications

Developer Studio has many features available for application development such as active links, run process commands, functions, and keywords. Many of these features are available in Progressive View (PV) in Developer Studio for creating Progressive Web Applications (PWAs). The following sections provide a comparative list of features available in Mid Tier and Progressive View.

Related topics

Creating-active-links

Defining-Change-Field-active-link-actions

Process-commands

Keywords

Functions

Specifying-parameters-in-URLs

Passing-data-to-a-field-in-a-URL

Using-Run-Process-for-the-web

Differences in active links available in Mid Tier and Progressive View

The following table lists the active links supported in Mid Tier and Progressive View in Developer Studio.

Active link execution option

Mid Tier

Progressive View

Additional information

Submit

✅️

✅️


Modify

✅️

✅️


Search

✅️

✅️


Display

✅️

✅️


Set Default

✅️

✅️


After Submit

✅️

❌️


After Modify

✅️

❌️


Copy to New

✅️

❌️


Un-Display

✅️

❌️


Window Closed

✅️

✅️


Window Open

✅️

✅️


Window Loaded

✅️

✅️


Event

✅️

✅️


Collapse

✅️

❌️


Expand

✅️

❌️


Drag

✅️

❌️


Drop

✅️

❌️


Applicable only when Progressive Views are accessed

Mid Tier

Progressive View


Run in parallel

❌️

✅️

In Progressive View, this type of active link is applicable only for the following events:

  • Display
  • Window Open
  • Window Loaded
  • Menu Choice 

Don't wait for completion

❌️

✅️


Bulk with Entry

❌️

✅️


Bulk with Group 

❌️

✅️


Field Execution option

Mid Tier

Progressive View


Gain Focus

✅️

✅️


Lose Focus

✅️

✅️


Return

✅️

✅️


Menu Choice

✅️

✅️


Table Refresh

✅️

✅️


Hover On Field

✅️

❌️


Hover On Data

✅️

❌️


Hover On Label

✅️

❌️


Collapse

✅️

❌️


Expand

✅️

❌️


Drag

✅️

❌️


Drop

✅️

❌️


Button/Menu Field 

✅️

✅️


Level Choice 

✅️

❌️


Level Double Click or Return  

✅️

❌️


Row Choice  

✅️

✅️


Row Double Click or Return 

✅️

❌️


Progressive View Field Events

Mid Tier

Progressive View


On Content Change

❌️

✅️


On Clear

❌️

✅️


On URL Click

❌️

✅️


On Row Unselect

❌️

✅️


On Row Expansion

❌️

✅️


On Row Collapse

❌️

✅️


On Attachment Start

❌️

✅️


On Attachment End

❌️

✅️


On Attachment Cancel

❌️

✅️


On Table/Column Filter Change 

❌️

✅️


Change Field > Add Action

image2022-8-12_21-28-46.png

Mid Tier

Progressive View


Call Guide

✅️

✅️


Change Field

✅️

✅️ 

Based on conditions when the active link executes and on the field type, the options which have the check mark (✅️) are supported in PWA:

  • Change the field access type ✅️ (except for tables).
  • Change the label font. ❌️
  • Hide or display the field. ✅️
  • Expand or collapse tree levels. ❌️
  • Expand or collapse a panel field.❌️
  • Specify a different menu for a character field. ✅️
  • Change the field label.✅️
  • Change the color of the field label. ❌️
  • Hide or show the field borders, Expand Box and Menu Box. ❌️
  • Change the field entry mode to Required.✅️
  • Move the focus (cursor) to the field.✅️
  • Refresh a list view or tree view table field.✅️

Close Window

✅️

✅️


Commit Changes

✅️

✅️


DDE

❌️

❌️


Direct SQL

✅️

❌️


Exit Guide

✅️

✅️


Go To

✅️

✅️


Go to Guide Label

✅️

✅️


Message

✅️

✅️


Open Window

✅️

✅️

This includes the following window types, , you can use the following options which have check mark (✅️) in PWA:::

  • Dialog ✅️
  • Search ✅️
  • Submit ✅️
  • Modify ✅️ (Display Type list is not supported)
  • Display  ❌️ 
  • Report ❌️
  • Modify Directly ❌️ 
  • Display Directly ❌️
  • Popup ✅️ (Opens the window as a docked panel)

Push Fields

✅️

✅️


Run Macro

❌️

❌️


Run Process 

✅️

✅️


Service

✅️

✅️


Set Fields

✅️

✅️

In the Data Source list, SQL is not supported.
Set Fields is not supported for Table Field.

Wait

❌️

❌️


Process commands available in Progressive View for creating PWA

The following process commands are available in Progressive Views in Developer Studio for creating PWA. For the complete list of process commands available for Mid Tier applications and PWA, see Process-commands.

  • PERFORM-ACTION-ADD-ATTACHMENT
  • PERFORM-ACTION-SAVE-ATTACHMENT
  • PERFORM-ACTION-DELETE-ATTACHMENT
  • PERFORM-ACTION-OPEN-ATTACHMENT
  • GET-DIRTY-FIELDS
  • PERFORM-ACTION-OPEN-URL
  • PERFORM-ACTION-TABLE-REFRESH
  • PERFORM-ACTION-TABLE-NEXT-CHUNK
  • PERFORM-ACTION-TABLE-PREV-CHUNK
  • PERFORM-ACTION-TABLE-CLEAR
  • PERFORM-ACTION-TABLE-SORT
  • PERFORM-ACTION-TABLE-COLUMN-SET-DISPLAY-TYPE
  • PERFORM-ACTION-SEND-EVENT
  • PERFORM-ACTION-ACTIVE-LINK
  • PERFORM-ACTION-GET-FIELD-LABEL
  • PERFORM-ACTION-GET-FIELD-ALTERNATIVE-TEXT
  • APPLICATION-GENERATE-GUID
  • PERFORM-ACTION-TABLE-ADD-ROW
  • PERFORM-ACTION-TABLE-SELECTALL
  • PERFORM-ACTION-TABLE-DESELECTALL
  • PERFORM-ACTION-TABLE-DELETE-ROW
  • PERFORM-ACTION-TABLE-CLEAR-DELETED
  • PERFORM-ACTION-TABLE-DISABLE-ROW-REORDERING
  • PERFORM-ACTION-TABLE-ENABLE-ROW-REORDERING
  • PERFORM-ACTION-TABLE-RESET-ROW-REORDERING
  • PERFORM-ACTION-TABLE-ROW-SELECTION-MODE
  • PERFORM-ACTION-GET-ENTRY
  • SET-CHANGE-FLAG
  • GET-CHANGE-FLAG
  • SET-CHANGE-FLAG 
  • APPLICATION-GENERATE-GUID 
  • JAVASCRIPT
    This command requires adding a colon and space right after JAVASCRIPT when using the command in Progressive View.
    For example,
    JAVASCRIPT: alert("Hello")
  • PERFORM-ACTION-SET-AUTOCOMPLETE-KEYSTROKE
  • ENABLE-WAIT-CURSOR-ON-LONG-RUNNING-PROCESS
  • APPLICATION-QUERY-DELETE-ENTRY
  • APPLICATION-COMMAND
  • PERFORM-ACTION-SET-BROWSER-TITLE
  • PERFORM-ACTION-SET-HEADER
  • PERFORM-ACTION-NESTED-TABLE-ENABLE-ROW-REORDERING
  • PERFORM-ACTION-NESTED-TABLE-DISABLE-ROW-REORDERING
  • PERFORM-ACTION-NESTED-TABLE-RESET-ROW-REORDERING
  • PERFORM-ACTION-TABLE-GET-SELECTED-COLUMN
  • PERFORM-ACTION-TABLE-IS-LEAF-SELECTED
  • PERFORM-ACTION-VALIDATE-NULL-REQUIRED-FIELDS
  • PERFORM-ACTION-FETCH-SURVEY-DATA
  • PERFORM-ACTION-TABLECOLUMN-GET-FILTERQUAL
  • APPLICATION-CONFIRM-GROUP
  • CHANGE_HOTKEY_MENU
  • SET_MIN_DATE
  • APPLICATION-DELETE-ENTRY

Keywords available in Progressive View for creating PWA

The following keywords are available in Progressive View for creating PWA and keywords not in this list are available only for Mid Tier applications. For the complete list of keywords available for Mid Tier applications, see Keywords.

  • NULL
  • DEFAULT
  • CURRENTTIMESTAMP
  • TIMESTAMP
  • TIME
  • DATE
  • WEEKDAY
  • USER
  • GROUPS
  • LOCALE
  • CLIENT-TYPE
  • HOMEURL
  • GROUPIDS
  • SCHEMA
  • SERVER
  • OPERATION
  • VUI
  • ROLES
  • EVENTTYPE
  • EVENTDATA
  • EVENTSRCWINID
  • CURRENTWINID
  • LASTOPENEDWINID
  • ROWSELECTED
  • LASTCOUNT
  • LASTID
  • ROWCHANGED
  • ROWVISIBLE
  • GUIDE
  • CURRENTROWINDEX
  • PREVIOUSROWINDEX
  • CROSSLAUNCH
  • PRINTMODE
  • CROSSLAUNCHCONTEXT
  • LASTMENUVALUE
  • LASTMENURUN
  • OS
  • DATABASE
  • SERVERTIMESTAMP
  • TCPPORT
  • VERSION
  • VUI-TYPE
  • FIELDLABEL
  • FIELDNAME
  • BROWSER
  • SHIFT_KEY
  • ALT_KEY
  • CTRL_KEY
  • SCHEMA-ALIAS
  • SURVEYQUESTION_CURRENTID
  • SURVEYQUESTION_LASTRESPONSE
  • SURVEYQUESTION_CURRENTRESPONSE
  • TARGET_FORM
  • TARGET_VIEW
  • TARGET_ID

Functions available in Progressive View for creating PWA

The following functions are available in Progressive View for PWA. For a complete list of all functions and their descriptions, see Functions.

  • LOWER
  • UPPER
  • LTRIM
  • RTRIM
  • LENGTH
  • LENGTHC
  • LEFT
  • LEFTC
  • RIGHT
  • RIGHTC
  • STRSTR
  • STRSTRC
  • REPLACE
  • LPAD
  • LPADC
  • RPAD
  • RPADC
  • SUBSTR
  • SUBSTRC
  • MAPGET
  • COLAVG
  • COLCOUNT
  • COLSUM
  • COLMIN
  • SELECTEDRCOUNT
  • COLMAX
  • VISIBLERO
  • DROPPEOLUMNINDEX
  • DROPPEOWINDEX
  • TRUNC
  • DATE
  • DATEADD
  • DATEDIFF
  • DATENAME
  • DATENUM
  • DAY
  • HOUR
  • MINUTE
  • MONTH
  • SECOND
  • TIME
  • YEAR
  • WEEKDAY
  • LISTGET
  • LISTSIZE
  • ROUND
  • GETSURVEYSTATUS
  • ISTABLESELECTALLCHECKED
  • JSONMAP

Specifying parameters in URL

The following functions are not supported in Progressive View for PWA:

  • form (required)
  • view
  • app
  • server (required)
  • mode
  • eid
  • qual
  • username
  • pwd
  • auth

The following functions are supported in Progressive View for PWA:

  • origin
  • targetForm
  • targetView
  • mode
  • targetId
  • rand
  • entryId
  • context

Capabilities and limitations

PWA screens have the following capabilities and limitations:

  • You cannot use fields with menus attached inside a cell-based table in PWA.
  • You cannot use Table Field with Set Field active links.
  • The Wrap Text display property for a table field in PWA only works at the table level. 
    You cannot use the Wrap Text display property at column level. This means that you can implement wrap text only for an entire table and not to individual columns.
  • If you want to create a table row that is selectable to users, you must add check boxes or radio buttons to the table rows. Application users can click the check boxes or radio buttons to select the rows. 
    In Developer Studio, for the table field, set the Display Type > Row Selection property to Multiple to enable checkboxes in the table rows.
    Similarly, set the Row Selection property to Single to enable radio buttons in the table rows
  • Only Integer fields, Character fields, Button fields, Decimal fields, and Real fields are supported for table columns having edit mode.
  • Web Content Header and Web Content Footer properties are not supported in PWA screens.

  • The context for dynamic image loading for PWA screens is arsys/pwa, while it is arsys for Mid Tier. The file path should be created likewise for dynamic image loading.
    The following table shows how an image file path should be specified in Mid Tier and PWA:

    Incident ID

    Status

    Image file path in Mid Tier

    Image file path in PWA

    INC0000001

    Approved

    ./resources/standard/images/img1

    ../resources/standard/images/img1

    INC0000002

    Rejected

    ./resources/standard/images/img2

    ../resources/standard/images/img2

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*