This documentation supports the 21.05 version of Action Request System.
To view an earlier version, select the version from the Product version menu.

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 optionMid TierProgressive ViewAdditional information
Submit(tick)(tick)
Modify(tick)(tick)
Search(tick)(tick)
Display(tick)(tick)
Set Default(tick)(tick)
After Submit(tick)(error)
After Modify(tick)(error)
Copy to New(tick)(error)
Un-Display(tick)(error)
Window Closed(tick)(tick)
Window Open(tick)(tick)
Window Loaded(tick)(tick)
Event(tick)(tick)
Collapse(tick)(error)
Expand(tick)(error)
Drag(tick)(error)
Drop(tick)(error)
Applicable only when Progressive Views are accessedMid TierProgressive View

Run in parallel

(error)(tick)

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(error)(tick)
Bulk with Entry(error)(tick)
Bulk with Group (error)(tick)
Field Execution optionMid TierProgressive View
Gain Focus(tick)(tick)
Lose Focus(tick)(tick)
Return(tick)(tick)
Menu Choice(tick)(tick)
Table Refresh(tick)(tick)
Hover On Field(tick)(error)
Hover On Data(tick)(error)
Hover On Label(tick)(error)
Collapse(tick)(error)
Expand(tick)(error)
Drag(tick)(error)
Drop(tick)(error)
Button/Menu Field (tick)(tick)
Level Choice (tick)(error)
Level Double Click or Return  (tick)(error)
Row Choice  (tick)(tick)
Row Double Click or Return (tick)(error)

Progressive View Field Events

Mid TierProgressive View
On Content Change(error)(tick)
On Clear(error)(tick)
On URL Click(error)(tick)
On Row Unselect(error)(tick)
On Row Expansion(error)(tick)
On Row Collapse(error)(tick)
On Attachment Start(error)(tick)
On Attachment End(error)(tick)
On Attachment Cancel(error)(tick)
On Table/Column Filter Change (error)(tick)

Change Field > Add Action

Mid TierProgressive View
Call Guide(tick)(tick)
Change Field(tick)(tick) 

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

  • Change the field access type (tick) (except for tables).
  • Change the label font. (error)
  • Hide or display the field. (tick)
  • Expand or collapse tree levels. (error)
  • Expand or collapse a panel field.(error)
  • Specify a different menu for a character field. (tick)
  • Change the field label.(tick)
  • Change the color of the field label. (error)
  • Hide or show the field borders, Expand Box and Menu Box. (error)
  • Change the field entry mode to Required.(tick)
  • Move the focus (cursor) to the field.(tick)
  • Refresh a list view or tree view table field.(tick)
Close Window(tick)(tick)
Commit Changes(tick)(tick)
DDE(error)(error)
Direct SQL(tick)(error)
Exit Guide(tick)(tick)
Go To(tick)(tick)
Go to Guide Label(tick)(tick)
Message(tick)(tick)
Open Window(tick)(tick)

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

  • Dialog (tick)
  • Search (tick)
  • Submit (tick)
  • Modify (tick) (Display Type list is not supported)
  • Display  (error) 
  • Report (error)
  • Modify Directly (error) 
  • Display Directly (error)
  • Popup (tick) (Opens the window as a docked panel)
Push Fields(tick)(tick)
Run Macro(error)(error)
Run Process (tick)(tick)
Service(tick)(tick)
Set Fields(tick)(tick)In the Data Source list, SQL is not supported.
Set Fields is not supported for Table Field.
Wait(error)(error)

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. 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 IDStatusImage file path in Mid TierImage file path in PWA
    INC0000001Approved./resources/standard/images/img1../resources/standard/images/img1
    INC0000002Rejected./resources/standard/images/img2../resources/standard/images/img2
Was this page helpful? Yes No Submitting... Thank you

Comments

  1. Daniel Yrell

    Is there any documentation on how to use PERFORM-ACTION-TABLE-COLUMN-SET-DISPLAY-TYPE in PWA. I have tested with giving PERFORM-"ACTION-TABLE-COLUMN-SET-DISPLAY-TYPE TABLE-ID COLUMN-ID 1" for example. It would be great if the run processes got updated and with examples here on docs.

    Jan 05, 2024 02:48
    1. Chaitanya Vikas Ghanta

      Hi Daniel, 
      Thanks for your feedback. I am working on your suggestion.

      Regards,
      Chaitanya

      Jan 12, 2024 05:33