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.

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

Additional information

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

Additional information

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 

✅️

❌️


Set Focus for Progressive Views

❌️

✅️

This option is available only for Trim Text in Progressive View.

Progressive View Field Events

Mid Tier

Progressive View

Additional information

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

Additional information

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

❌️

❌️


Message 

Mid Tier

Progressive View

Additional information

Success

image-2023-11-30_14-12-33.png

✅️

❌️

In PWA, you must use Note with Number set to 52001 to display an out-of-the-box success message.

image-2023-11-30_14-22-36.png

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

You cannot add one function within another in Progressive View for PWA.

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, limitations, and behaviors

PWA screens have the following capabilities, limitations, and behaviors:

  • 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.
  • You cannot display group count for table groups in PWA.
    In the table properties, under Property > Attributes > Sort / Levels, the Count option in the Sort / Levels dialog is not supported in PWA.
  • You cannot use editable cell-based tables in PWA. 
  • If you create an active link that uses the Set Field option to add a table field to a character field, PWA screens show the following behaviors:
    • If the table field has any values, the character field is set to True.
    • If the table field has no values, the character field is set to False.
  • Web Content Header and Web Content Footer properties are not supported on PWA screens.
  • You can use the following JavaScript to trigger an event through a template on PWA screens:  

    parent.DView.SendSignalToParent(undefined, eventType, eventData);

    Example:

    function handleTitleClick()
    {

    eventData['entityType'] = "INC0000000001";
                    if(parent.DView.SendSignalToParent)
    {

                        parent.DView.SendSignalToParent(undefined, eventType, eventData);
    }
    }

    In the JavaScript, eventType is a string and eventData is JSON. eventType and eventData get mapped to EVENTTYPE and EVENTDATA keywords.

  • 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

Localization

The following similarities and differences exist when performing localization of Mid Tier applications and PWA:


Update the AR System
Message Catalog form

Perform flush cache after updating the 
AR System Message Catalog form

Mid Tier

✅️

 ❌️ 

PWA

✅️

✅️

Date and time format in PWA and Mid Tier for Regional locales of English

Even though the CCS parameters useARUserPreferenceForDateTimeFormat and useARUserPreferenceForLocalization are both set to true, dates are displayed differently in PWA and Mid Tier as indicated by underlined text in the following table:

En_US

View

PWA

Mid Tier

Difference

Long format

June 14, 2024 3:54:41 PM

Friday, June 14, 2024 3:54:41 PM

Month and date appears first in PWA.

Short format

06/14/2024 3:54:41 PM

6/14/2024 3:54:41 PM

A zero precedes the digit in PWA when the date is a single digit.

En_AU

View

PWA

Mid Tier

Difference

Long format

14 June 2024 3:54:41 PM

Friday, 14 June 2024 3:54:41 pm

Month and date appears first in PWA.

Short format

14/06/2024 3:54:41 PM 

14/06/2024 3:54:41 pm

None.

En_CA

View

PWA

Mid Tier

Difference

Long format

June 14, 2024 3:54:41 PM

June 14, 2024 3:54:41 p.m. 

None.

Short format

2024-06-14 3:54:41 PM

14/06/2024 3:54:41 p.m.

Date format is different in PWA.

Menus

Only search menus (Menus > New Search Menu) are supported on PWA screens. You cannot create other menus, for example, character menu, file menu, SQL menu, and so on in PWA.

Instead of using an SQL menu which is not supported for PWA, you can perform the following workaround:

  1. Create a custom view form by using the SQL query.
    For more information, see Creating-and-modifying-view-forms.
  2. Create a custom search menu which pulls information or records from this custom form.
    For more information, see Creating-search-menus.
    Use this custom search menu instead of the SQL menu.

PWA screen layout in tablets and mobiles

The illustrations in the following table show how the UI layout varies according to the device and screen size:

Device 

UI layout

Desktops and tablet screens

Desktops and tablet screens

UI layout on desktops and tablets

Mobiles screens

Mobile device

UI layout on mobile screens

From the illustrations, you can see that PWA screens have the same layout in tablet views and desktop views. PWA screens display the mobile view only when you view the application screens on mobiles. As a result, you may see differences in how the application layout is displayed on tablets and desktops when compared to mobiles. 

 

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